Dynamic value formula for choice field
I have a table called “contacts”. One of the fields in that table is called “group” and that is a choice field. One of the choices is called “Guests”.
I have another table called “entertainment”. One of the fields in that table is called “guest name” and this is a dynamic multiple choice field. The idea is to see in that drop-down all contacts that have selected the choice “guests” in the “group” field in the contact table.
i have used the following formula in the dynamic value field
select contacts where group =“guests”
However, the result is an empty drop-down.
does anybody have a good idea how to solve this?
2 replies
-
One thing to check: that the word(s) are spelled exactly. You have “Guests” and “guests” in your post.
Another DB thing is to make sure you tell Ninox to look for text and not the choice number. So you would do:
select contacts where text(group) =“Guests”If, for example Guests is choice 3 in the simple choice field, then you can do:
select contacts where number(group) = 3 -
The word “text” did the trick. Thanks much
Content aside
- 11 mths agoLast active
- 2Replies
- 70Views
-
2
Following