I have a client and an admin app. I’m trying to capture data (open and close times) in the admin app that can be validated and reformatted to be consistent in the client app.
I’ve put a 3rd party web form in a webview of the admin app. This is to validate the input and normalize its display in the client app. I’m currently using signed in user to grant row access but will likely pivot to owned user.
I can use a hidden question to pass a value that associates something like signed in user or row id (well, a field that equals the content of row id) as part of the form submission url: formname.paperform.co/?key=FIELD_VALUE/NAME
How can I call the user or other row-specific value and append it to the url? I’m not finding the field names but I’m likely overlooking something.
I’m also open to ideas on how to do this better and/or easier.
Thanks!
Rob
You can create a template column to dynamically build a URL and replace the FIELD_VALUE and NAME query parameters in the url with other column values.
Does this automatically submit back to the sheet when you fill out the paperform? Is there a feature there that you can’t do with a form or edit screen within glide? I’m not sure what exactly you are going for as a final result, but I would probably use datetime components or choice components to fill individual columns with open and close times. Then create a template column to put them all together in a rich text markdown format table that you can display using the rich text component. That would eliminate the need for a web view form, unless it has some features that you really need.
Hi Jeff,
Thanks for the guidance. There wasn’t anything particularly unique so I created the form within the admin app. I’ve added columns for each of the options and used a choice components for uniformity of input.
I’m sure I’m overlooking something, again, but how do I get the data to associate with the correct row? Right now it’s writing to the next available row instead of the one that associated with the signed_in user.
Form will always write a new row. If you want to edit existing data, then you need to display it in your app and enable editing for that screen. This will open up another screen when you click on the pencil icon, allow you to make changes, then update the existing row once you click on submit. Or you can add entry components on the view screen, which will update the sheet in real time as changes are made. Edit mode can be set conditionally so the edit pencil will only show if the signed in user’s email matches the email on the record being updated.