I have a form on Webflow for adding new items to a multi-reference live collection field.
My field had 4 entries initially and I was able to replace it entirely with the new one, but I want to append it instead.
To exemplify what I want to achieve:
I have a collection called Colors with a multi-reference field with 3 entries [red, blue, green]
My form should sends yellow
Collection should be [red, blue, green, yellow]
I have tried webhooks using Webflow Update Live Item and webhooks… and briefly tried Zapier Code (without understanding much what I was doing). (And I’m still familiarizing myself with Postman)
@vanpaio I just wanted to say thanks for taking the time to share the solution you found - this solved a problem that I’ve been having. I have to say I followed Mackenzie’s video closely but I did refer to your screenshots as well.
I’m so glad to hear I helped someone I got stuck with this for a whole day or two and was about to give up when noticed the right syntax. Thanks for the feedback!
If possible, could you please also share your whole Zapier/Zap?
I’m very interested and have plans many(!) more things with Zapier. (already on 18 zaps and counting).
But doing checks for duplicate content or new or update events, is something i still struggle with. Hope you can help me with some more puzzle-pieces!
I was about to try one of my last ideas, and that would be Airtable (which i’ve tried before but i found it pretty complicated somehow). But Airtable is crucial in this workflow?
And what exactly are step 4, 5 and 7 for if i may ask?
Thanks for the insights.
I’ve been working on this, and it seems like an extra field in an table/Google sheet, is very helpful to get it anytime you want, or for me f.e. it’s also to verify if data has been processed completely.
Can you say anything else about airtable?
Is it an extra (editable) table/database, needed as an ‘in-between’ to make this work well?
And is airtable the best solution in your opinion?
Side Question: Would you happen to know anything about getting XML data into zapier and filter it’s content there?
Currently i’m getting pretty far with integromat, but it’s costly for many ‘items’ to process, which i want to do each day (cross-check if item exists)
Thanks for replying. I’ve gotten most of it to work with Integromat.
Project will get a greenlight this week or the next - then we will have to figure out a way to (definitively) get this right. So i’ll get back with (hopefully) good results.
Not yet with multi-reference fields, but that has been done before - i believe with the help of Airtable (to store/link the right multi-items). So it is possible.
I was able to get this working using Integromat and an Integromat Data Store, no Airtable needed. If anyone wants some screen shots let me know and I can post them here.
I would be really interested in Integromat Data Store since i planned on trying that out as well! That would/could save a lot of time on projects that don’t otherwise need Airtable!
Hey all I’ve got an alternate solution to updating a live item multi-reference field. My goal was to simplify the process and use an Integromat Data store instead of involving another app like Airtable.
Then using a set variable module with a formula on the text string to create a properly formatted set of ID’s that I’ll pass into webhook and send to Webflow.
That formula is really important because it takes off an extra comma and space at the end of the last item so that it can be accepted by the webhook.
I can now do a direct update of a multi-reference field in webflow using Integromat only, no need for Airtable. At this point the idea I’m working on is to allow my membership subscribers to “like” or “favorite” an item and have those items appear on a dashboard.
Hello, great thread on this topic! I’ve watched the videos and tried setting this up in both Integromat and Zapier but keep getting a Validation 400 Error stating that:
“Your Zap is likely to be missing a required field, or a field value wasn’t in a recognized format. For example, if a field in your action step is expecting an email address, but the value given is a name, the app may return a 400 error.”
Does anyone have any suggestions on what I might be doing wrong?
I’ve tried updating a regular text field through a custom webhook patch and that worked fine.
I’ve included some screenshots for reference.
I created a separate column in Airtable to structure the Webflow ID’s as an Array, and am trying to pull those through in the Zap to update Webflow.
I got stuck with this for a whole day or two and was about to give up when noticed the right syntax. Thanks for the feedback!
If anyone wants some screen shots let me know and I can post them here.
