Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Lisa SeilerLisa Seiler 

Auto Number in process builder (MIN)

Hi @ all,
i tried to use the MIN function in the process builder with a auto number. But he tell me that he is expecting a number but received a text. Can someone help me?

Lisa
Matt SmelserMatt Smelser
Lisa-
Auto number are a text field and not number field. If this name field does not contain any text you can convert the test to a number by using the VALUE function. https://help.salesforce.com/articleView?id=customize_functions_i_z.htm&type=0&language=en_US
Lisa SeilerLisa Seiler
Thank you, this solution is great, but my auto numbers look like this:
O-000000068

And thats a big problem.....can you help me with a other idea?
Matt SmelserMatt Smelser
Lisa-
If the name is always the same length you could just use the Formula RIGHT to remove the right 2 characters. It would be something like this "VALUE(RIGHT(NAME,10))" which would return the value of the name above.