We have an editable string field which needs to be moved to a secure page for super users, and a calculated attribute needs to be created for normal users.
Here, how can I convert the string to upper case. Please help me with the syntax
Not sure that you can do it in a calculated attribute?
However I am sure that you could do it like this ; TIP : How To Put Any Dynamically Generated Value On A Clarity Object
I do not think it is possible. I mean I have not done this personally and there is no such OOTB method by which you can do that. But if changing the case of the string is really important for you, then you can try to create a process which will update the database column so that the case is changed. There are functions like LOWER() and UPPER()which can be used in the database level. So I am suggesting you to update the attribute value's case from the DB end. This process can be triggered whenever the calculated attribute is updated. You can just try this. Hope that helps.
Thanks David and Abhishek. I guess it would be good to have the basic functions allowed for the calculated string attribute. For now, I will go ahead with having a dynamic query lookup, as suggested by David since it will make it is easy to maintain