This thing is beating the crap out of me. Though I am sure it is possible. The first page of my app is a calendar. Once user clicks on an event, we go to the next page that shows awesome details about the event. Then on this detail page, we have a FORM BUTTON saying: Register for this Event.
Once the user clicks on this FORM BUTTON we go to the next page where they will enter name and email. This FORM BUTTON is linked to a different sheet, called Reservation, that is different than the one where the remainder of the page content is coming from.
When I click on the FORM BUTTON, enter the data , and submit it, everything is saved in the RESERVATION sheet as expected.
What I would like to add is a link to the data that was on the detail page. Something that tells me what the user registered for. For instance, can I copy the title column of the detail page into the Reservation sheet? Can I copy an ID of some sort? How can I establish that link between what the user was viewing and the data that it just entered?
This article speaks about the different type of data the form can refer to: https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/forms
“Data from the parent” type of data is what I would like to have in addition to what the user enters.
But i don’t see how to actually do that. I am not seeing the different type of data for a form.
Thanks.
Pay attention to the components on the right when you are on your form page. You should have access to all of your calendar details to write to your reservation sheet.
https://docs.glideapps.com/all/reference/privacy-and-per-user-data/special-values/column-values
AWESOMENESS. That did the trick. Thanks.
1 Like
I’m running into the exact same issue, and your post describes it perfectly.
In my case, I have a collection list of scoring components, and when I click on an item to open a form screen (to enter a score), none of the values from the parent screen — like the selected contestant — are available in the form. The form is writing to a separate “Score Sheet” table (like your Reservations sheet), and I need it to capture context from the previous screen (e.g., who the judge is scoring).
I also read the Glide docs about using “Data from the parent”, but in practice, I’m not seeing those values available in the form — just user and screen values. It’s like the form doesn’t inherit anything from the list item it came from unless you set it up a very specific way.
If you (or anyone else) has found a workaround or best practice for linking the parent item’s data into a form tied to a different table, I’d really appreciate the help!
A form will only inherit from it’s immediate parent row which would be the Scoring Component row in this case since that’s the row that opened the form. If you first select a contestant at a higher level, you will need to change the action on the contestant collection to a workflow, so that when you select a contestant to view their details, you will call the workflow which will first store the values you want from the contestant row into the user profile, followed by showing the detail screen for the contestant. Then when you get to the form, you can directly retrieve those stored values from the user profile.
2 Likes