Skip to main content

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:


Reply