Hey @adehaan
Loading an ID from a column value is still pretty confusing in Tulip but it is possible. You will need to create a table query filtered on the vendor_name and then use a mode aggregation on the ID.
This has come up in quite a few other Community threads. The first link has a video tutorial.
Hi Folks, I’ve gotten a couple of questions in the last week about lookup functions in Tulip tables. While Tulip doesn’t have a built-in lookup function, there are some techniques that you can use to the same effect.
This video is a quick overview by my colleague @freedman of how you can use the mode aggregation to load a record into a record placeholder by a value in a different field.
[Quick Tips - Load record by another field]
Here’s a follow up from an office hours sessions wh…
This came up in Office Hours this morning with @jmlowden , @Amit , and Frank, and I thought it might be helpful to share!
Frank had a use case where an operator can be working on multiple work orders at once (for example, they run out of parts on one WO and then move to a new one) but each operator will only be working on one Part number at one time. He is using a User Table to tie a Work Order number and Part number to a user when they log in. He wanted to be able to then have the Work Order num…