# How to save results from iterator to Airtable and Make.com **URL:** \ **Category:** Questions\ **Tags:** arrays, open-ai, chatgpt, filters, airtable, mapping, api\ **Created:** [August 12, 2024, 4:18am UTC](https://community.make.com/t/how-to-save-results-from-iterator-to-airtable-and-make-com/50516 "2024-08-12T04:18:43Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Med\_FutureXAI](https://avatars.discourse-cdn.com/v4/letter/m/f4b2a3/32.png) [@Med\_FutureXAI](https://community.make.com/u/Med_FutureXAI)\ **Post date:** [August 12, 2024, 4:18am UTC](https://community.make.com/t/how-to-save-results-from-iterator-to-airtable-and-make-com/50516/1 "2024-08-12T04:18:43Z")
Hello, I have a scenario where I receive results from 7 different prompts obtained from ChatGPT. I want to update an Airtable record for each prompt. For example, the iterator bundle position 1 corresponds to prompt 1. I need to save the results of prompt 1 from ChatGPT to the “Prompt 1 Response” field in Airtable. This process should be repeated for all prompts. With 7 prompt results, each result should be updated in Airtable accordingly, with the first value being the result for prompt 1, and so on. I’ve attached pictures of my scenario for reference. ![1](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/f/8f6c2d1df1b8aa73e312f297ff84e9ba99d8f341.png) ![2](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/2/d276960fed2de8111353d6875fb4d8853703896a.png) ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [August 12, 2024, 6:13am UTC](https://community.make.com/t/how-to-save-results-from-iterator-to-airtable-and-make-com/50516/3 "2024-08-12T06:13:35Z")
> [@Med\_FutureXAI](#): > > I need to save the results of prompt 1 from ChatGPT to the “Prompt 1 Response” field in Airtable. Then you will need an array aggregator before you can map all the bundles from multiple operations in the same Airtable operation. ### Aggregators Every result (item/record) from **iterator** module will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort. [Aggregators](https://www.make.com/en/help/modules/aggregator.html) are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the [Array aggregator](https://www.make.com/en/help/tools/flow-control.html#array-aggregator) module. Hope this helps! Let me know if there are any further questions or issues. — @samliew ---
**Author:** ![Med\_FutureXAI](https://avatars.discourse-cdn.com/v4/letter/m/f4b2a3/32.png) [@Med\_FutureXAI](https://community.make.com/u/Med_FutureXAI)\ **Post date:** [August 12, 2024, 7:09am UTC](https://community.make.com/t/how-to-save-results-from-iterator-to-airtable-and-make-com/50516/4 "2024-08-12T07:09:10Z")
@samliew Thanks for you answer, can you please provide any demo/example Scenario. I have used array aggregator but it does not save the results. ---
**Author:** ![Med\_FutureXAI](https://avatars.discourse-cdn.com/v4/letter/m/f4b2a3/32.png) [@Med\_FutureXAI](https://community.make.com/u/Med_FutureXAI)\ **Post date:** [August 12, 2024, 7:43am UTC](https://community.make.com/t/how-to-save-results-from-iterator-to-airtable-and-make-com/50516/5 "2024-08-12T07:43:18Z")
@samliew If I use an array aggregator, it combines all the text into a single array. How can I separate each text and update the corresponding Airtable column? For example, with the iterator labeled “Prompt 1,” it includes the text from “Prompt 1” from airtable and the results from ChatGPT in the “Prompt 1 Response” field in Airtable. I need to repeat this process for all prompts, ensuring that each prompt’s results are correctly placed in its respective column. ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [August 12, 2024, 7:55am UTC](https://community.make.com/t/how-to-save-results-from-iterator-to-airtable-and-make-com/50516/6 "2024-08-12T07:55:20Z")
To map values from an array, you have to use the map-get combo. `map` selects the property of the collections in the array. `get` selects the item in the array based on the index. This is covered in the Make Academy. Please take some time to go through the tutorials, otherwise you’ll be asking basic questions like these and wasting time (not that I mind). 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](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html) – Make “Manual” - [Make Academy](https://academy.make.com) – Basics 101: Learn Make and get certified ### Help Centre Basics - [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map? - [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array - [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output) - **Date Format** : [tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting) - [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file - [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks ### Articles & Videos - [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube - [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist - [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796) - How to setup and use OpenAI (ChatGPT) in Make - [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202) - How to use pattern matching to extract the text you want Hope this helps! Let me know if there are any further questions or issues. — @samliew ---
**Author:** ![Med\_FutureXAI](https://avatars.discourse-cdn.com/v4/letter/m/f4b2a3/32.png) [@Med\_FutureXAI](https://community.make.com/u/Med_FutureXAI)\ **Post date:** [August 12, 2024, 8:09am UTC](https://community.make.com/t/how-to-save-results-from-iterator-to-airtable-and-make-com/50516/7 "2024-08-12T08:09:18Z")
@samliew Yeah i know its basic question, but i am stuck in this problem from past week. I will request you please if you can give scenario example. I will be very thankfull to you. ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [August 12, 2024, 8:19am UTC](https://community.make.com/t/how-to-save-results-from-iterator-to-airtable-and-make-com/50516/8 "2024-08-12T08:19:33Z")
![Screenshot_2024-08-12_160842](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/5/d5c68d4e630a2eed1b2f25d77ff7df13c8ec213c.png) ## Module Export You can **copy** and **paste** this module export into your scenario. This will paste example scenario modules. 1. Copy the JSON code below by clicking the copy button when you mouseover the **top-right** of the code block ![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/b/2b1b692880388420db5045bf51ef344e6698a816.png) 2. Enter your scenario editor. Press ESC to close any dialogs. Press CTRLV (paste keyboard shortcut for Windows) to paste directly in the canvas. 3. Click on each imported module and save it for validation. You may be prompted to remap some variables and connections. > **Click to Expand Module Export Code** > > **JSON** - Copy and Paste this directly in the scenario editor > > ```json > { > "subflows": [ > { > "flow": [ > { > "id": 260, > "module": "json:ParseJSON", > "version": 1, > "parameters": { > "type": "" > }, > "mapper": { > "json": "{ \"array\": [\n {\n \"result\": \"abc123\"\n },\n {\n \"result\": \"def456\"\n },\n {\n \"result\": \"ghi789\"\n }\n]}" > }, > "metadata": { > "designer": { > "x": 3590, > "y": -694, > "name": "Generate sample array of collections" > }, > "parameters": [ > { > "name": "type", > "type": "udt", > "label": "Data structure" > } > ] > } > }, > { > "id": 261, > "module": "builtin:BasicFeeder", > "version": 1, > "parameters": {}, > "mapper": { > "array": "{{260.array}}" > }, > "metadata": { > "designer": { > "x": 3831, > "y": -695 > } > } > }, > { > "id": 262, > "module": "builtin:BasicAggregator", > "version": 1, > "parameters": { > "feeder": 261 > }, > "mapper": { > "result": "{{261.result}}" > }, > "metadata": { > "designer": { > "x": 4076, > "y": -695 > } > } > }, > { > "id": 263, > "module": "util:SetVariables", > "version": 1, > "parameters": {}, > "mapper": { > "variables": [ > { > "name": "Field 1", > "value": "{{262.array[1].result}}" > }, > { > "name": "Field 2", > "value": "{{262.array[2].result}}" > }, > { > "name": "Field 3", > "value": "{{262.array[3].result}}" > } > ], > "scope": "roundtrip" > }, > "metadata": { > "designer": { > "x": 4319, > "y": -698, > "name": "Set 3 Fields" > } > } > } > ] > } > ], > "metadata": { > "version": 1 > } > } > > ``` Hope this helps! Let me know if there are any further questions or issues. — @samliew ---
**Author:** ![Med\_FutureXAI](https://avatars.discourse-cdn.com/v4/letter/m/f4b2a3/32.png) [@Med\_FutureXAI](https://community.make.com/u/Med_FutureXAI)\ **Post date:** [August 12, 2024, 9:29am UTC](https://community.make.com/t/how-to-save-results-from-iterator-to-airtable-and-make-com/50516/10 "2024-08-12T09:29:53Z")
@samliew Thanks for the response. I have one question. Which module should I use in my scenario instead of the Parse JSON module? I have the Iterator and ChatGPT modules included in the scenario, as shown in the attached picture. Should i used only the Array aggreator after ChatGPT module? ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [November 10, 2024, 7:27am UTC](https://community.make.com/t/how-to-save-results-from-iterator-to-airtable-and-make-com/50516/11 "2024-11-10T07:27:09Z")