Jump to content
  • 0

Formula for contains



6 answers to this question

Recommended Posts

  • 0

Thank you for the suggestions. I tried the solutions above. 

It seems that Barbie's solution outputs a 'Yes' if the text 'emp' is placed anywhere on the username.  But for DefinitelyNot31337's solution, it outputs a 'Employee' if the username starts with 'emp'. 

Solutions are great so I utilized them both. Here is a reference as well: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/#:~:text=Birth. Learn more.-,Conditional Cases in Calculated Fields,-You can use

Link to comment
Share on other sites

  • 0

@trickson you can also try Charindex() for this. Charindex will output the starting point of the string or the character that you are looking for and if that value is greater than 0 that means that there is an Emp in the string. 

  WHEN Charindex('Emp',[@field:Name]) > 0
  THEN 'Employee'
  ELSE 'Manager'

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...