Tally Forms - Airtable - Search Record

How To
1

What are you trying to achieve?

I want to take form responses from Tally and distribute the data to multiple Airtable tables. Specifically, I need to get the Airtable record ID from the first table and use it in the others.

Steps taken so far

I have a Tally form that sends data to an Airtable table. I’m trying to use the Airtable ‘Search Records’ module to get the Record ID. I then try to use that Record ID in other Airtable ‘Create a Record’ modules. The Record ID is not available in the other Airtable modules. I have try to use the Response ID of tally to use as a record ID, but I have encounter errors.

A form arrives in Tally, the responses from that form are distributed to different tables in Airtable. In the first table, an ID is generated. In the Airtable module (Search Record) connected to that table, we want to retrieve that ID and distribute it to the other tables BUT we have not been able to achieve it! My friends say that in Zapier it is easier but I do not want to leave Make! Can someone help me???

Screenshots: scenario setup, module configuration, errors

General.png
General.png783×700 36.2 KB

SearchRecord.png
SearchRecord.png1176×828 84 KB

2

Welcome to the Make community!

To simplify things, that module should go before the router.

General
General783×700 38.7 KB

Otherwise you’ll have to use “Set Variable” and “Get Variable” modules everywhere to pass values between routes.

For more information, see Magic Router Formula below.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.