How to deal with score calculation that field type is float instead of score?

Forum|Forum|5 years ago
January 7, 2021
1 reply
2338 views

Hi Community,

I'm looking to recreate the functionality a "Change Score" flow step does. Essentially is to add float fields to maintain a cumulative score based on these float fields.

The reason I'm looking into this is because "Change Score" can only handle field with "Score" type, which has to be integer. My case is to cumulatively added up float numbers, such as 0.023, 1,64, etc.

Any suggestion/workaround is welcome!

Thank you!

Rebecca

Marketo

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 SanfordWhiteman

The Float datatype shouldn't be used for anything in Marketo, really — use scaled Integers anywhere you'd think about using a (32-bit) Float.

If you must, you can do floating-point score math via a webhook.

SanfordWhitemanAccepted solution

New Participant

The Float datatype shouldn't be used for anything in Marketo, really — use scaled Integers anywhere you'd think about using a (32-bit) Float.

If you must, you can do floating-point score math via a webhook.

P

polinakoroleva

New Participant

Hi Sanford,

Could you please give some more details? we are facing the same problem at the moment and for us is very crucial to have that particular score with decimals.

Appreciate any advice,

Kindest,

Polina

SanfordWhiteman

New Participant

Could you please give some more details? we are facing the same problem at the moment and for us is very crucial to have that particular score with decimals.

You can't do this kind of math without passing the scores to a webhook and mapping the result back to a field.

Not sure if there are deeper details you need — and due to Community rules I can't recommend a specific service.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded