Hi Guys,
Can someone help me understand how to transfer values from a New Form linked to a Glide Table to a Sub Form? I’ve tried using a workflow, but after submitting the form, “this item” no longer exists.
New Form(->Table)—> SubForm(with the sames values of Form submitted)
Nice day.
You could add a new column in the user table calle last submitted form. Then use that data to get data from the other form and bring it in the sub form.
You could also create a after submit action that prepare the sub form. That is what I would do.
I understand that the After Submit Form (Workflow) will load values from the User to the Sub Form (Setting values), but I am lost with the initial Form values from being passed to the profile before the submit event triggers.
How can I transfer values from my current form to User values? During form creation, I can only send values to either the Table or UserProfile, not both.
Can you explain more, pl.
How about if you change your components to directly write to the user profile within the form. Then add user profile components if you also need to save the same value on the form’s destination table.
I tested it but can’t complete my submission; the button is unresponsive, even though all fields are present?
It would be helpful to see what you have tried and how everything is set up.
1 Clear values stored in User is OK
2 Set initial profil value (1) is OK
3 Edit Data + Button (Finish) → Set value Done to UserProfile is OK (values are here)
4 Wait for Done
5 When userProfile is Done Add row to Table1 (Taking data from UserProfile, but the date is not passed to the the table, No data?)
6 Sub Form with UserProfile Data but is not added to the table, same problem.
After control User data are really in the UserProfile but is not passed to the add row events triggers.
I have tested step3 with “Show new form” but Submit is no more working when I send the data to UserProfile
What I was explaining didn’t involve any On Submit actions. I was thinking you would do everything within the form.
- Add an entry component for user input, pointing directly to a user profile column.
- Add a User Profile component to retrieve that value from the user profile and pass it through your form when it’s submitted.
No workflow actions needed. But, I don’t have a complete picture of what you are trying to do, so I may be missing something.
1 Like
TableOne 1-N TableTwo relation, I have a button that triggers this workflow. I clear old values in UserProfile before proceeding. I need to update two tables in the same event, which I can only achieve through the workflow. Adding an input to send my value to Profile and retrieving from Component Profile before submitting works for one table, but not for two. Not working solution.
This is your proposal, Inputs → Profile, and Component User Profile to fill the main form, but the Submit button is not permitted.Not working solution (the values are in User Profile but without submit event no values goes in the Table1).
I’m lost in the space…