2 Replies Latest reply on May 2, 2018 10:25 AM by Sanford Whiteman

    Form results not showing correctly

    Georgina Guy

      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.

        • Re: Form results not showing correctly
          Grégoire Michel

          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

          • Re: Form results not showing correctly
            Sanford Whiteman

            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.