How can I update columns in Airtable using Iterator in Make.com

How To
, , , , , , , ,
1

In my scenario, I have the following setup:

Values from my iterator and Text parser:

  • Prompt 1 Response
  • Prompt 5 Response

Airtable column names:

  • Prompt 1 Response
  • Prompt 2 Response
  • Prompt 3 Response
  • Prompt 4 Response
  • Prompt 5 Response
  • Prompt 6 Response
  • Prompt 7 Response
  • Prompt 8 Response
  • Prompt 9 Response
  • Prompt 10 Response

Objective: I want to update the appropriate Airtable columns based on the values extracted by the Text parser with ChatGPT module output.

Process:

  1. When the Text parser outputs Prompt 1 Response, update the Airtable column named Prompt 1 Response With ChatGPT Results.
  2. When the Text parser outputs Prompt 5 Response, update the Airtable column named Prompt 5 Response With ChatGPT Results.

2
21487Ă—719 88.8 KB

3
31007Ă—710 66.9 KB

1
11402Ă—697 85.6 KB

1 Like
3

Hi thanks for making a new thread.

I would do something like this in each one of your columns. Just match the values to each column. You can always do a router with updating when the ouputfromtextparser is the column name you want and map it that way. But this way is cleaner visually. Let me know if this helps!

{{if(“outputfromtextparser” = “Prompt 1 Response”; “value from gpt”; ignore)}}

value from gpt = response

image

4

@Mr.Make So means i need to made 10 router for this?
There is no other way to do that?

5

@Mr.Make What should I write in Update Record module with 10 columns name as Prompt Response 1- 10

6

I said that was a possible way of solving it.

I would do it like below and do that for all 10

image
image768Ă—530 40.9 KB

3 Likes
7

Hey @Med_FutureXAI

Using if() condition will process each column one by one. meaning for 2 results, 2 operations. Hence, in case you get 10 results, then 10 operations. You can do the job at once for all available columns by aggregating the result from text parser and GPT, and then using map function in airtable module.

Regards,
Msquare Automation - Gold Partner of Make
@Msquare_Automation

1 Like