Table Look up with Event Configuration

Good morning Team,

I have another question for the great minds here on the IA Forum.

I am converting a lookup from a tag created in vision. I am tying to do the same type of lookup in perspective.

Below is a picture of what the table looks like in regards to data, it shows BinLoc, Status…

Here is the script that is used to look up the data from the table based of BinLoc.

So basically, I there is a built tag that holds the table information. I want to use my Status built in perspective view to view the status on that BinLoc.

As an FYI, each BinLoc will be represented on a view, see below.

lookup({[default]Warehouse/ASRS Freezer/Pallet Table}, {view.params.BinLocation}, "EMPTY", "BinLoc", "Status")),
"EMPTY")
[details="Summary"]
This text will be hidden
[/details]

image

Ok for all those wondering, I finally figured it out. I missed something simple…I missed the ‘try’ in the front.

try(lookup({[default]Warehouse/ASRS Freezer/Pallet Table}, {view.params.BinLocation}, "EMPTY", "BinLoc", "Status"),
"EMPTY")
[details="Summary"]
This text will be hidden
[/details]

1 Like