Im working with the new drag&drop UI with an application that has an Airtable connection.
I see there is no getAllRows so i can the work on the properties of each row…insrtead we have list of values wich will just get one column or get row object wichj would need to connect X numbers of times if you need to apply cetain filters based on the value of a column value.
Am i missing somehting? With this apporach the app get very slow as i need to connect many times to the database. My airtable has 6K rows…
Do you need to retrieve all the data at once? I too noticed recently that we didn’t have that block for data sources anymore but most of the time we don’t need it all either.
You could be right about the GetAllRows but for most of the searches, only one column is required and for that reason the list of values becomes a more convenient way. You do not even need to use for each item loop to find what you need.
Correct. the new functions are usefull but i have a case where a use airtable table where i have a set of information (different columns) where i need to show information in the UI based on the value of various columns at the same time.
With the old UI i could fetch all rows at once and then play with the getProperty function wich as is done in memory is much faster.
Ive also noticed that retrieving values with the getValues functions takes more time than before…in this example im looking for the row ID based on the list loaded when i start the app and its taking 5 to 7 seconds every time…
In this step im loading the list with all the values, it takes around 20 sec to load 5K values
Thanks, ill work on the API, although id first test this app on the standart UI to see wether is the implementation of the new functions or normal behaviour
