I have a few forms. In the first form, I need to scan Barcode and by condition pass this value to the second or third form. How can I do this without using a table? Maybe there is some kind of global variables etc.?
Solved! Go to Solution.
If you donโt have any relationship between the Scanner & Inspection, or the Scanner & Category, you need to add an extra normal column in Category table so you could read it with the LINKTOFORM when triggering the 3rd form view.
Do you want to open another form right after the first one is saved?
Yes, I will redirect to another form
Then you could create an Event action with the formula LINKTOFORM() because you can read the value from the record you just saved. In generally it could be like LINKTOFORM(โFormViewNameโ,โColumnโ,[Column]). Please check this articleโฆ
I already did it, but the second form has the type โTableโ and another spreadsheet.
So I need to get value somehow from the first form in second.
It doesnโt matter. LINKTOFORM will open always a form view.
Yes, it opens. But how I can get a value from the first form without saving it in a spreadsheet? ๐
You need to use correct source and target columns with that LINKTOFORM. The first column with โโ is the target and [โฆ] is the source.
Tables are not linked. I just scan [Serial Number] than open second view which table doesnโt have [Serial Number] field. In the second view, I need to click on a category and use [Serial Number] from the first form.
Would you please give what table names and what column names they have.
Yes, please!
Soโฆ you first fill the Scanner form, then Category and finally Inspection?
Right
If you donโt have any relationship between the Scanner & Inspection, or the Scanner & Category, you need to add an extra normal column in Category table so you could read it with the LINKTOFORM when triggering the 3rd form view.
Thanks, I will go this way ๐
Youโre welcome
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |