Solved: Flag record in read only table using data from imp... - Page 2

Paras_Sood · 07-07-2022 05:58 PM

Hi community,

I have created an app whose database is on google sheet and values get updated based on an import range function, pulling data from another spreadsheet.

Ideally, I only want to flag a record, by highlighting it as red by clicking on a button if I see something wrong with it, I cannot update the values directly through the app because this is pulling data from another spreadsheet. I tried to use a virtual column, but I cannot update a virtual column using behaviour actions. Is it possible to achieve this?

dbaum

I see. I didn't realize your source data changes frequently. I assumed the scenario was more like it updates daily and you needed to be able to flag a row only for immediate reference.

Consider whether there's a way within Sheets to keep the Flag column's value in the row with the data where it was intended to be applied. Maybe sort the import range so that new records are always at the end? Maybe there's an applicable Apps Script technique? As part of your approach, perhaps you could move the 90-day filter from the sheet to the app--e.g., the table's security filter?

Alternatively, maybe you need a shadow table with 2 columns: an ID column that can be used to reference a row from the main table, and the Flag column. You could probably create an Apps Script to add the IDs to the shadow table periodically or maybe even every time the main table gets a new record. If helpful, a script could also probably remove IDs from the shadow table when they disappear from the main table after 90 days.

View solution in original post

Flag record in read only table using data from import range