Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have two fields, Zone and Office.
1 Zone -> N Offices
And every Office is associated to one Zone
If I select a particular Office, I want to know if there's any function to get the associated Zone to that selected Office.
Is there any way to do that?
Thank you!!!
Create a text box and type below...
=CONCAT(DISTINCT ZONE,', ')
Only(ZONE)
will only work when you select an office
there is a few ways to get that value, I believe the above is best
else Maxstring(ZONE)
or FieldValue('ZONE',1)
or CONCAT(DISTINCT ZONE,', ') as per Manish