Create new or select existing linked record with Integromat

Can anyone help? Thank you :slightly_smiling_face:

Two Integromat features are going to be key to doing what you want: routers and filters. A router takes the data coming into it and sends it out to multiple sub-paths in the scenario. To control which path gets the data, you add a filter between the router and the first module in each sub-path. Because the router literally diverts the data only one direction or the other based on which filter’s rules it matches, this needs to be fairly late in your scenario setup. All steps leading up to this point will be the same for all form submissions.

In your case, you need to first have an Airtable “Search records” module somewhere before the router, and that module will search the [Clients] table for records matching the email coming from the form. Then comes the router, with two outputs, and with each output linking to one other module.

In one path, the filter will only allow data to pass where the number of bundles returned by the “Search records” module (mentioned above) is greater than zero, meaning that a matching email was found. The result of that search can be used in the subsequent “Update a record” module to make a link to the existing client record in [Clients].

In the other path, the filter should be set to only allow data to pass if the search returned zero bundles, meaning that no matching email was found. In that sub-path, the next module would be the Airtable “Add a record” module, where you would create a new client record, followed by the “Update a record” module where you would link the inquiry to the new client.

Here’s a quick outline of the steps, beginning with the search step, in case that description wasn’t clear:

Does that make sense?

Hi @Justin_Barrett, thank you for your reply.

Here is the photo of how I end up creating the scenario

I have also created the filter number of bundles returned, but I am stuck on “Find email” (Search record module)

I can not configure the module to look for existing email :confused:
The stared options in formula field does not list “email” column from “Clients” tab, and if I use column name in {Email} I get an error. The options under star, lists just data from Inquiry tab and webhook.

Do you know how to solve this?
Thanks

{Email}=name@gmail.com

{Email}="name@gmail.com"

Hi @Pjero_Kusijanovic

When using quotes, you should use the straight up and down ones.

I realize there’s a lot to learn, but once you get the hang of it, it will be easier.

Hope this helps.

Mary K

Thank you both for the reply. Double quotes did solve the error :raised_hands:

Hi @Pjero_Kusijanovic

Glad that the issue is resolved. Can you add solved to the title of the post?

Thank you,
Mary Kay

I can not find how to edit the title :confused:

For those who are less technical, we made a tool that simplifies this. It allows you create (or select) linked records with Airtable Form without building anything custom.

Hi @Pjero_Kusijanovic

I have attached screenshots to help explain how to add to the subject line.

Hope this will help.

Thank you,
Mary

Actually, the person who started the thread has the option to click on a button that says “Solution” for one of the comments in that thread. All they need to do is click on that button, which is only visible to them, and can only be clicked on for ONE post in the thread. This is what actually marks the thread as “solved” & closes the thread, and this is what actually makes your solution count towards your solution count.

Thank you @ScottWorld! I was wondering how this option was selected.

@Pjero_Kusijanovic, you just need to tap/select Solution option, at the bottom of the last reply.

Thank you @ScottWorld! I was wondering how that’s done.

@Pjero_Kusijanovic

Here is a screenshoot:

@M_k I already did that before on @Justin_Barrett reply