Streaming live at 10am (PST)

Updating Live Item Collection with Multi-Reference using Zapier

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:

  1. I have a collection called Colors with a multi-reference field with 3 entries [red, blue, green]
  2. My form should sends yellow
  3. 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)

Can anybody point me the direction?

If anybody is having similar issue, this was my workaround:

Don’t forget to add content-Type: application/json to the Headers, took me hours to figure that part off.

That was a though battle but thanks to Mackenzie Child I got it to work! :blush:

2 Likes

@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.

Super helpful, thank you!

1 Like

I’m so glad to hear I helped someone :hugs: 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!

1 Like

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! :slight_smile:

Glad to help, I know Zapier can get very annoying sometimes: https://zapier.com/shared/011f6378270f247dd89687915277562a1c28e9ea

1 Like

Awesome! So you’re using:

  1. Get data from (webflow) form
  2. Use Webflow API request to make it JSON
  3. Find/Create Airtable record
  4. Create (new) Live item in Webflow
  5. Add something extra to Webflow?
  6. Reformat to fix the multi-ref quotation problem
  7. Send data away to other system?

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?

I’m using multi-reference collection, that made it a bit more complex.

  1. Get new form submission (it contains a category)
  2. Ask webflow for more information about database (we are looking for ids)
  3. Lookup said category in airtable - if does not exist then create a new one
  4. Add entry (from webflow form submition) to database (it’s a live item so it can be updated in the future)
  5. Add item ID - automatically generated by webflow on step 4 - to a field called ID. This looks wrong/dumb but it seems it’s the only way it seems
  6. Format data to be added on step 7
  7. Add new category (its ID actually) to the multi-reference field, because I needed more than one category per entry

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)

Sorry mate I missed this message but wouldn’t be able to help you with XML anyway. I hope you figured it out.

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.

1 Like