Help

Re: Script to get the first nine characters of a field

Solved
Jump to Solution
984 0
cancel
Showing results for 
Search instead for 
Did you mean: 
RIck_Allen
6 - Interface Innovator
6 - Interface Innovator

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
Justin_Barrett
18 - Pluto
18 - Pluto

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

Justin_Barrett
18 - Pluto
18 - Pluto

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
6 - Interface Innovator
6 - Interface Innovator

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!