Hi everybody.
I have a an app that pulls information dynamically from an excel sheet.
In this sheet, in each row, I have available cars for renting. And the apps pulls all necessary information from the sheet and presents it to the user.
Obviously I don't want to keep erasing and writing back cars that are available for rent or not.
So what I'm looking for is for a way to hide and show rows, but not from the user seeing the sheet but from any script that it's trying to pull information from the sheet, so it would be like there's no data in some rows.
I saw a sheet that had a "active" column, with a TRUE or FALSE value, so that I could mark each row as active(TRUE) or not active (FALSE), but unfortunately it was just a screenshot and I couldn't see how it worked.
Any help would be greatly appreciated.
Bookmarks