Script to get the first nine characters of a field

[RIck_Allen]

I’m hoping to get the first 9 characters of a record into another field. Id normally just make the field into a formula and use Left({product},9) but the rest of the automation wont run on the formula field.

Please help.

[Kamille_Parks]

In javascript you’d do: variableName.substring(0, 😎

https://www.w3schools.com/jsref/jsref_substring.asp

[Justin_Barrett · Accepted solution]

Another option is to use an “Update record” action to copy the result from the formula field to a single line text field, then use that value later in the automation.

[RIck_Allen]

Thanks Justin, that worked a treat.

[Justin_Barrett]

Glad to know that you got the answer you were seeking! If you would, please mark my comment (the one above, not this one) as the solution to your question. This helps others who may be searching with similar questions. Thanks!