I have 2 tables / forms โTime Clockโ & โHazard Assessmentโ.
The first table / form โTime Clockโ, the user hits the โ+โ to add a new record to the table. It starts a for that logs their username & the Date / Time clocking them in, and asks for the Job number and fills in the customer info based on the number. I have this form and it works just fine.
They can now save and go on their way if they would like.
But I want to create an action button that would give them the option to instead click it and it would save the โTime Clockโ form that they just filled out and then not just take them to the list of โHazard Assessmentโ table / formโฆ but actually start a new โHazard Assessmentโ (like as if they had hit the โ+โ to add a new record to the table). It would start the new โHazard Assessmentโ and fill in any of the job number based on the โTime Clockโ
I am thinking itโs a combination of a deeplink / LINKTOVIEW() and an action but Iโm not sure. Iโve searched the forums & watched all the appsheet demo videos, but nothing seems quite right.
Any help would be appreciated,
Solved! Go to Solution.
I would add a Yes/No column to the end of your Time Clock table, asking whether the user wants to fill out a Hazard Assessment next.
Next create a โgo to another viewโ action, and set it as the Form Saved action for the Time Clock form.
Set a Behavior Condition in the action based on the Yes/No column.
Set the target of the action to point to the Hazard Assessment form. Use LINKTOFORM() if you need to prefill any values from the Time Clock form.
I would add a Yes/No column to the end of your Time Clock table, asking whether the user wants to fill out a Hazard Assessment next.
Next create a โgo to another viewโ action, and set it as the Form Saved action for the Time Clock form.
Set a Behavior Condition in the action based on the Yes/No column.
Set the target of the action to point to the Hazard Assessment form. Use LINKTOFORM() if you need to prefill any values from the Time Clock form.
Thanks I will give it a shot.
I have added the following column to the last column of the Time Clock as a Yes/No: Easy.
Added an Action to direct from the TimeClock to the โHazard Assessmentโ on a value of โTrueโ:
Timeclock_form behavior, event action, form save set to the Action above.
โฆand tested
Not sure whatโs goofy in all of this.
Nice work, almost there.
This is not a proper expression:
Either of the following would work here.
[Log HA]
[Log HA] = TRUE
Worked like a charm with 1 further small revision. The target formula needed to point at the โFormโ for the HA.
Thanks for the guidance!
Bonus question, and answerโฆ
Yes, You can link multiple actions by creating an action group
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |