Add "Contains" operator to formula fields

  • 2
  • Idea
  • Updated 3 years ago
  • Implemented
Would like to see a "CONTAINS" operator added to formula operators. This would behave similar to:

CONTAINS(<sourcevalue>, <substring>)

and would return TRUE/FALSE

Thank you!
Photo of Barry Schnell

Barry Schnell, Champion

  • 18,086 Points 10k badge 2x thumb

Posted 3 years ago

  • 2
Photo of Irvin Waldman

Irvin Waldman, Champion

  • 9,006 Points 5k badge 2x thumb
Photo of Barry Schnell

Barry Schnell, Champion

  • 18,086 Points 10k badge 2x thumb
Yep!
Photo of Zach McElrath

Zach McElrath, Employee

  • 49,056 Points 20k badge 2x thumb
This is on our near-term roadmap.
Photo of Barry Schnell

Barry Schnell, Champion

  • 18,086 Points 10k badge 2x thumb
Awesome news, thanks for the insight Zach!
Photo of Zach McElrath

Zach McElrath, Employee

  • 49,056 Points 20k badge 2x thumb
This has been implemented as of Banzai Update 6 Patch 4, now available from the Skuid Releases page.

The following Formula Operators have been added that help with string / text operations:

 - CONTAINS(stringToExamine,stringToLookFor) --- returns true/false
 - ENDS_WITH(stringToExamine,stringToLookFor)  --- returns true/false
 - STARTS_WITH(stringToExamine,stringToLookFor) --- returns true/false
 - LEFT(stringToExamine,numCharacters) --- returns a substring of stringToExamine starting from the left and going numCharacters to the right
 - RIGHT(stringToExamine,numCharacters) --- returns a substring of stringToExamine starting from the right and going numCharacters to the left
(Edited)
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
WOOT! 
Photo of Barry Schnell

Barry Schnell, Champion

  • 18,086 Points 10k badge 2x thumb
Awesome news, thank you!  A VERY welcomed addition!