Solved: Column of "User name" disappears while making a vi... - Page 2

Pratyay_Rakshit · 04-04-2020 07:55 AM

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()=“abc@xyz.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.

Pratyay_Rakshit

Actually, though not the column is not ‘showing’ there, it is present there actually. Maybe in some other dimension which we are incapable of perceiving, but it was there. The whole time.

Jokes aside, when I used a linktofilteredview() expression using [_THISROW].[User Name], it actually took me to the expense records specific to the user. The image showed up perfectly, also the sync time improved.

Had I checked this before posting, I wouldn’t have to post this at all. Still there may be someone out there facing the same problem, to whom this thread might come to help.

Also, someone might enlighten the viewers as to why the columns are not showing up when trying to be chosen from the option within the table view editor.

View solution in original post

Column of "User name" disappears while making a view from the table