Hi guys,
Need some help.
I have created a data sheet with a list of jobs and their details. I have also created a risk assessment form. I then when you click on the job, created an action button which takes you to complete a risk assessment. I have a job number field on both.
I would like to have it so when I click create risk assessment action from that job, it pulls the job number which is already filled in the job details to the risk assessment where I have a job no field.
Is this possible?
You can use LINKTOFORM deep link for your action. It could be likeโฆ
LINKTOFORM(โRisk_Assessment_Formโ,โJob noโ,[Job no])
Iโm still having a bit of difficulty.
My list of jobs sheet is called โJobsโ
This has a field called โJob Idโ
I have a working action on the โJobsโ sheet which takes me to the โpoint of work risk assessmentโ form.
This form has a field named โJob No.โ
So Iโm trying to get the โJob Idโ field from the jobs sheet to automatically fill in the โJob No.โ field on the โpoint of work risk assessmentโ once pressing the action button on the โJobsโ sheet which takes me to the โpoint of work risk assessment formโ.
I tried your suggested formula as:
LINKTOFORM(โJobsโ,โJob Idโ ,[Job No.])
I entered that formula on the Job No. field on the Point of Work Risk Assessment field.
Not sure when I am going wrong?
Tryโฆ LINKTOFORM(โpoint of work risk assessmentโ,โJob No.โ,[Job Id])
Still canโt seem to work this out.
Just to confirm, where should I entering this formula?
You should add this formula into the โTargetโ option in your action and the option โDo thisโ should have โgo to another view withing this appโ.
User | Count |
---|---|
43 | |
25 | |
23 | |
14 | |
13 |