chozma
Member
Hi guys,
I have a database join element that is pulling in a calc element as its label. However the calc element is not displaying in my dropdown list, I just get blanks for each option. If I view the table I can see the calc element spitting out the string as I would expect.
To be more specific I have a table called mob with a database join element to a table called animal. I want the database join element to display the name and a user given id of the animal (two fields combined) in the dropdown and store the records id as its value.
I don't think the label concat function is an alternative option for me, as there are legit occasions when the animal doesn't have a name or a user given id. So I deemed a calc element the best way to produce exactly the formatting I want when there is no name or id.
Am I doing something wrong?
Thanks as always,
Hannah
x
I have a database join element that is pulling in a calc element as its label. However the calc element is not displaying in my dropdown list, I just get blanks for each option. If I view the table I can see the calc element spitting out the string as I would expect.
To be more specific I have a table called mob with a database join element to a table called animal. I want the database join element to display the name and a user given id of the animal (two fields combined) in the dropdown and store the records id as its value.
I don't think the label concat function is an alternative option for me, as there are legit occasions when the animal doesn't have a name or a user given id. So I deemed a calc element the best way to produce exactly the formatting I want when there is no name or id.
Am I doing something wrong?
Thanks as always,
Hannah
x