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

null
    • John_Halls
    • 2 days ago
    • Reported - view

    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

    • Ninox partner
    • RoSoft_Steven.1
    • 2 days ago
    • Reported - view

    ---"{ ROLE }"---

    If you put the above in a formula field, you'll get "1234"

    or :

    """" + ROLE + """"