Hi All.
I have 4 fields (Columns) in a form and all data is of the same row:
JOBID
CUSTOMER
CUSTOMERTEL
CUSTOMEREMAIL
In JobID I have a Valid If of โqryNewNotifications[JOBID]โ which allows me to select a known JOBID from my csv file.
How do I autofill
CUSTOMER
CUSTOMERTEL
CUSTOMEREMAIL
From that same csv which relates to that JOBID?
Hi Steve.
What am I not seeing ?
I created a virtual column to test the LOOKUP function.
โCustomerโ table:
Columns are:
[JOBID]
[CUSTOMER]
Virtual column formula test: LOOKUP(JobID,โqryNewNotificationsโ,โJobIDโ,โInsuredโ)
โqryNewNotificationsโ table:
Columns are:
[JOBID]
[INSURED]
The formula returns nothing although the expression assistant returns:
One randomly chosen value from this list (
โฆThe list of values of column โInsuredโ
โฆfrom rows of table โqryNewNotificationsโ
โฆwhere this condition is true: ((The value of column โJobIDโ) is equal to (โJobIDโ)))
JobID is unique in each table but not the KEY
I also tried: ANY(SELECT(qryNewNotifications[Insured], ([JobID]=โJobIDโ)))
Did you read the Troubleshooting section of the LOOKUP() doc?
LOOKUP([_THISROW].[JobID],โqryNewNotificationsโ,โJobIDโ,โInsuredโ)
Still returns nothingโฆ
Did you try the Test button in Expression Assistant?
We have a resultโฆ
I can see customers in the expression test.
I had previously viewed the table and the data, Iโll try the expression in the correct column through the form, with luck we may have resolved this.
Thank you Steve
User | Count |
---|---|
40 | |
36 | |
33 | |
23 | |
17 |