Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

2084 4
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: