Conditional Statement In Webhooks

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I am trying to see if I can create a conditional statement when using a webhook.
I have 3 fields that I am trying to concatenate when 1 are not empty.

An example of what I am trying to attempt is as follows...
I have text fields: First Name, Middle Name, Last Name, Full Name

If First Name is Empty Full Name = "ERROR"
Full Name = "First Name" + "Middle Name" + "Last Name"

I am having trouble finding how to do this...

Please advise...
Photo of Dan Park

Dan Park

  • 440 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
This is an example of the formula you will want to use to make the concatenated result:

If([First Name]="" OR [Middle Name]="" OR [Last Name]="", "ERROR",
List(" ", [First Name], [Middle Name], [Last Name]))
Let me know if that works for you,

As far as the webhook, you will need to set the triggers dependent on the criteria you need.  If you get stuck on that, post back with more details and questions.