Aug 02, 2022 03:41 AM
Hello, I am trying to build a simple automation using Make.com (Integromat) when a form is submitted to Webflow I need to create, search and update a record.
This is the workflow:
I have 2 forms on my webflow website:
Form 1 gets email address and IP address → Create a new record
Form 2 gets a few checkboxes and IP address → Search for records that matches the IP address and update the record with the checkboxes
I tried different formulas but the issue I am having is that when Form 2 is submitted all the records on my table are updated.
I hope somebody can help me. Thank you.
Here some screenshots from my automation.
Solved! Go to Solution.
Aug 02, 2022 06:55 AM
Your search formula is not correct.
So it needs to look like like this:
IF({IP Address}=“ :blue_square: :blue_square: :blue_square: :blue_square: ”,1)
You need to type in everything with your keyboard (do not use Make’s IF function), except for the blue squares, which you will need to pull from your Webflow step.
Aug 02, 2022 06:55 AM
Your search formula is not correct.
So it needs to look like like this:
IF({IP Address}=“ :blue_square: :blue_square: :blue_square: :blue_square: ”,1)
You need to type in everything with your keyboard (do not use Make’s IF function), except for the blue squares, which you will need to pull from your Webflow step.
Aug 02, 2022 07:07 AM
Thanks for your reply.
I tried your solution but the Scenario comes up with an error:
RuntimeError
The formula for filtering records is invalid: Invalid formula. Please check your formula text.
Aug 02, 2022 07:09 AM
Your quotation marks need to be straight quotation marks, not curly quotation marks.
Aug 02, 2022 07:14 AM
That worked! thank you very much! You are a lifesaver
Aug 02, 2022 07:15 AM
You’re welcome! :ring_buoy: :ring_buoy: Glad you got it to work!