Help

Re: Cant use UPPER() on a field from a look up

587 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Craig_Watson
6 - Interface Innovator
6 - Interface Innovator

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

4 Replies 4

It works for me, ¿what type of field is the one where your put UPPER function?

72fe2e393f77048360bb8d505ba70f69d27bca84.png

Craig_Watson
6 - Interface Innovator
6 - Interface Innovator

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.

Captura de pantalla 2019-02-11_03-17-44_p. m..png

You can ‘stringify’ if by adding &'' to the field name, or using the CONCATENATE() function.

Captura de pantalla 2019-02-11_03-19-09_p. m..png

6437c9208e84aefa4848d15ddce69596cc3556a4.png

Perfect! Thank you for that :thumbs_up: