Hello Cloud Community,
I have a strange use case I can't find an answer for anywhere. I have a table in AppSheet sourced from a Google Sheet. In this table, the data in the rows is not relevant to columns other than the column the data is in. Some columns will have 100+ rows of data while another column may only have 10 rows of data. As such, I would like to treat each column as its' own independent table. When I make slices of each column the view perfectly suits my need, however, when I Add (+) new data the form posts to the next empty row of the table, not the column. I'm aware this is by design and I'm trying to use AppSheet in a non-standard way. Is there a way to make the Add button in a slice default to the first empty row of a specific column? Is there a better way to do this? Currently, I've split my columns into many separate Sheets to get the functionality I need, but this is getting unmanageable on the Sheets side of things as I have more than a few tables that need to be split this way. My Workbook has way too many tabs.
TLDR; Is there a way to make the Add button in a slice default to the first empty row of a specific column instead of the first empty row of the table?
LinkedIn
Twitter
