0
Error """ in formula field
Hi,
In a formula field I have a value to insert between two "". The field with the value is called ROLE and contains a number. If I write """+ROLE+""" I would like to get "1234" instead it shows me an error.
2 replies
-
Hi Andrea
You could use urlDecode. The code for a quote is %22 and so your formula should be
urlDecode("%22"+ROLE+"%22")
Regards John
-
---"{ ROLE }"---
If you put the above in a formula field, you'll get "1234"
or :
"""" + ROLE + """"
Content aside
- 2 days agoLast active
- 2Replies
- 23Views
-
3
Following