Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Need your help on how to force data into a field.
I have two fiels 'Project_Number' and 'Project_Ref' which are not connected directly.
I would like to fill 'Project_Ref' field with the numbers I get when choosing the field 'Project_Number'.
'Project_Ref' contains the same data as 'Project_Number'.
It should be like this:
If I choose the numbers 1,7 and 55 from field 'Project_Number' the system should choos the same numbers in field 'Project_Ref'.
Would appreciate you prompt response.
Best
David
You need to add a Select in Field action to the OnSelect trigger of the Project_Number field. The field to select in would be Project_Ref and the search string would be ='(' & concat(distinct Project_Number, '|' & ')'.
if(Project_Ref = Project_Number,Project_Ref) as Project_Ref_match
See attached