SOLVED

Compute Formula execution issues

Go to solution
Rick_Segura1
Level 2

Compute Formula execution issues

I installed the Compute Formula service per this user guide all initially looked well, until I attempted to execute an AIO Compute Formula step.  I set up a few string fields as input fields for the service, but no matter how simple of formula I supply, when the AIO Compute Formula step executes, it fails and produces the following error messages:

"Skipped Choice had one or more invalid tokens"

"Choice had one or more invalid tokens"

 

Would anyone know why it would produce this message?  Is there an easy way to validate the installation of the AIO Compute Formula service?

 

Here is how the service appears in the Service Providers page:

Rick_Segura1_0-1698932923658.png

 

Service setup details with incoming field mapping:

Rick_Segura1_3-1698933124550.png

 

A screenshot of the simple task I created:

Rick_Segura1_2-1698933023151.png

 

Activity error produced by the step:

Rick_Segura1_5-1698933235339.png

 

Rick_Segura1_4-1698933201006.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Rick_Segura1
Level 2

Re: Compute Formula execution issues

I figured it out.  Since I am passing a string token to the function, I need to surround the token with single quotes:

PROPER('{{lead.Billing Country}}')

View solution in original post

2 REPLIES 2
Rick_Segura1
Level 2

Re: Compute Formula execution issues

After a good night's rest, I changed up my testing tactic and supplied a literal value to the formula as such:

PROPER('us')

The produced the value of 'Us' correctly.

 

However, our install of Compute Formula is not accepting what seems to be a valid token such as:

PROPER({{lead.Billing Country}})

This produces the "token" error mentioned in my original post.

Rick_Segura1
Level 2

Re: Compute Formula execution issues

I figured it out.  Since I am passing a string token to the function, I need to surround the token with single quotes:

PROPER('{{lead.Billing Country}}')