Solved: Appsheet not showing all the data from spreadsheet - Page 2

dio_als · 12-05-2023 10:58 PM

Hi, i have complete data from spreadsheet with uniqueid and all of the data is arrayformula except for 1 column which needs to be filled by user in the appsheet

the problem is, the appsheet seems to not showing the row where the column needed to fill by user is blank, and only showing the filled one, is there anything i miss in the config ?

Aurelien

Probably because you have a spreadsheet expression in the Autocompute area of the column [UniqueId].

A good practice is to have this expression:

UNIQUEID()

in the Initial value expression of the column:

and nothing else for the key-column.

For reference:

What is a key? - AppSheet Help

UNIQUEID() - AppSheet Help

View solution in original post