Doing a little math in a flow step using tokens | Community
Skip to main content
New Participant
December 12, 2022
Solved

Doing a little math in a flow step using tokens

  • December 12, 2022
  • 1 reply
  • 2184 views

Hello all, 

 

I'm doing a little experiment to see if it's possible to calculate a new value in a currency field based on another currency field, using a flow step and tokens.  I know this type of thing works with date fields, for example {{lead.Date of Birth}} + 18 years, but am curious if this trick translates to other field types.  Here's what I'm trying to achieve:

 

  • If someone has an Available Trip Credit under $1000, we want to double that and populate a separate field called Increased Trip Credit Value with the doubled amount.  So if they have a $400 credit, the newly calculated value would be $800.  
  • We want to put a cap on the upper limit of that credit they can double (of $1000, so the most they can get is $2000).  

This is what I've attempted so far - Choice 1 works, but Choice 2 doesn't.  Not totally surprised about that...  Am I using the wrong formatting or anything, or is it just not possible?  Are there other ways to do calculations in Marketo besides this type of flow step and token trick?  

 

 

Thanks!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Darshil_Shah1

Marketo cannot do arithmetic/string operations other than appending/concatenating values using tokens in the flow steps. Of course, as you said, we're able to do addition operations for the date/date time fields, but that isn't quite yet supported for other fields. You'd probably want to use a webhook-compatible service (I'd highly recommend checking out Flowboost) that could perform the required operation and return the result back.

 

1 reply

Darshil_Shah1
Darshil_Shah1Accepted solution
Community Manager
December 12, 2022

Marketo cannot do arithmetic/string operations other than appending/concatenating values using tokens in the flow steps. Of course, as you said, we're able to do addition operations for the date/date time fields, but that isn't quite yet supported for other fields. You'd probably want to use a webhook-compatible service (I'd highly recommend checking out Flowboost) that could perform the required operation and return the result back.

 

New Participant
December 13, 2022

Thanks for the confirmation, @darshil_shah1!