Appsheet not showing all the data from spreadsheet

[dio_als]

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]

---

@dio_als wrote:

all of the data is arrayformula except for 1 column which needs to be filled by user in the appsheet

---

Hi @dio_als  Can you check this is empty?

---

@dio_als wrote:

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,

---

It all depends on your view type.

- If this is detail view type: this is ok, because columns with empty content won't be displayed to user.

- If this is Form view type, then it's not normal and there is probably a setting preventing you from updating the content.

[dio_als]

Hi @Aurelien thanks for the reply,

the spreadsheet formula is empty, because i need the user to fill from a dropdown

my view type is table, as you can see my appsheet view table only showing 2 item here

while on the spreadsheet it has a lot of data

and the appsheet only showing items where the column i need user to fill is already filled

[Aurelien]

ok.

1) On your table view settings, can you make sure you have every columns available in the Column order field?

2) in the data pane, can you make sure you have all the "SHOW" property enabled for your columns?

[dio_als]

yup, i already set column order in the view setting

and of course i already checked the show options, if not the column won't be showed at all in the first place

[Aurelien]

@dio_als Apologies,  I misunderstood your question: I thought you were talking about columns not being shown.

Can you check which column wears the KEY property ? From what I see, it could be the [Upload PF Date].

AppSheet will only displays rows with a key.

[dio_als]

ok, i think that makes sense, i see my key is referred to _rownumber

so i changed it to my uniqueid

but as soon as i hit save, the appsheet change it back to row number

why does the appsheet did it ?

[Aurelien · Accepted solution]

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

[dio_als]

i see, that makes sense

yes, my unique id is a formula in the spreadsheet which refer from another table, the id is used to get data from another table,

while this view type is edit only, no new row will be added from appsheet, i think it is quite difficult if using UNIQUEID() in the initial value, is there any method that i can approach ?

[Aurelien]

I would suggest jsut reomving the expression in the app editor, set the key property again on it, then saving. Don't change anything else 🙂

[dio_als]

nvm, i just tried to create a new column with arrayformula of combined item from other column

and voila, i don't know why but it works now

thanks for the reply, i enjoyed every discussion

[Aurelien]

I'm glad you made it!

Have a nice day 🙂