Show all airtable lines

[Frederic (Frédéric)]

Bonjour à toutes et tous,

J’ai 10 lignes de 3 colonnes dans airtable (toutes les cellules sont remplies.)
Je souhaite afficher dans une appli les 10 lignes.

J’ai initialisé une liste vide

Puis j’appelle à l’ouverture de la screen à aller chercher toutes les lignes

Et enfin je demande à ce que toutes les lignes s’affichent dans une vue liste

Et cela ne fonctionne pas !
Pouvez-vous me dire ou cela ne va pas ?

Merci.

[deanart2012 (Dean Artis)]

The official community language is English. Please respect the rules and translate your post.

[Taifun]

total rows is the number of rows to receive… this is probably not what you expect to receive…
see also the documentation

Spreadsheet - Kodular Docs

Taifun

[Frederic (Frédéric)]

@deanart2012

hello,

Sorry I did not see in the rules that it was absolutely necessary to post in English.

Thank you.

[Frederic (Frédéric)]

@Taifun

Bonjour,

Oui j’avais déjà regardé la documentation du tableur.
Mais après réflexion, je pense que le problème est qu’une seule vue liste ne peut pas afficher 3 colonnes.
Je vais chercher autrement.
Merci.

[dora_paz (Dora)]

Please follow community rules, use English

[dora_paz (Dora)]

When got all rows the response is in json format and the you have to use dictionary blocks to get the data you want. See an example

Error Using Airtable's component Get All Rows

That kind of error is obtained when you try to get data from a Json and the logic you use to extract the data does not match with the structure of the json Here is an example of how you can get data from Airtable using the GetAllRows block (with this block you get a Json in the response content) using dictionaries Note: In airtable it is easier to get each column and then work with those data as lists This is my Airtable structure: [imagen] We create the variables for each airtable column.…

[Frederic (Frédéric)]

Bonjour @dora_paz

Thanks for your help.

Sorry for the posts in French, I did not see in the community rules that it was necessary to post in English.

As for my problem, I will take inspiration from the example you posted to me.
I get back to you as soon as tested.

[Frederic (Frédéric)]

@dora_paz

I tried to do with the example you gave me.
Here is my table and my blocks :

Merci.

[dora_paz (Dora)]

Replace

with

[Frederic (Frédéric)]

@dora_paz

Ok.

i have this error

[Still-learning (1-2-3-4...)]

Are your sure your airtable cells no empty cells?

[Frederic (Frédéric)]

@Still-learning

yet no

[dora_paz (Dora)]

Post a sample aia here if you wish

[Frederic (Frédéric)]

@dora_paz

thank you.

The project is not finished.
For the moment, I just want to display the rows of my tables in the list view of screen 1

Eleve_ton_enfant (1).aia (1.1 MB)

I have also modified my table to show only what is necessary.

[dora_paz (Dora)]

Try this, using [Free] Json To Dictionary Extension

Eleve_ton_enfant_1.aia (1.1 MB)

[Frederic (Frédéric)]

@dora_paz

Actually it works.
thank you, I’m going well with you.

I put the code if it can be useful to others.

[dora_paz (Dora)]

If problem solved mark solution in order to help others