Initial value for ref column

[Jennie_Lewis]

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