Form results not showing correctly

Georgina_Guy
Level 1

Form results not showing correctly

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

Screen Shot 2018-05-02 at 11.24.25.png

This is showing in the field management as:

Screen Shot 2018-05-02 at 11.27.43.png

2.

Screen Shot 2018-05-02 at 11.28.41.png

This is showing in the field management as:

Screen Shot 2018-05-02 at 11.29.27.png

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.

2 REPLIES 2
Grégoire_Miche2
Level 10

Re: Form results not showing correctly

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
Level 10 - Community Moderator

Re: Form results not showing correctly

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.