Is there a way to make rows that are hidden in the Google Sheet not appear in my app?
Thanks!
Michael
Is there a way to make rows that are hidden in the Google Sheet not appear in my app?
Thanks!
Michael
Not that I know.
You could create a “Deleted” boolean column and filter your inline list by the value of that column.
As far as I know, when Glide reads a Google Sheets spreadsheet, it doesn’t see formulas (it only sees the data, basic as well as the result of formulas), filters or formatting.
Hidden rows in GS might be hidden from view on your screen, but really the data is there and Glide syncs accordingly.
As Killko suggested, you could add an attribute/column to your spreadsheet and use this column to indicate which rows are to be hidden (i.e. filtered). Then in Glide, you could filter the list based on this column.