Accessing a table record by searching for a variable

[k.ober]

Hey there!

I’ve got a Tool ID that the operator puts in at the beginning of an app. On the next step, the app needs to search a table for that Tool ID and load the record that contains it.

How can I write an expression that finds the record ID from a variable value that matches a value in the table? Is there a way to work around this?

Thanks!

[kevin.kononenko]

Hi Kyle, thanks for joining us. It sounds like you are trying to use the value of a variable to access a specific record in a table. Is that right?

If so. here is how to do that: