I'm wondering if it's possible to change how the information returned in the Master Detail table is formatted. My WPDataTable is referencing from a Google Sheet. The actual Sheet is formatted the way I want it, which is in this format:
- Item 1
- Item 2
- Item 3
However, the Master Detail table returns in this format:
- Item 1 - Item 2 - Item 3
I'm attaching screenshots of the Google Sheet and the Master Detail table for your reference. Let me know if it is possible to somehow format the Master Detail table as in the first example.
Hi,
I'm wondering if it's possible to change how the information returned in the Master Detail table is formatted. My WPDataTable is referencing from a Google Sheet. The actual Sheet is formatted the way I want it, which is in this format:
- Item 1
- Item 2
- Item 3
However, the Master Detail table returns in this format:
- Item 1 - Item 2 - Item 3
I'm attaching screenshots of the Google Sheet and the Master Detail table for your reference. Let me know if it is possible to somehow format the Master Detail table as in the first example.
Best,
Noah
Hey Noah.
wpDataTables can't read Google Spreadsheet's format, so this is why this is happening. I shared this sheet with you: https://docs.google.com/spreadsheets/d/1ji9oQuUJxHATOzMyE59HNLhe64J9kwLaXezeN43w44E/edit#gid=0
This table pulls the 1st row as single line items, but when you include <br> tags (as in the 2nd line) it comes through correctly:
And, in the Master-Detail popup:
You'll need to add these HTML tags in order to show them correctly.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Excellent, this worked perfectly! Thanks for your help Aleksandar:)
You're welcome, Noah.
Glad I could help!
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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