Services Plugins FAQs

Datatable not handling empty fields (field contains a list or text items)

Plugins
#1

image

I am using a datatable which has some empty fields and i get two errors like this. presume “column 3” is of course referring to column 4 as the first is ignored, and this is in line with the problem not occurring when all fields in the “staff edit” column are filled.

Data is loaded on page load with the following function:

image
image834×1356 68.1 KB

If i fill in all the email fields there is no error, so it seems to me that datatables can’t handle empty fields, but in the plugin it says that since 2018 it can, so I’m wondering if maybe there is just a simple workaround? Unfortunately bubble logic is of course very limited and i cant just do a ‘if list-of-emails is blank, then don’t join’ or smth as i suspect its maybe smth to do with the join empty list elements that’s causing the issue…

#2

Hi, @daniel.redgate!

Thanks for reaching out and sorry for the delayed reply due to weekends!

Let me check your request carefully and I’ll get back to you asap!

Best, Julia.

1 Like
#3

Hi, @daniel.redgate!

I have checked the Datable plugin and it does display the column which doesn’t have the full data.

image
image1380×459 12.2 KB

Could you please make a double check the settings according to the documentation page: "Excel" Table / Data / Grid - Zeroqode Documentation . Additionally, you are able to verify the settings in the Editor: Zeroqode-demo-16 | Bubble Editor
Also make sure that you do use the latest plugin version and give it another try.

Referring to the issue, please follow this link: 4. Warning: Requested unknown parameter which can be helpful.

Hope this helps!
Best, Julia.

#4

For some items it seems to work and for others it doesnt. not really sure why. I’ve restructured my database and now things are working. Still a mystery, but thanks for trying to solve.

1 Like