Initial value for ref column

Jennie_Lewis · 05-03-2020 08:22 AM

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

Steve

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.

Jennie_Lewis

It shows up in the form drop down (if I don’t have the initial value formula in). Thanks for thinking about this!

Steve

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.