AnsweredAssumed Answered

Null field value if no value is given on form submit

Question asked by Christina Dearman on Mar 8, 2018
Latest reply on Mar 22, 2018 by Sanford Whiteman

Like • Show 0 Likes0
Comment • 10

We are trying to set up a process where if a person submits a form, and a non-required field is left empty, we infer that means the person no longer has that item.

Example: Bill told us 4 years ago he grows Rice. This year he renews his subscription to our magazine and leaves Rice blank (we cannot pre-fill per print audit rules). We want to have Marketo wipe out his previous answer and assume he no longer grows rice.

Can that be accomplished?

I thought perhaps have some sort of trigger campaign but that will overload our system and create a log jam in our Campaign Queue.

Ideas?

Sanford Whiteman Mar 8, 2018 10:27 AM

Correct Answer

That's the exact situation I covered here: http://blog.teknkl.com/clearing-lead-fields-when-no-value-submitted/

See the reply in context

No one else had this question

Outcomes

Sanford Whiteman Mar 8, 2018 10:27 AM

That's the exact situation I covered here: http://blog.teknkl.com/clearing-lead-fields-when-no-value-submitted/

2 people found this helpful

Actions

Grégoire Michel @ Sanford Whiteman on Mar 22, 2018 9:38 AM

Hi Sanford Whiteman,

I have read the blog article and have a question: why adding a null value to the fields in the form. Why not simply capturing the fact that the form fields are empty and set a NULL value ?

-Greg

Actions

Sanford Whiteman @ Grégoire Michel on Mar 22, 2018 9:55 AM

Because not every field is expected to turn no answer → NULL.

The same could be done with a configuration block at the top of the JS, but I opted to not do that in this case.

Actions

Grégoire Michel @ Sanford Whiteman on Mar 22, 2018 10:18 AM

OK,

It's just a way to detect which fields should be processed that way. So a class in the label would also do the trick. Or a conf field by a token and containing the list of data-wrapper-for tag attributes ?

-Greg

Actions

Sanford Whiteman @ Grégoire Michel on Mar 22, 2018 10:25 AM

Right, I would use an array of field names if going with the conf block.

Actions

Grégoire Michel @ Sanford Whiteman on Mar 22, 2018 12:11 PM

Here is my code, using an array, but the NULL does not post to the database

Page : placo

result:

and the field remains unchanged...

Any idea bout a bug I might have introduced?

-Greg

Actions

Sanford Whiteman @ Grégoire Michel on Mar 22, 2018 1:20 PM

Ha! Now I remember (stupid to forget) the other reason I add the "NULL" as an actual value: you can't setValues() on an enum field (checkboxes, select, radio) unless the value exists as part of the enumeration.

Also, be careful to not use Array#includes, Object.entries, or Object.values on public sites yet as they don't work in IE.

And I'd probably have done the iteration like this:

Object.keys(currentVals)
.filter(function(field){
  return ( NullifiableFieldNames.indexOf(field) != -1 && currentVals[field] );
})
.forEach(function(field){
  newFormData[field] = "NULL";
});

1 person found this helpful

Actions

Grégoire Michel @ Sanford Whiteman on Mar 22, 2018 2:39 PM

you can't setValues() on an enum field (checkboxes, select, radio) unless the value exists as part of the enumeration

So I guess then the best way to set this up is to select all the fields that have a NULL in the enumeration as you did in the blog post and drop the idea of designating the fields through an array.

Thx so much!

-Greg

Actions

Grégoire Michel @ Grégoire Michel on Mar 22, 2018 3:58 PM

Hi again Sanford Whiteman,

Also, be careful to not use Array#includes, Object.entries, or Object.values on public sites yet as they don't work in IE.

How do I test the existence of a field in the form ?

-Greg

Actions

Sanford Whiteman @ Grégoire Michel on Mar 22, 2018 4:06 PM

Object.keys as in my example above (it's older than the others and in IE9).

1 person found this helpful

Actions

10 Replies

Sanford Whiteman Mar 8, 2018 10:27 AM
Unmark Correct
Correct Answer
That's the exact situation I covered here: http://blog.teknkl.com/clearing-lead-fields-when-no-value-submitted/
2 people found this helpful
Like • Show 0 Likes0
Actions
- Grégoire Michel @ Sanford Whiteman on Mar 22, 2018 9:38 AM
  Mark Correct
  Correct Answer
  Hi Sanford Whiteman,
  
  I have read the blog article and have a question: why adding a null value to the fields in the form. Why not simply capturing the fact that the form fields are empty and set a NULL value ?
  -Greg
  Like • Show 0 Likes0
  Actions
  - Sanford Whiteman @ Grégoire Michel on Mar 22, 2018 9:55 AM
    Mark Correct
    Correct Answer
    Because not every field is expected to turn no answer → NULL.
    
    The same could be done with a configuration block at the top of the JS, but I opted to not do that in this case.
    Like • Show 0 Likes0
    Actions
    - Grégoire Michel @ Sanford Whiteman on Mar 22, 2018 10:18 AM
      Mark Correct
      Correct Answer
      OK,
      
      It's just a way to detect which fields should be processed that way. So a class in the label would also do the trick. Or a conf field by a token and containing the list of data-wrapper-for tag attributes ?
      
      -Greg
      Like • Show 0 Likes0
      Actions
      - Sanford Whiteman @ Grégoire Michel on Mar 22, 2018 10:25 AM
        Mark Correct
        Correct Answer
        Right, I would use an array of field names if going with the conf block.
        Like • Show 0 Likes0
        Actions
        Grégoire Michel @ Sanford Whiteman on Mar 22, 2018 12:11 PM
        Mark Correct
        Correct Answer
        Here is my code, using an array, but the NULL does not post to the database
        
        Page : placo
        
        result:
        and the field remains unchanged...
        
        Any idea bout a bug I might have introduced?
        
        -Greg
        Like • Show 0 Likes0
        Actions
        Sanford Whiteman @ Grégoire Michel on Mar 22, 2018 1:20 PM
        Mark Correct
        Correct Answer
        Ha! Now I remember (stupid to forget) the other reason I add the "NULL" as an actual value: you can't setValues() on an enum field (checkboxes, select, radio) unless the value exists as part of the enumeration.
        
        Also, be careful to not use Array#includes, Object.entries, or Object.values on public sites yet as they don't work in IE.
        
        And I'd probably have done the iteration like this:
        
        Object.keys(currentVals) .filter(function(field){ return ( NullifiableFieldNames.indexOf(field) != -1 && currentVals[field] ); }) .forEach(function(field){ newFormData[field] = "NULL"; });
        1 person found this helpful
        Like • Show 1 Like1
        Actions
        Grégoire Michel @ Sanford Whiteman on Mar 22, 2018 2:39 PM
        Mark Correct
        Correct Answer
        you can't setValues() on an enum field (checkboxes, select, radio) unless the value exists as part of the enumeration
        So I guess then the best way to set this up is to select all the fields that have a NULL in the enumeration as you did in the blog post and drop the idea of designating the fields through an array.
        
        Thx so much!
        
        -Greg
        Like • Show 1 Like1
        Actions
        Grégoire Michel @ Grégoire Michel on Mar 22, 2018 3:58 PM
        Mark Correct
        Correct Answer
        Hi again Sanford Whiteman,
        
        Also, be careful to not use Array#includes, Object.entries, or Object.values on public sites yet as they don't work in IE.
        
        How do I test the existence of a field in the form ?
        
        -Greg
        Like • Show 0 Likes0
        Actions
        Sanford Whiteman @ Grégoire Michel on Mar 22, 2018 4:06 PM
        Mark Correct
        Correct Answer
        Object.keys as in my example above (it's older than the others and in IE9).
        1 person found this helpful
        Like • Show 0 Likes0
        Actions

Null field value if no value is given on form submit

Outcomes

Related Content

Recommended Content