Hello Everyone,
I’m trying to implement a barcode scanner into my packaging program.
I have 3 tables,
Displays, Film, and masters.
If I scan and on save of the scanner form I use an action to go to another app view with the following formula, everything works well.
LINKTOFILTEREDVIEW("Vendor Display_Detail", [barcode] = [_thisrow].[Scan])
Problem is, this only Isolates 1 of the tables.
I’m trying to do the following,
IFS(
Count(SELECT(Vendor Display[Id], ([barcode] = [_thisrow].[Scan])))>0,
LINKTOFILTEREDVIEW("Vendor Display_Detail", [barcode] = [_thisrow].[Scan]),
Count(SELECT(Vendor Film[Id], ([barcode] = [_thisrow].[Scan])))>0,
LINKTOFILTEREDVIEW("Vendor Film_Detail", [barcode] = [_thisrow].[Scan]),
Count(SELECT(Vendor Masters[Id], ([barcode] = [_thisrow].[Scan])))>0,
LINKTOFILTEREDVIEW("Vendor Masters_Detail", [barcode] = [_thisrow].[Scan])
)
So Im searching through each table, and if there is a match, navigate to that detail view.
Currently, even though I’m scanning a matching Bar code, it just goes to the view one was on prior to going to the scanner form.
Any Help would be appreciated
Thanks
Solved! Go to Solution.
Jumped the gun again,
Removed action on form save for some reason… OMG!!!
Works perfectly.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |