I am trying to save the “rows” block (coming from the Airtable “GetAllRows”) in a stored variable. In particular, it is possible to copy the data retrieved in an app var but not in a stored var - two things to highlight:
- if I save the “rows” block in a stored var, it doesn’t get the data and the function below froze
- if I save the “rows” block through the “get object properties” block the data seem retrieved and the function below don’t stop. However, it seems that if I then try to use the data through the “for each J in list” block, I can’t access the data retrieved.
Nothing seem working - I have tried to store the data in:
- stored variables
- local data source
- local storage
- I have also tried to convert the data in JSON but the information seem too much
Just for clarity: at the moment my app retrieves around 3000 rows from Airtable at start, and it takes around 25/30 seconds to have the data in an app var. It would be good if I could store the data in a stored var and don’t download again the data from Airtable at each access.
Anyone has solutions/suggestions?