How To Reference Lookup Table Value In a Hidden Value

JZUser95 · September 21, 2021, 10:31am

Hi! I am trying to reference a value from a column in a lookup table using a hidden value. In other words, for this lookup table, if a user enters a certain ID, the hidden value would pull the corresponding value from that column. In this scenario, I'm trying to pull the value for outcome. Here are the details of my lookup table:

Any advice?

Clayton_Sims · September 21, 2021, 1:03pm

Hi,

There's some documentation about reference lookup tables in your forms on this wiki page that should cover how to construct this query.

I think in your case it would be something like

instance('item-list:missingrace')/missingrace_list/missingrace[id= #form/user_entered_id]/VALUE_FIELD

JZUser95 · September 24, 2021, 5:28am

Thanks so much @Clayton_Sims ! I had actually used similar syntax and could not seem to get it to work at the time. I think I might have just missed something, perhaps the brackets around id. It works now!

Ali_Agha · October 23, 2024, 11:24am

Hi
I hope you are well
Please can you explain to me the parameters of this equation
And what should I replace with my data to make it work
The existing link that you posted is not working
Thanks in advance

Aashima1 · October 28, 2024, 8:24am

Hello Ali,

Please find the explanation of each part of the equation:

**instance('item-list:missingrace')** : This is referencing a lookup table named 'missingrace'. You should replace 'missingrace' with the name of your lookup table.

**/missingrace_list/missingrace** : This is the path to the data in the lookup table. Typically, this follows the format of **/{table_name}_list/{table_name}**. You should replace both instances of 'missingrace' with your table name.
**[id= #form/user_entered_id]** : This is a condition that filters the data from the lookup table. It's looking for a row in the table where the 'id' matches the value entered by the user in the 'user_entered_id' field of the form. If your table uses a different field name for the id, or if the form field where the user enters the id is different, you should replace those parts accordingly.
**/VALUE_FIELD** : This is the field from the lookup table that you want to retrieve. You should replace 'VALUE_FIELD' with the name of the field you want to retrieve from your lookup table.

Could you clarify what happens when you try to access the link? Are you seeing any error messages? I just checked it, and it seems to be working fine on my end.