Hi,
I am looking up a value from a linked record which works fine, however, when I tried to use UPPER({Look Up})
in another field I just get an error.
I am just looking to understand why that would not work and am I missing something simple.
Craig
Hi,
I am looking up a value from a linked record which works fine, however, when I tried to use UPPER({Look Up})
in another field I just get an error.
I am just looking to understand why that would not work and am I missing something simple.
Craig
It works for me, ¿what type of field is the one where your put UPPER function?
Hi,
I was using the UPPER()
on a look-up from the linked record, not directly on the linked field, would that make a difference?
Hi,
I was using the UPPER()
on a look-up from the linked record, not directly on the linked field, would that make a difference?
Oh excuse me, I think the problem is that the lookup returns an Array, and UPPER()
expects a String.
You can ‘stringify’ if by adding &''
to the field name, or using the CONCATENATE()
function.
Oh excuse me, I think the problem is that the lookup returns an Array, and UPPER()
expects a String.
You can ‘stringify’ if by adding &''
to the field name, or using the CONCATENATE()
function.
Perfect! Thank you for that :thumbs_up:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.