Services Plugins FAQs

**Subject:** Excel Table / Data / Grid — Add action renders all rows merged into 1, sorting has no effect

#1

Plugin: Excel Table / Data / Grid (dataTables), plugin ID 1532997348558x797819075821568000
App: cosecha-morelos (Bubble), version-test environment
Element: Table Boletero

Issue:
Following the documented setup exactly (Page is loaded → Add [Table] action, uniqueID as first “Add columns” entry, each Value using :join with ","), the table renders but all records are merged into a single row instead of being split into separate rows per record.

Setup:

  • Add columns entry 1: Key = uniqueID, Value = Search for Boleteros:each item's unique id:join with ","
  • Add columns entry 2: Key = Nombre, Value = Search for Boleteros:each item's nombre:join with ","
  • Add columns entry 3: Key = Activo, Value = Search for Boleteros:each item's activo:join with ","
  • Initial sort name = Nombre, Sort = Increasing

Console log confirms the Add action fires correctly and passes a well-formed array of 3 column objects, each with a correctly comma-joined value string (e.g. Nombre: "Boletero 3,Boletero 2,Boletero 1"). However, the rendered table shows only 1 row, with all 3 names concatenated into a single cell (e.g. “Boletero 3,Boletero 2,Boletero 1” as one value), rather than 3 separate rows. Footer confirms “Showing 1 to 1 of 1 entries.”

Sorting (via Initial sort name/Sort, and via clicking the column header) has no effect — consistent with the table treating this as a single row.

Already ruled out:

  • No console/JS errors
  • Plugin’s own “Error” exposed state is empty
  • DataTables library (cdn.datatables.net) loads successfully (200)
  • Retyped the , delimiter manually in all 3 fields (fresh keystroke, no hidden characters) — no change
  • Confirmed element is not inside a hidden/collapsed container at time of Add action (this was a separate, now-resolved issue)

Request: Please advise what’s misconfigured, or confirm if this is a known bug in the current version. Happy to share screen-recording/editor access if useful.

#2

Hi @emilioalvarezg,

Thank you for reaching out.
I understand how frustrating it is when the table renders all records merged into a single row despite following the :join with "," setup.

Here is an analysis of why this behavior typically occurs and how to resolve it:

1. Mismatched Item Counts (Null or Empty Values) When using Bubble’s :join with "," operator across multiple column entries, Bubble automatically omits empty/null fields from the list. If any single record in your database has a blank field (for example, if a record’s activo status is empty), the resulting comma-joined string for that column will contain fewer items than the uniqueID column. When the item counts do not match across all columns, the table parser fails to construct separate rows and collapses the entire dataset into a single row.

  • Verify that every record in your search result has a non-null value for uniqueID, Nombre, and Activo.
  • As a test, try replacing optional fields with a static value or ensuring all database fields are populated.

2. Data Containing Internal Commas If any of the text values inside your data fields contain commas within the text itself (e.g., “Boletero 3, Jr.”), using :join with "," will cause the plugin to interpret that internal comma as a row delimiter. This breaks the array structure and distorts row alignment.

  • Inspect your database entries to confirm no text field contains internal commas.

3. Key Naming and Key-Value Consistency Ensure that the first key in your “Add columns” list is named uniqueID with exact case sensitivity and no leading or trailing spaces in the text field.

4. Uniform Search Context Confirm that every column entry in the Add [Table] action uses the exact same search query and constraints (Search for Boleteros:each item's...). Any slight difference in search parameters between columns will result in mismatched list lengths.

Recommended Troubleshooting Step To isolate the cause, I recommend temporarily setting up the table with only two columns using mandatory, non-empty fields (such as uniqueID and a guaranteed text name). If the table renders separate rows correctly in that test, re-add the remaining columns one by one to identify which field contains null values or formatting issues.

You can also review configuration examples in our official documentation: Excel Table / Data / Grid

Please let me know how the troubleshooting goes or if you notice any list length discrepancies upon inspecting your data!

Best regards,
Support Team
Browse all Zeroqode Plugins for bubble
Banner_Last3

#3

Hi @emilioalvarezg,

I am following up on my previous message regarding the Excel Table / Data / Grid plugin setup issue.

Were you able to check if any empty values or internal commas in your database were causing the row merging issue? Please let me know if the troubleshooting steps helped resolve the issue or if you need any further assistance.

Best regards,
Support Team
Browse all Zeroqode Plugins for bubble
Banner_Last3