Forum Discussion

DawnRene3's avatar
DawnRene3
Qrew Trainee
6 months ago

Conditional formula url

I'm trying to build a conditional url formula where if a multiple choice field equals a certain person, display this url. Unfortunately, it's not pulling in anything. Here is my current syntax in the...
  • MarkShnier__You's avatar
    6 months ago

    You need to see what the result is of 

    ToText([Contractor Operations Manager])

    I suspect that the field is a user type field so the totext result of that will be either their email address or the or their username if they have one.

    If indeed its a userid field, then you should chjnage it to this

    Case(UserToEmail([Contractor Operations Manager]),

    "struthers@mycompany.com","https://calendly.com/sally.struthers",

    "fflintstone@ompany.com","https://calendly.com/fred.flintstone")

     

    Having said that, it's not good practice to hard code this into a formula field as these people will change over time. It would be a lot better if you could have a table of operations managers and pull in a lookup of the calendy URL