Replace Null Values in List (So Bubble Doesn't Remove them)

Need help Database
1

I need to save a list of texts that contains null values (so it retains its length and positioning of each item) and it seems Bubble automatically removes values if they are empty. So, my working solution to this is to just replace null values in the list with something else. This may be a problem all its own though as I can’t seem to find a way to do this. I do not have anyway to edit the creation of the list, I just get the list from an API with the null values. Any ideas?

1 Like
2

Found a workaround and thought I’d share.

Initial list from API (that has null values) - > Format as text (Replace null values with “null” and add “%” as a delimiter) - > Extract with Regex (([^%]+))

Resulting list is same length and order as original, but with empty values replaced with “null”.

1 Like