Forum Discussion

ShontaySmith's avatar
ShontaySmith
Qrew Assistant Captain
8 years ago

How to create a if statement using the first 4 char of a text field

I need help trying to create an if state using the first 3 or 4 char of a text field For example if  [text field 1] start with 7083 = 083                          [text field 1] start with 083 = 0...
ChrisChris's avatar
ChrisChris
Qrew Assistant Captain
8 years ago

assuming the string you're checking is text, the formula field may go something like:

if(

begins([field],"7083"),"083",

begins([field],"083"),"083"

)

The Begin() function works on text fields, so if you're comparing numbers, you'd have to use the ToText() fuction around the expression.


This link may help you with formula functions:

https://login.quickbase.com/db/6ewwzuuj?a=q&qid=6