Hello!
I am currently trying to build a Dynamic Object that returns a URL format where the first two numbers after the static portion of the URL represent the numerical value of the letter + 1.
For instance, our order numbers are in the format of AV123456. I have this set to work as a dynamic object and it returns the correct URL. It is currently set as:
Target String: A,Letters (exactly 1), Digits (Exactly 6)
Target URL: ************************************next/21Digits(Exactly 6)
It works beautifully. However, there are previous orders and future orders where the second letter is not V, and for this reason, 21 will not remain permanently static.
21****** represents the value of V(20) + 1 and the * represent the remaining numerical digits of the order number.
Is there a way to build out a dynamic reference that takes the Letter Value, Converts it to the Numerical Value and then Adds 1 to it?