Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Script to get the first nine characters of a field

Topic Labels: Scripting extentions
Solved
Jump to Solution
444 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

1 Solution

Accepted Solutions

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.

See Solution in Thread

4 Replies 4

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

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

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.

Thanks Justin, that worked a treat.

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!