How to Prefill a Value when Column Type is REF

mykrobinson_0-1683914385176.png

how do i accomplish the above when REF is the column data type?

What i am hoping to have happen is for the column to suggest the current user's name based on useremail(). My "Valid If" is working but i can't get the Initial Value to work.

Thanks

Solved Solved
0 4 310
1 ACCEPTED SOLUTION

If [UserID] is the key value of the user roles table/ slice, then please wrap your above expression with ANY() and try.

Meaning ANY (Select ...))

 

 

 

View solution in original post

4 REPLIES 4
Top Labels in this Space