I am using the action “add a new row to table using values from this row”.
Setup: The idea is to take select info from the pre-populated “Table 1” and put it in “Table 2” if any user wants to remember it for later. Table 2 then, is a dumping ground of all the selected rows from Table 1. Each row is only unique by the “id” column and the “user email” column which are both synced from appsheet by initial values of “unique id” and “useremail()” respectively. All other data could be duplicates as multiple users could, and very likely will, be interested in the same rows from Table 1. Lastly, I want the in app view for Table 2 to be a personal experience. I want the user to pick what they want from Table 1, use the Action to move it to Table 2, then only see what they have submitted to Table 2.
Problem: I have successfully coded the app to show only the relevant data, but its also showing the “empty” rows in the spreadsheet. It knows to hide the content of the cells based the coded criteria, but its showing entire rows as empty/blank instead of hiding the rows altogether.