I typically have users press a button which sets the row owner role to “Admin” for example.
Right now though, I am feeding Mighty Form output to google sheets, then from google sheets I used import formula to glide synced google sheet.
What I did was go to google sheets and add a column that says “Admin” and copied it for 500 rows. It works, but feels like a quick fix that takes too many glide rows.
Well yeah I never really figured out to make arrayformulas function properly. I previously had a use case where I wanted an auto increment column (1,2,3,4…) that would update every time a row is added, but never figured it out.
Yes, the hidden field completely solved my problem.
Collecting the form responses from Mighty Forms because it will be embedded on a website. I will not be using a user-facing application, just a back-end application.
Also making a long line item (in this case 29 columns) on glide can get a little tedious lol. Also I’m using conditional logic on the form input, which would force me to make a custom form and entry field placeholders on glide.