I’m trying to use a simple form to populate a central sheet that multiple users can view.
I set up a User Profile table with Employee - Email - Dept - Supervisor - Manager - etc
User would be logged in via email. When they submit a form, how do I populate Employee - Dept - etc. into the sheet so it can be filtered and formatted.
I can use special values and retrieve email, but I can’t figure out how to tie the email to an Employee in the Data editor. I can set up a Relation/Lookup that gives me the Employee in another column, and pull that into the table via Special Values Column in the form, but I can’t seem to populate the actual sheet. It looks like the sheet only accepts Text columns.
What am I missing?
PS - I’m very much digging the concept of Glide. I’ve already set up another app for my band, which is working great. If I can figure out this current issue, I can probably sell management on buying a Pro subscription.
ETA: One thing I did notice, is that the app will publish more data via the web interface than I see if I use the app on my iPhone.
And, this app doesn’t seem to update formatting on my phone like my band app does.