Hello,
I have ref column that is part of a form.
Both tables have security filters based on user email.
When a user is in the form, I want to have an initial value using the filtered data in the ref column.
Iโve tried ANY(reftable[refcolumn]), but it is not working.
Any other ideas?
Thanks!
Jennie
Perhaps the security filter has filtered out the referenced row? Keep in mind that a security filter keeps the filtered rows from even reaching the app.
It shows up in the form drop down (if I donโt have the initial value formula in). Thanks for thinking about this!
Okay. The dropdown should show all rows from the security-filtered table. You can further limit whatโs shown in the dropdown using a Valid_If expression, if youโd like:
But you say you want an initial value, which is just one value, not a list of values. Maybe this might help:
If these docs donโt provide an answer, feel free to come back and ask for more options.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |