Lookup airtable -> Iterator Make

How To
1

Hello,
On Airtable I made a lookup and I want to recover this information in make with an Iterator.

Do you know how to do it ?

Thank you for your help

2
2894Ă—303 14.8 KB

1
1985Ă—406 75 KB

2

Welcome to the Make community!

Which information do you want to recover? Can you be more specific?

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module and select “Download output bundles”.
Screenshot_2023-10-06_141025

A.

Save the bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading it here will look like this:

bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted output bundle in this manner:

  • Either add three backticks ``` before and after the code, like this:

    ```
    input/output bundle content goes here
    ```

  • Or use the format code button in the editor:
    Screenshot_2023-10-02_191027

Providing the output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

2 Likes
3

Hello
Thank you for your help.
I want to get the cities (Montluçon, Romans-sur-Isère, Valence)

Here is the Bundle of exit of the iterator to be able to pass them in a module chatGPT to make titles on each city.

[
{
“value”: “Montluçon, Romans-sur-Isère, Valence, Montélimar, Annemasse, Thonon-les-Bains, Annecy, Grenoble, Saint-Martin-d’Hères, Échirolles, Vienne, Saint-Étienne, Saint-Chamond, Roanne, Clermont-Ferrand, Lyon, Bron, Vaulx-en-Velin, Villeurbanne, Villefranche-sur-Saône, Vénissieux, Rillieux-la-Pape, Meyzieu, Caluire-et-Cuire, Saint-Priest, Chambéry, Aix-les-Bains, Bourg-en-Bresse”,
“IMTINDEX”: 1,
“IMTLENGTH”: 1
}
]

Sans titre
Sans titre1120Ă—779 71.2 KB

2Sans titre
2Sans titre1153Ă—627 75.9 KB

4

Looks like that is just a plain text string.

To make each comma-separated value into an item in the iterator, you’ll need to convert it into an array using the built-in split function.

Put this into your array Iterator module:

{{ split(string_variable; ", ") }}

2 Likes
5

I tried it but it didn’t work

[
{
“value”: null,
“IMTINDEX”: 1,
“IMTLENGTH”: 1
}
]

3Sans titre
3Sans titre978Ă—607 56.9 KB

6

You inserted the variable into the split function incorrectly.

It has to go before the semi-colon, and you omitted the second parameter, which should contain a comma and a space.

1 Like
7

@samliew Thank you so much it works. I hope it helps others too! Thanks once again !!!

2 Likes
8

No problem, glad I could help!

1. If you have a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.

2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.

This marks the topic as solved, so that:

others can save time when catching up with the latest activity here, and

  • allows others to quickly jump to the solution if they come across the same problem

To do this, simply click the checkbox at the bottom of the post that answers your question:
Screenshot_2023-10-04_161049

2 Likes