Hi ,
I have seen something like what I am trying to accomplish in one of the samples but cannot find it.
I want the email address to update when I pick a client in the drop down. As per the images below.
I have tried various lookups and selects but no luck so far.
Solved! Go to Solution.
I think the formula for useremail is [clientid].[useremail] as initial value or as you please. I suppose that in the ref table , the name of the email column is useremail too.
I think the formula for useremail is [clientid].[useremail] as initial value or as you please. I suppose that in the ref table , the name of the email column is useremail too.
Thanks. Easy as pie. Simple dot notation for the objects.
For reference:
Thanks Steve. The bit about chaining with a virtual column is good to know.
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |