Holiday Notice – Support Unavailable on April 18 and April 21

We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!

In the meantime, if you need any help, feel free to:

Amelia YouTube Channel

wpDataTables YouTube Channel

Thank you for your understanding, and we wish you a wonderful holiday weekend!

Okay
  Public Ticket #3540967
Transform Values not working on responsive columns
Closed

Comments

  • Dropping Coconut started the conversation
    December 11, 2023 at 3:59pm

    Hi there,

    if i create a column A (does not matter if it contains a value or is empty), and I define it to Transform Value, eg {columnB.value}, everything works fine - Column A shows the rewritten value taken from column B.

    Example:

    Data Source: Column A: abc | Column B: def
    Visible Table: Column A: abc | Column B: abc

    Now i enable responsive column and initially hide column A on mobile hpones and tablets. Now, when I load on a mobile device, the value is not transformed, I am shown the roiginal value auf column A.

    Data Source: Column A: abc | Column B: def
    Visible Table: Column A: abc | Column B: def

    This is only the case, when the table is initially loaded in it's collapsed state. When I load the table with a display size greater than by responsive breakpoint, and scale the window down, the value transformation is correctly carried over to the collapsed column.

    Further info on the use case we encountered this in:

    Source: Google Spreadsheet

    Tablet Breakpoint: 5000px (also tested with default 1024px) - we need some tables to always be collapsed and rendered in the <ul> list.

    Thanks and BR,

    Florian

  •  1,894
    Miloš replied
    December 14, 2023 at 8:59pm



    Hi Florian,

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    -

    Thank you for reporting this bug.   I am able to reproduce it only for our "non server side" tables.

    The issue does not happen on Manual Tables ( which always use our server-side processing) or for MySQL Tables with enabled server-side processing.


    But i can catch the bug on a Google Sheet linked Table, which does not have our server-side processing feature.

    5350121676.png


    This is how it renders correctly for collapsed Table Load for server-side Tables :

    7490492061.png


    3143444473.png


    Compared to the same type of data, on a Google Sheet linked Table, in this case when the Table loads in a 'collapsed' state, as you said - then we can catch this bug, the transformed values are not rendering.

    2094748525.png

    For linked, non server-side tables, as you said - it only loads the 'default cell values' without transforming them.


    Our developers isolated the bug, and they'll add it to their queue for fixing.

     They will do their best to build a fix as soon as possible.

     We don't have an ETA on when the fix will be available, but please keep a lookout on our wpDataTables changeLog.

    It will be stated there during updates which bug fixes have been implemented at each update.

    -

    For the time being, the only way to avoid this bug until we add a fix, as a 'temporary workaround' is if you can switch to imported Tables.

    If you import the file, the plugin reads the source file and creates a manual table. 

    Once the table is created, it is no longer linked to the source file, so changing data in the table will not show up in Excel or Google Spreadsheet, and vice-versa. 

    This table will be editable in our Plugin.

    If you need quicker editing, you can either switch to the Excel-like view, 

    and then select and copy the range of cells you want to paste from the source file, and paste it in the Excel-like view, 

    or you can Update manual tables from source files (CSV, Excel or Google sheet) with three options :

    • Replace data within an existing table.
    • Or Add data to an existing table.
    •  Or  Replace the entire table with new data.


    Let me know if that helps.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables