Hi. I have a form that records a daily check list for Fabrication Hardware. The checklist is the same for each piece of hardware but I have to create a separate row for each piece of hardware too. I have 6 Chainsaws numbered 001 - 006. When I complete the check for 001 is there a seamless way for me to automatically load the next form with the checklist for 002 and then 003 and so on.
Any help would be great, thanks.
Solved! Go to Solution.
@MauriceWhelan
You can create separate LINKTOFORM (โChainsawXXX_Formโ,โIDโ,UNIQUEID()) actions for each ChainsawXXX_Form view (from 002 to 006) and assign them to the Form Saved action of successive ChainsawXXX_Form views (from 001 to 005). The next form will seamlessly pop-up upon preceeding form is saved. I mean:
LINKTOFORM (โChainsaw002_Formโ,โIDโ,UNIQUEID()) Form Saved action for Chainsaw001_Form,
LINKTOFORM (โChainsaw003_Formโ,โIDโ,UNIQUEID()) Form Saved action for Chainsaw002_Form
.
.
LINKTOFORM (โChainsaw006_Formโ,โIDโ,UNIQUEID()) Form Saved action for Chainsaw005_Form
@MauriceWhelan
You can create separate LINKTOFORM (โChainsawXXX_Formโ,โIDโ,UNIQUEID()) actions for each ChainsawXXX_Form view (from 002 to 006) and assign them to the Form Saved action of successive ChainsawXXX_Form views (from 001 to 005). The next form will seamlessly pop-up upon preceeding form is saved. I mean:
LINKTOFORM (โChainsaw002_Formโ,โIDโ,UNIQUEID()) Form Saved action for Chainsaw001_Form,
LINKTOFORM (โChainsaw003_Formโ,โIDโ,UNIQUEID()) Form Saved action for Chainsaw002_Form
.
.
LINKTOFORM (โChainsaw006_Formโ,โIDโ,UNIQUEID()) Form Saved action for Chainsaw005_Form
Hi Levent,
thanks for all of your help on this forum. I am trying to use the โLINKTOFORMโ in this exact way, attaching it to โForm Savedโ action, but there is also an input above called โFinish View.โ This โFinish Viewโ seems to overrule the โForm Saved Action.โ In the โFinish Viewโ Input, there seems to be no way for me to select my โLINKTOFORMโ action.
I am pretty new to this forum, so I am not sure how to properly document my problem. Thanks for you help
Thank you @LeventK/ Can I just ask what ID & UNIQUEID() refer to here in your expression. Are they just examples of additional information that can be used in the expression. I do want to set the value of a column called [Hardware] in each form to Chainsaw2, Chainsaw3 etcโฆ
@MauriceWhelan
Iโm referring to the key column and its preset value pair with the โIDโ and UNIQUEID(). You can rename the key column as per your tableโs structure. You can add as many {ColumnName, InitialValue} pairs as you want besides that {Key, InitialValue} pair i.e.
LINKTOFORM(โChainsaw001_Formโ, โIDโ, UNIQUEID, โHardwareโ,โAnyValueYouWantโ, โAnotherColumn1โ, โAnotherValueโ, โAnotherColumn2โ, IFS([AnotherColumn1]=โThisโ, โThatโ, TRUE, โHelloWorldโ))
Great thank you @LeventK. It is working perfectly. Can I ask an additional question? When the user does a check on these 6 items today I want the values set today to be the initial value tomorrow and so on but based on the value in the [Hardware] Column of the form being filled out. I know I need to create a VC with formula MAXROW(โChainsaw Checksโ,_RowNumber,???) The ??? is the value in the [Hardware Column] but not sure of the correct syntax.
Maybe you could you advise?
@MauriceWhelan
Provided you have a timestamp column in that table, just create a MAXROW(...)
expression and as it will be working as a ref, you can de-ref any desired columnโs value as the initial value. You can specify it directly in the LINKTOFORM with
LINKTOFORM("Chainsaw002_Form", "ID", UNIQUEID(), "Hardware", [MaxRowColumnName].[Hardware])
Thank you very much @LeventK
Hi @LeventK. Havenโt got it working 100%. I have
VC called [Previous Record Detail] with App Formula MAXROW(โFabrication - Master Checkโ,โTimestampโ)
Action with Target LINKTOFORM(โElectric Plainers 2โ,โRecord IDโ,UNIQUEID(),โHardwareโ,[Previous Record Detail].[Hardware])
I have set the initial value of field for [Hardware] to pull in the value from the previous day but the problem I am having is that is pulling in the overall maxrow value from the sheet.
So for example on the second day of checks I need all day 1 values returned for form one and the same for form 2 etcโฆ
With the above the initial values on form 1 for the second dayโs checks are for the max row overall i.e. Electric Plainers 6 instead of Electric Plainers 1.
Hope that makes sense. What is it that I might be missing?
@MauriceWhelan
You need to create a MAXROW(โฆ) separately for each of the Chainsaws so that the ref/de-ref will locate the correct value from that filtered ref list. For example like this:
MAXROW(โFabrication - Master Checkโ,โTimestampโ, ([Hardware]="Chainsaw002"))
and letโs assume that you have named it like [C002_Prev_Recs]. Now when setting the LINKTOFORM deep link for Chainsaw002, you can now refer to the de-ref expression to retrieve last previous record(s) for Chainsaw002 as an initial value in the form.
LINKTOFORM("Chainsaw002_Form", "ID", UNIQUEID(), "ColumnA", [C002_Prev_Recs].[ColumnA], "ColumnB", [C002_Prev_Recs].[ColumnB])
Hope I have understood your issue correctly.
Hi @LeventK. I think you understood perfectly because it seems to be working as I need it based on your advice.
Many thanks again for all your advice. It is such a great help.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |