I have multiple Zapier integrations which sync portions of my Airtable databse with that on Bubble.
Every now and then values, that exist for a specific data type, become empty and I need to update that state on Bubble.
Example:
Partner A is no longer using Products X Y Z, so now the list of products used by that partner is empty.
My zap will run to update this on Bubble and under the list of Products used there will be an empty list.
The problem I’m running into is that Bubble would not read these values and update them accordingly.
It works perfectly fine if I have to update an existing list of products from X Y Z to just X for example.
Sending an empty list though Zapier makes it so the existing value on the Bubble database remains untouched.
What would be the best way to handle these cases?