Form results not showing correctly | Community
Skip to main content
Georgina_Guy
Georgina_Guy
Level 1
May 2, 2018
Question

Form results not showing correctly

  • May 2, 2018
  • 2 replies
  • 1489 views

I've recently added to fields to a form and the results for both are only showing as 0. How do I pull through the value the customer will have selected within the form?

1. Checkbox selection

This is showing in the field management as:

2.

This is showing in the field management as:

When I pull a smart list report both of these values show as 0 and the field within the contact info also shows as 0.

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

2 replies

Grégoire_Miche2
Grégoire_Miche2
Level 10
May 2, 2018

Hi Georgina,

When using checkboxes in the form, you have to define the displayed value and the stored value. A few points here:

  1. Your field type is integer. Meaning you can only store 1 number if the field. So the "stored values" you define in the form has to be numeric
  2. You have displayed your 1st field as Checkboxes. This means that a visitor can check multiple boxes. A Internet type fields cannot store multiple values. Only text fields can.

So you need to change the 1st field type to string, not Integer. You can only do this by removing any usage of the field (including in the form) then change the field type, then add the field back where it was used.

For the second field, it's probably linked to the "stored valued" that are not set as numbers.

-Greg

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    May 2, 2018

    Like Greg says, if you're sending Strings to Marketo (in the case of Checkboxes, a semicolon-delimited String representing multiple values) but the back end is expecting an Integer, you will lose data.

    What can be confusing is that you don't lose all data.  A String without any numbers, or which doesn't have a number at the start, will be stored as Integer 0. However a value that starts with a number (a "numeroalphabetic" string) will retain that initial number.  So if you happen to have a checkbox list like "66 apples;11 oranges; 23 pears" the final value will be 66. If it were "apples;oranges;23 pears" the value would be 0.

    Needless to say, you want to stay far, far away from any datatype conversion surprises.

    Terms & ConditionsAccessibility statement

    Loading footer...