Wppool
  • Home
  • Products
    • Privacy Policy
  • DreamLab
  • Bundle
  • Offer
  • Help Centre
    • Support
+ Join Our Community Log In
Site Logo
  • Home
  • Products
    • Privacy Policy
  • DreamLab
  • Bundle
  • Offer
  • Help Centre
    • Support
My Account
  • WP Dark Mode
    WP Dark Mode

    A stunning WordPress Dark Mode experience

  • FlexTable
    FlexTablehot Wppool

    Automatically sync Google Spreadsheets with WP tables

  • FormyChat
    FormyChat

    Send contact form leads to WhatsApp

  • Stock Sync
    FlexStock hot Wppool

    Sync WooCommerce stock with Google Sheet and manage easily

  • Order Sync
    FlexOrder new ⚡

    Manage WooCommerce orders from Google Sheets

  • Easy Video Reviews
    Easy Video Reviews

    Get powerful video testimonials with ease and boost sales

  • EchoRewards
    EchoRewards new ⚡

    Referral Plugin for WooCommerce

  • Jisi Meet
    Jitsi Meet

    Webinar & video conferences within WordPress

  • FlexSync for Shopify
    FlexSync for Shopify new ⚡

    Manage Shopify inventory from Google Sheets

  • ArchiveMaster
    ArchiveMaster new ⚡

    Speed up your WooCommerce store by archiving old orders.

  • Chat Widgets
    OMG Chat Widget

    Let customers contact via any social channel

  • Stock Notifier
    Stock Notifier for WooCommerce

    Send alerts to customer when product is back in stock

  • Docs
  • Blogs
  • Video Tutorials
  • Join Community
  • Support & Contact

.

WP Dark Mode Documentation

29
  • WP Dark Mode – Common Issues & Troubleshooting
  • WP Dark Mode: PHP Hooks
  • How to Boost WP Dark Mode Performance
  • How to use Dark Mode in Classic Editor
  • How to enable Show Switch Delay and Auto-hide Switch on Idle
  • How to Get Started with WP Dark Mode (Free & Ultimate)
  • How to add a floating dark mode switch to your site
  • How to adjust your dark mode color scheme
  • How to Use a Dark Mode Color Preset
  • How to Build Your Custom Color Preset in Dark Mode
  • How to Use a Custom Dark Mode Switch
  • How to Use a Custom Dark Mode Switch (Advanced)
  • How to a Use Dark Mode Switch in Your Website Menu
  • How to Enable Content Switches Using WP Dark Mode
  • How to Exclude/Include Specific Elements in Dark Mode
  • How to Exclude Dark Mode on Specific Pages
  • How to Use Custom CSS Support in Dark Mode
  • How to Use the Image Replacement Feature of WP Dark Mode
  • How to Use the Video Replacement Feature of WP Dark Mode
  • How to Display Dark Mode Switch Using Elementor Widget
  • How to Display Dark Mode Switch Using Gutenberg Block
  • How to Adjust the Font Size on Your Website
  • How to Display Dark Mode Switch Using Shortcode
  • How to Change Your Website Background in Dark Mode
  • How to Display Social Sharing Buttons in Dark Mode
  • WP Dark Mode for Developers (Methods and Hooks)
  • How to Rollback Your WordPress Plugin to An Older Version
  • Use of Cookies in WP Dark Mode and their Applications
  • WPDarkMode JavaScript API

FlexTable - Sheets to WP Table Live Sync

24
  • FlexTable Performance Optimization
  • How to Enable Smart Caching in FlexTable
  • How to add buttons in WordPress tables
  • What is FlexTable – Sheets to WP Table Live Sync?
  • How to install and use Google Sheets to WP Table Live Sync
  • How to create a new table with Google Sheets to WP Table Live Sync
  • How to use shortcode to create tables in WordPress with Sheets to WP Table Live Sync
  • How to use Google Sheets to WP Table Live Sync with Gutenberg block
  • How To Display Tables Directly From Elementor With Google Sheets To WP Table Live Sync
  • How to create a new table theme with Sheets to WP Table
  • How to Customize Table Theme with Sheets to WP Table Live Sync
  • How to hide table rows and columns of Google Sheets table
  • How to use custom CSS support in Google Sheets to WP Table Live Sync
  • How to use the multiple tab feature on Google Sheets to WP Table Live Sync
  • How to import background and font color on Google Sheets to WP Table Live Sync
  • How to import images from Google Sheets to WordPress table with Sheets to WP Table Live
  • How to sync Google Sheets links with WordPress tables
  • How to customize table pagination in WordPress
  • How to Sort and Merge Cells in WordPress Tables.
  • How to Enable Optimized Loading (Pro)
  • How to change table styles (theme customization)
  • FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)
  • What impact does FlexTable have on SEO and Performance?
  • Why Does the Page Need to be Refreshed to Display Updates on the Website?

Stock Sync for WooCommerce with Google Sheet

9
  • How To Install Stock Sync for WooCommerce with Google Sheets
  • How To Install & Setup Stock Sync for WooCommerce with Google Sheets Ultimate
  • How to sync WooCommerce stock with Google Sheets
  • How to manage WooCommerce product details from Google Sheets
  • How to Bulk Edit WooCommerce products from Google Sheets
  • How to Add WooCommerce products from Google Sheets
  • How to Sync WooCommerce Product Image with Google Sheets
  • How to Sync WooCommerce Custom Fields with Stock Sync with Google Sheet for WooCommerce
  • Possible Errors and Solutions

Order Sync with Google Sheets for WooCommerce - FlexOrder

11
  • How to Install FlexOrder – Free & Ultimate
  • How To Setup FlexOrder
  • How to Sync Custom Order Statuses with Google Sheets
  • How to Sync Order Notes from Google Sheets
  • How to Display Products in Separate Rows in FlexOrder
  • How to Bulk Edit WooCommerce Orders Using Google Sheets
  • How to export WooCommerce orders to Google Sheets
  • How to manage WooCommerce orders from Google Sheets
  • How To Update WooCommerce Orders from Google Sheets
  • How To Sync WooCommerce Custom Order Fields
  • Known Errors & Solutions

Webinar and Video Conference with Jitsi Meet

19
  • How to Enable Meeting from Frontend with Jitsi Meet
  • How to install and use Jitsi Meet
  • How to activate Jitsi Meet PRO
  • How to get the app ID, API key, and private key in Jitsi Meet
  • How to create a meeting on Jitsi Meet Pro
  • How meeting registration works in Jitsi Meet
  • How recurring meeting works in Jitsi Meet
  • How to use shortcode to display meeting with Jitsi Meet
  • How to display Meeting directly from Gutenberg block and Elementor with Jitsi Meet
  • How to Use Jitsi Meet Free, JaaS 8×8 & Self Hosted Server
  • How to record meeting on Jitsi Meet
  • How to Add Jitsi Meeting in Dokan Multivendor Plugin with Jitsi Meet Multivendor Addon
  • How to Add Jitsi Meeting in MultiVendorX with Jitsi Meet Multivendor Addon
  • How to Add Jitsi Meeting in WCFM Marketplace with Jitsi Meet Multivendor Addon
  • How to do live streaming in Jitsi Meet
  • How to Add a Jitsi Meeting in Tutor LMS
  • How To Add a Jitsi Meeting in LearnPress
  • How to add Meeting in LearnDash LMS with Jitsi Meet
  • How to use LearnDash and Tutor LMS in Jitsi Meet

FormyChat Documentation

11
  • How to add Ninja Form to WhatsApp with FormyChat
  • How to Modify FormyChat Form Fields with the “formychat_form_fields” Hook
  • How to Customize FormyChat Widget
  • How to create Multi-Agent Chat Support Widget
  • How to create multiple floating chat widgets
  • How to install and setup FormyChat Ultimate
  • How to send contact form data to WhatsApp
  • How to install and setup FormyChat
  • How to send Contact Form 7 data to WhatsApp
  • How to send contact form leads to email
  • How to setup and customize the welcome popup (greetings widget)

Easy Video Reviews Documentation

14
  • How to get started with Easy Video Reviews (Onboarding steps)
  • How to collect a testimonial from customers
  • How to add testimonials on your website
  • How to update your Easy Video Reviews settings
  • How to create a Wall of Love testimonial page using Review Gallery
  • How to use Gutenberg for collecting and displaying video testimonials
  • How to use Elementor for collecting and displaying video testimonials
  • How to collect testimonials with a floating review widget
  • How to download testimonials with Easy Video Reviews
  • How to translate testimonial fields in Easy Video Reviews
  • How to create and edit review form fields
  • How to collect customer testimonials on WooCommerce
  • How to collect video testimonials on Easy Digital Downloads (EDD)
  • Advanced customizations: Javascript triggers, dynamic tag for testimonial recorder, HTML attribute for recorder button

EchoRewards

1
  • EchoRewards Documentation

OMG Chat Widget

4
  • How to use OMG Chat Widget in any WordPress website
  • How to use OMG Chat Widget in WooCommerce Multivendor Marketplace (WCFM Marketplace)
  • How to use OMG Chat Widget in Dokan – Best WooCommerce Multivendor Marketplace Solution
  • How to use OMG Chat Widget in MultiVendorX (Formerly WC Vendor Marketplace)

ArchiveMaster Documentation

10
  • How to Enable the PDO SQLite Extension in Your Server’s PHP Configuration
  • What is ArchiveMaster
  • How to Install & Use ArchiveMaster
  • How to Create an Amazon RDS Database for ArchiveMaster
  • How to Connect Amazon RDS Remote Database with ArchiveMaster
  • How to Enable Automatic Archiving for Old Orders
  • How to Archive Old order with ArchiveMaster
  • Choosing the Right AWS RDS Plan
  • How to Reset and Recover Your RDS Database Password
  • How to Export Old Orders Using ArchiveMaster

Revio Documentation

1
  • How to get started with Revio (Onboarding steps)
  • Home
  • Documentation
  • FlexTable - Sheets to WP Table Live Sync
  • FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)
View Categories

FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)

Importing codes from Google Sheets #

When working with code snippets in Google Sheets, it’s essential to format the content correctly to ensure it displays well both in the sheet and when exported to WP Table. This guide will walk you through the necessary steps to import code into WP Table from Google Sheets.

Step 1: Replace Commas with Text Emojis #

Our plugin works by retrieving data from Google Sheets in CSV format, where commas separate values. Commas can interfere with the CSV export and import process. 

This can lead to issues when your content contains commas, causing some data, like the “duration” column, to be removed or displayed incorrectly.

We recommend using a comma emoji (, or◞) instead of a regular comma. You can find options here.

Step 2: Handle Line Breaks with <br> Tags #

Google Sheets does not handle traditional code indentation or line breaks well. Instead of using standard line breaks or indentation in your code, you can use:

<br> Tags: Replace each line break in your code with the HTML <br> tag to maintain the code’s readability when viewed as a single line in the spreadsheet. Also, this ensures that the code appears correctly formatted within a single cell and remains readable.

Step 3: Enable Text Wrapping #

To make sure your code is easily readable within the cell, enable text wrapping in Google Sheets. To do that, select the cell(s) containing the code on Google Sheets and go to Format > Text wrapping > Wrap.

Text wrapping ensures that the code fits within the cell and wraps appropriately, making it easier to read.

Example Code:

FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)
console.trace() <br> console.time(); <br>for (let i = 0; i < 100000; i++) {<br>// some code<br> }
FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)
let i = 0; <br> console.time("while loop"); <br> while (i < 1000000) { <br>i++ <br>} <br>console.timeEnd("while loop");<br>console.timeEnd("while loop");<br>console.timeEnd("while loop");

By following these steps replacing commas with text emojis, using <br> tags for line breaks, and enabling text wrapping, you can successfully import and format code within Google Sheets. This method ensures that the code is both readable and retains its intended structure when viewed or exported.

FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)

How to Make Table Headers Sticky with CSS #

When working with WP data tables, it’s often helpful to keep the header visible as you scroll down the page. This guide will walk you through the steps to make the table header sticky by using CSS.

Step 1: Inspect the Table on the Page #

  1. Open the Page with the Table: Navigate to the page where your table is displayed.
  2. Inspect the Table Element:
    • Right-click on the table and select “Inspect” or “Inspect Element” from the context menu. This will open the browser’s developer tools.
    • In the developer tools, find the table element in the HTML structure. You will need to identify the table’s unique ID or class to target it with CSS.
  3. Find the Table’s ID:
    • Look for an ID or class assigned to the table  container. For instance, if the table has an ID like gswpts_table_92, this will be the identifier you use in your CSS.
FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)

To find the ID more quickly and easily, check the table ID from the shortcode. And add it after the parent class: gswpts_table_{shortcode_ID}

Example:  gswpts_table_92

FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)

Table ID is required only to use a sticky header on a specific table but if you want to use it for all tables at the same time, then there is no requirement to include individual table ID.

Step 2: Apply the CSS for Sticky Headers #

Once you have identified the table’s ID or class, you can apply the necessary CSS to make the header sticky. Use the following steps:

  1. Target the Table’s Scroll Container:
    • You need to target the table’s scroll container, typically identified by the class .dataTables_scroll. This container is responsible for handling the table’s scrolling behavior.
  2. Set the Scroll Container to Relative Position:
    • Set the position property of the .dataTables_scroll class to relative to establish a new positioning context.
FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)
FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)

3. Make the Header Sticky:

  • Now, target the .dataTables_scrollHead class within the scroll container. Set its position to sticky, specify the top offset (which determines how far from the top of the viewport the header should stay), and set a high z-index to ensure the header stays above other elements.
FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)
FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)

Step 3: Customize as Needed #

  • Adjust the top Value: The top value in the .dataTables_scrollHead class determines how far from the top the header will stick. Adjust this to fit your layout needs.
  • Test the Scrolling: After applying the CSS, scroll the page to ensure the header remains sticky and behaves as expected.
FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)

#

By following these steps, you can effectively make your table headers sticky and improve the user experience when dealing with long tables. Remember to adjust the CSS values to suit your specific design needs.

How to Create a Table from an Imported XLSX File in Google Spreadsheets #

To create a table from an imported XLSX file in Google Spreadsheets, follow these steps:

  1. Create a New Spreadsheet:
    • Open Google Sheets and create a new blank spreadsheet.
  2. Import the XLSX File:
    • Navigate to File > Import > Upload.
    • Drag and drop your XLSX file into the upload area.
  3. Share the Spreadsheet:
    • After importing, set the sharing settings by clicking on Share.
    • Under General Access, choose the appropriate sharing option (e.g., “Anyone with the link”).

How to Add Line Breaks in WordPress Table #

When creating tables in WordPress, you might encounter situations where you need to display text on multiple lines within a single cell. This can be useful for improving readability or formatting content in a more organized manner.

But WordPress tables do not handle traditional indentation or line breaks which are added on Google sheets. So, instead of using standard line breaks or indentation in your sheets follow the steps below.

Step 1: Insert the <br> Tag #

To create a line break within a cell in your WordPress table, you need to use the <br> tag. This HTML tag is specifically designed to insert a line break, allowing the text to continue on the next line within the same cell.

Step 2: Enable Text Wrapping #

To make sure your content is easily readable within the google sheets cell, enable text wrapping in Google Sheets: Select the cell(s) containing the cell, go to Format > Text wrapping > Wrap.

FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)

Step 3: Enable Cell formatting style #

To make sure your content is easily readable within the wp table, enable Cell formatting style from FlexTable: Select the Table(s) go to  Table customization > Styling tab > Wrapped.

FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)

Example Table:

FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)

How to Fix Zero (0) Values Not Displaying in Google Sheets Tables Issue #

When working with Google Spreadsheets, you might notice that cells with a zero (0) value sometimes appear as blanks in your tables. This can be frustrating, especially if the presence of zeros is important for your data analysis or presentation. Here’s how to fix this issue.

Understanding the Issue: Google Spreadsheets sometimes interprets zero (0) values as empty or blank cells, returning empty strings that are not displayed in your table. As a result, these zeros can appear as missing data, disrupting the accuracy and visual integrity of your tables.

Step 1: Use Quotation Marks Around Zero #

One effective way to ensure that zero values appear in your table is to enclose the zero in double or single quotation marks. This treats the zero as a text string rather than a number, ensuring it is displayed in the table.

  • Example: ‘0’ or “0”

Step 2: Use a Zero Emoji #

Another method is to replace the numeric zero with a zero emoji. This visually represents the zero without Google Sheets interpreting it as an empty value.

  • Examples of Zero Emojis:
    • 𝟶 (Mathematical Sans-Serif Digit Zero)
    • 🅾 (Negative Squared Latin Capital Letter O)
    • Where to Find the Emoji: You can copy the emoji from this page: Comma Emojis.

Using these emojis will ensure the zero appears as intended in your table.

Step 3: Apply the Fix to Your Spreadsheet #

To implement these fixes in your Google Spreadsheet:

  1. Select the cell(s) with the zero value.
  2. Replace the zero with either:
    • A zero inside quotation marks: ‘0’ or “0”.
    • A zero emoji: 𝟶 or 🅾.

Example Table:

FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)

How to Display Specific Rows/Columns/Cells Without Headers in a WordPress Table #

When working with tables in WordPress, you may sometimes need to display only specific rows, columns, or cells without showing the headers or other elements. This guide will walk you through the steps to achieve that by using built-in table customization options and custom CSS.

Step 1: Hide Unnecessary Columns #

To display only the columns you want:

  1. Hide Columns:
    • Go to the Hide Rows/Columns option and select Hide Columns.
    • Hide all columns except the one(s) you want to display.

Step 2: Hide Unnecessary Rows #

To display only the rows you want:

  1. Hide Rows:
    • Go to the Hide Rows/Columns option and select Hide Rows.
    • Hide all rows except the specific row(s) you want to display.

Step 3: Customize Table Layout to Hide Pagination, Entries, and Search #

To remove additional elements like pagination, entries, and search bars:

  1. Access Table Customization:
    • Go to the Table Customization section.
    • Under the Layout tab, uncheck all options in both the Table Top Elements and Table Bottom Elements sections.

This will remove unnecessary elements and leave only the table content you want to show.

Step 4: Apply Custom CSS to Hide Headers and Other Data #

Now, you need to use CSS to hide the table header and other elements:

  1. Open the Page with the Table: Navigate to the page where your table is displayed.
  2. Inspect the Table Element:
    • Right-click on the table and select “Inspect” or “Inspect Element” from the context menu. This will open the browser’s developer tools.
    • In the developer tools, find the table element in the HTML structure. You will need to identify the table’s unique ID or class to target it with CSS.
  3. Find the Table’s ID:
    • Look for an ID or class assigned to the table  container. For instance, if the table has an ID like gswpts_table_92, this will be the identifier you use in your CSS.
    • Use this ID or class to target specific elements you want to hide, such as the header.
  4. Hide Table Headers:
    • Use the following CSS to hide the table header and the table customizer backend link:
FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)
  1. Make Sure to use it with !important tag
    • This CSS will hide the table headers and the table customizer link. The !important tag ensures that the CSS overrides any other styles.

Step 5: Add CSS to FlexTable Settings #

To apply the custom CSS:

  1. Navigate to the Settings Menu:
    • Go to Settings > Custom CSS in your WordPress admin dashboard.
  2. Paste the CSS:
    • Paste the custom CSS code provided above into the Custom CSS field.
  3. Save Your Changes:
    • Click Save settings  to apply the changes.

Step 6: Verify the Changes #

After saving, preview your table to ensure that only the desired rows, columns, and cells are displayed, and that headers and other unnecessary elements are hidden.

Example Table #

FlexTable Advanced Use-Cases (Importing Codes, Sticky Header, Line Break and More)

By following these steps, you can effectively display only the specific parts of your table that you need, without showing headers or other unwanted elements. This method allows for clean, targeted presentation of data within your WordPress tables.

What are your Feelings
Share This Article :
  • Facebook
  • X
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on September 11, 2024
How to change table styles (theme customization)What impact does FlexTable have on SEO and Performance?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *


Table of Contents
  • Importing codes from Google Sheets
    • Step 1: Replace Commas with Text Emojis
    • Step 2: Handle Line Breaks with <br> Tags
    • Step 3: Enable Text Wrapping
  • How to Make Table Headers Sticky with CSS
    • Step 1: Inspect the Table on the Page
    • Step 2: Apply the CSS for Sticky Headers
    • Step 3: Customize as Needed
  • How to Create a Table from an Imported XLSX File in Google Spreadsheets
  • How to Add Line Breaks in WordPress Table
    • Step 1: Insert the <br> Tag
    • Step 2: Enable Text Wrapping
    • Step 3: Enable Cell formatting style
    • How to Fix Zero (0) Values Not Displaying in Google Sheets Tables Issue
      • Step 1: Use Quotation Marks Around Zero
      • Step 2: Use a Zero Emoji
      • Step 3: Apply the Fix to Your Spreadsheet
    • How to Display Specific Rows/Columns/Cells Without Headers in a WordPress Table
      • Step 1: Hide Unnecessary Columns
      • Step 2: Hide Unnecessary Rows
      • Step 3: Customize Table Layout to Hide Pagination, Entries, and Search
      • Step 4: Apply Custom CSS to Hide Headers and Other Data
      • Step 5: Add CSS to FlexTable Settings
      • Step 6: Verify the Changes
      • Example Table

Products

  • WP Dark Mode
    WP Dark Mode
  • FlexTable
    FlexTable
  • FormyChat
    FormyChat
  • Stock Sync
    FlexStock
  • FlexOrder
    FlexOrder
  • Easy Video Reviews
    Easy Video Reviews
  • EchoRewards
    EchoRewards
  • Jisi Meet
    Jitsi Meet Video Meeting
  • FlexSync for Shopify
    FlexSync for Shopify
  • ArchiveMaster
    ArchiveMaster
  • Chat Widgets
    OMG Chat Widget
  • Stock Notifier
    Stock Notifier for WooCommerce

Links

  • Home
  • Blog
  • About Us
  • Support
  • Affiliates
  • Influencer Program
  • Careers
  • Privacy Policy
  • Terms of Service

Our Blog

FormyChat Now Supports WP Dark Mode
June 3, 2025
FormyChat Now Supports WP Dark Mode: A Seamless Dark Experience for Your WordPre
customer referral program
May 28, 2025
7 Best Customer Referral Program Ideas with EchoRewards
Ninja Chat integrations with FormyChat
May 22, 2025
How to Connect Ninja Forms to WhatsApp: A Simple Guide to Instant Lead Notificat

Logo

Experience remarkable WordPress products with a new level of power, beauty, and human-centered designs.

© 2025 WPPOOL . All Right Reserved.

Our site uses cookies to give you a personalized experience through curated contents, and suggestions. More information