When Zapier zap sends blank/no-data data to my Webflow CMS fields, if there is an existing field value Webflow, it is not removed or overwritten with a blank field value as one would hope.
As a use case, imagine you have event listings with photos and an address in an external database like Airtable. In the first place, you use Zapier to publish the event listing from Airtable to a Webflow item containing 3 photos and an address. Later, you remove one of the photos and the entire address from your original database/airtable.
You run the automation (i.e. uypdate a webflow item) with blank/no data fields for one of the photos and the address, but Webflow wonât remove or overwrite existing field values unless there is a new value to replace them with.
I could use Zapierâs formatted step to create default empty space data for fields where data is non-existent, but that would be messy and require me to add one formatter step for every field which would amount to dozens of formatter steps in multiple zaps. Besides, it still wouldnât solve the issue for images/URLs required by Webflow.
Are there any better workarounds or Webflow-side solutions?
However, if you ever get tired of running into problems like these while trying to use Zapier to sync your Airtable and Webflow CMS, give PowerImporter a try. It puts all your Airtable data in your Webflow CMS, and then keeps them in sync automatically. Whether you add, update, or delete something in Airtable, PowerImporter will update the CMS accordingly, and it also takes care of all your multi-reference fields for you.
You could be up-and-running in 5 minutes and never have to worry about this automation again.
Disclaimer: I created PowerImporter, so forgive me for being a little âsalesyâ.
After some additional setup, the emptycharacter solution turns out to be quite error-prone and doesnât solve all the edge cases.
Besides adding one additional âDisplay as true or false fieldâ for every field in my collection, which would be a mess and max out my CMS field limit, I still donât have a good solution for this!
Yea⊠thatâs definitely not the way to go lol. I too am looking for a solution to revert reference field to default through automation, except Iâm using Integromat/Make. Iâll let you know if I come up with something.
Hey @WillSayer
Could you please share a screenshot of how your inputs look like in the field in Make? That would be awesome. Iâve tried, but itâs still not working