iamrealfarhanbd

Documentation: Using Excel Formulas in Ninja Tables

Ninja Tables supports various Excel formulas to manipulate data directly within the table. Below is a list of supported Excel formulas along with examples of how to use them in Ninja Tables.

Supported Excel Formulas:

For a comprehensive list of supported Excel formulas, please refer to Screenshot link.

Usage Example:

iamrealfarhanbd

Documentation: Display Entries Submitted by Current User in Ninja Tables

This guide will help you display only the entries submitted by the current logged-in user using the Ninja Tables plugin in WordPress.

Steps to Achieve Current User Entries Display

1. Add User Information to Table Column

Ensure that the table includes a column with the user's name, email, or any user unique identifier.

iamrealfarhanbd

add_filter('ninja_tables_get_public_data', function ($data, $tableId) {
    // Set the limit and filter name here (you can adjust these values as needed)
    $limit = Your_Limit_Value;
    $filter_name = 'Your_Filter_Key_Word';

    // Check if the current table ID matches the targeted table ID
    if ($tableId == 426) { // Replace 426 with the actual table ID
        // Apply the filter first

iamrealfarhanbd

add_filter('ninja_tables_get_raw_table_data', function ($data, $tableId) {
    // Adjust this condition based on your target table ID
    if ($tableId == YourTableID) { //Change YourTableID with your table ID
        foreach ($data as &$row) {
            foreach ($row as $key => $value) {
                // Check if the value is an array with 'image_thumb' and 'image_full' keys
                if (is_array($value) && isset($value['image_thumb']) && isset($value['image_full'])) {
                    // Replace the 'image_thumb' URL with the 'image_full' URL
                    $row[$key]['image_thumb'] = $value['image_full'];
                }

iamrealfarhanbd

jQuery(document).ready(function() {
    // Function to add goto page functionality
    function addGotoPageFunctionality() {
        // Check if the goto input field already exists
        if ($('#gotoPage').length === 0) {
            // Create the goto input field and button
            var gotoInput = $('<input>', { type: 'number', id: 'gotoPage', placeholder: 'Go to page', class: 'form-control', min: "1" , max: $('.footable-page').length,style: 'width:100px;padding:17px 0!important;text-align:center;' });
            var gotoButton = $('<button>', { id: 'gotoButton', class: 'btn btn-default', text: 'Go' });
            var gotoElement = $('<li>', { class: 'nt_goto_pager', 'aria-label': 'goto page', style: 'display:inline-flex!important;align-items:center;' }).append(gotoInput, gotoButton);

iamrealfarhanbd

// Hide the dash initially when the document is ready
jQuery(document).ready(function() {
    function removeDash() {
        jQuery('.ff-el-progress-status').each(function() {
            var text = jQuery(this).text().trim(); // Get the text content of the element
            var newText = text.replace('-', ''); // Remove the dash
            jQuery(this).text(newText); // Set the modified text back to the element
        });
    }
    removeDash();

iamrealfarhanbd

$(document).ready(function() {

    // Function to remove the unwanted portion from href attribute
    function removeUrlPortion() {
        let $table = $('.ninja_clmn_nm_product');// Replace YourColumnKey With your column key like = .ninja_clmn_nm_YourColumnKey
        $table.find('a').each(function() {
            let href = $(this).attr('href');
            // Check if href contains the unwanted portion
            if (href.includes('https://www.google.com/url?q=')) {
                // Remove the unwanted portion from href

iamrealfarhanbd

// Disable text selection with css
#footable_parent_NT_ID {
    user-select: none;
    -moz-user-select: none;
    -webkit-user-select: none;
    pointer-events: none;

}

/*********************

iamrealfarhanbd

add_filter('ninja_tables_before_update_settings', function ($columns, $tableId) {

    function modifyData($columns) {
        if (isset($_REQUEST['columns'])) {
            return $_REQUEST['columns'];
        } else {
            return $columns;
        }
    }
    

iamrealfarhanbd

jQuery(document).ready(function ($) {
    // Function to check if the success message is present
    function checkSuccessMessage() {
          jQuery('.kt-modal-content').each(function() {
        if ($(this).find('.ff-message-success').length > 0) {
            // Success message is present
            $(this).find('.nt_download_me').show();
            console.log('.nt_download button shown');
        } else {
            // Success message is not present