Expand my Community achievements bar.

hnalbandyan
hnalbandyan
Offline
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • The following expression should do it IF(LEN({DE:Global | Global marketing campaign id}) != 9,"Please write '2 Alpha' '7 digit' and 'in total it should be 9' without spaces (eg-tmtpredict)", IF(CONTAINS(0, LEFT({DE:Global | Global marketing campaign id}, 2)), "Please start with '2 Alpha' without spa...

    Type

    Questions

    Views

    298

    Like

    1

    Replies

    1
  • Thanks for trying.To make sure I understand your case correctly, your original problem was that you wanted the field value to have 9 characters, right? The formula you have right now is saying if the field's length is 9 characters, show the error message. Hence, if you type anything expect 9 length ...

    Type

    Questions

    Views

    306

    Likes

    0

    Replies

    3
  • Thanks for reaching out. Could you please retry with double equation signs?IF(LEN({DE:Global | Global marketing campaign id}) == 9,"Please write '2 Alpha' '7 digit' and 'in total it should be 9' without spaces (eg-tmtpredict)")

    Type

    Questions

    Views

    372

    Likes

    0

    Replies

    5
  • I can see the question has an accepted answer, but I am happy to let you know that with the release of 25.10 you can achieve this via Custom Field Validations. You can even show the number of characters that are over the limit in the error message. A good example of it can be found under this discus...

    Type

    Questions

    Views

    406

    Like

    1

    Replies

    0
Top badges earned by hnalbandyan
Customize the badges you want to showcase on your profile