Appsheet displaying as blank, but underlying data exists.

[EricY9969]

Hi, I have been using appsheet as a data input app linking to google sheets. For the past few years, I can input data 2-ways and have them shown up in both sheets and appsheet UI. However, in recent weeks, I have noted that:

1) Data input in sheets is being reflected as blank in appsheet when shown. However, when I click into the record, i can see that all fields exist and upon pressing 'save' in appsheet, the record get displayed correctly.

2) Please refer to screenshot for details, all I did was open the record,  and save it, and now it is displayed properly:

3) Any help or insights are appreciated!

[WillowMobileSys · Accepted solution]

It appears that the Primary field of your Deck View is based on concatenating other fields together.  You could be using a Virtual Column or a Table column with an App Formula to construct these values.  When you enter the data directly into the sheet,  that column needs to be executed in the app in some way.  Virtual Columns are executed/calculated via Sync operation.  Table columns with an App Formula require that the row be edited for the App Formula to trigger.

It appears from your screen shots that you have implemented this as a Table column with an App Formula.  Did you switch it from a Virtual Column at some point? 

My recommendation is, if you will adding rows directly into the sheet frequently, then switch this column to a Virtual Column so these values are calculated anytime the those rows are loaded into the app.