I’m working on an app where I want to select a different livestock feeds from two different lookup tables using multichoice questions and then use hidden values to retrieve data for labels and calculations with the name, energy content, and protein content of the respective feeds.
I’ve been following the instructions found here Challenge retrieving data from lookup table for calculation in form but receive the error that the hidden value R1_identify ‘references id which is not a valid question or value.’
My reference for the lookup table in the hidden value is:
if(#form/feedstuffs/feed/R1_select = ’ ', 0, instance(‘item-list:BD_Roughage’)/BD_Roughage_list/BD_Roughage[id = #form/feedstuffs/feed/R1_select]/roughage_name)
I’m unsure where this problem is coming from. Is it the hidden value reference or the multichoice question lookup itself?