Iโm having a hard time figuring out deep links even after reading relevant documentation. Could use some assistance. Hereโs the structure and workflow:
Parent Table/Form - โTimecardโ
Child Table/Form - โFleet Inspectionsโ
In the parent โTimecardโ form the employee enters whether they operated fleet that day. If they did, they have to enter the โFleet IDโ and โStart Milesโ in the โFleet Inspectionsโ form via nested form.
At the end of their shift, they have to enter โEnd Milesโ to that days fleet inspection. They click on their timecard in a table view which takes them to a detail view of that days timecard. I want to add an action button to that detail view which will take them directly to the โFleet Inspectionsโ row related to that particular timecard entry, so they can enter โEnd Miles.โ
Iโve tried a couple of variations of โLINKTOโฆโ with no success. Any guidance and/or explanation would be greatly appreciated. Thank you!
If you want to go to a particular existing row, use LINKTOROW(). Youโll need to know the key column value of the row you want the user to visit, and the name of the view that will display the row.
Steve, thank you. I tried the following expressions, but they take me to a blank form and not the โFleet Inspectionโ form related to the โTimecardโ entry:
LINKTOROW([Date/Timestamp], โFleet Inspection_Formโ)
LINKTOROW([_THISROW].[Date/Timestamp], โFleet Inspection_Formโ)
Hereโs how my info is set up:
Key column value for the Parent table โTimecardโ is [Record ID]
Key column value for the Child table โFleet Inspectionโ is [Date/Timestamp]
View I want to navigate to is called โFleet Inspection_Formโ and is a Ref view
The action is on a Detail view of the parent table โTimecardโ. I want the action to take me to the โFleet Inspectionโ row related to the Parent tableโs โTimecardโ entry.
What am I not seeing? Thank you!
Does a fleet inspection row with the given timestamp key value already exist? If not, LINKTOROW() wonโt work, as its target must exist. If you want to create a new fleet inspection row, use LINKTOFORM() instead.
Yes, the fleet inspection row already exists with its own timestamp key value .
The employee starts the timecard form which captures their clock in time, then, in the same form, they have to answer โOperate Fleet?โ If they answer โyes,โ they have to complete the nested โFleet Inspectionโ form.
They then complete the nested โFleet Inspectionโ form (minus the โEnd Milesโ column that they must complete at the end of the day). This generates its own row in the โFleet Inspectionโ form with a timestamp key value.
I want the action to take them to this already-started fleet inspection form so they can finish adding โEnd Miles.โ
What is the Ref column in the Timecard table that points to the fleet inspection form?
Steve, your question prompted me to review my Key and Ref columns. Looks like they were set up incorrectly. I made the necessary changes and action fires as expected.
Thank you!
Well done!
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |