Spreadsheet doesn't work

Good afternoon,
I am using Airtable’s Spreadsheet in my application and when I want the values ​​to be placed in five List Picker it doesn’t work.

However, if you just put it to put the values ​​in one List Picker there is no problem.

Is there any solution to this?
Thank you

Hi @Luis_Angel_Herrero_Diez
Can you show what is not working? Are you getting any error?

No error appears in Companion or in the exported APK. The items simply do not appear in the List Picker.

One question… Why you want to create five lists with exactly same values?

Because each List Picker classifies the different values.

Just make sure that you are accessing your spreadsheet at 5 request/second. If you will exceed the limit, then you have to wait for next 30 second.

From your blocks, it seems that you are exceeding the limit, that’s why you can get values in one list picker but you are not getting it 5 list picker.

1 Like

Thank you so much for your help!

1 Like

If it helped you, please mark it as solution. :slight_smile:

Thank you.

It is already marked, thank you very much and good morning!

1 Like

You are welcome. Good morning and have a nice day.
Btw, here in India, it’s already night. :sweat_smile:

I have a doubt.In both cases @Luis_Angel_Herrero_Diez is calling data only once so how it can be issue.
:thinking:

1 Like

I didn’t get you quite clearly with this. Can you explain?

1 Like

No. In case of using one list picker, he is requesting once but on using 5 list picker, he is requesting 5 or than 5. He mentioned that he is 5 spreadsheets. :sweat_smile:

It means you can only request 5 times in one second to Airtable. If you exceed this limit, you will have to wait 30 second.
That’s why I stopped using Airtable nowadays.

1 Like

Where is this mentioned in original post?

Still not clear! Because there is one variable to store data.

I don’t think so.
Because there is only one data received event so it is clear that data is getting called only once.

Unable to find this in whole topic :innocent:

He mentioned it here.

But still list pickers are showing same list.
Let @Luis_Angel_Herrero_Diez clear our doubts.

1 Like

:joy:

Did you saw the first post?

P.S. removed green tick as it can be misleading

1 Like