A form for user expense submissions records the useremail() of the user entering the expense, and the immediate next column has an app formula to record the user’s name from the useremail() based on multiple ifs conditions. Like if( useremail()=“email@example.com”, name = “abc”).
When I try to create a view from that table, I can’t happen to find any of the useremail or user name column. As a workaround, I copied the entire table to a new sheet within gsheets, and created a view from there. From there, it lets me choose the user name in the view.
Now apart from slowing my app down to a stretch, it doesn’t also let me view the receipt image that the user uploads while submitting the expense. I believe it has something to do with the computed columns, i.e. maybe computed columns don’t show up in views.
Is there any way to get this to work as I want? Or do I have to continue working like this if not I aim for a complete overhaul? The sheet already has almost 3000 rows of data.