Null field value if no value is given on form submit | Community
Skip to main content
Christina_Dearm
Level 2
March 8, 2018
Solved

Null field value if no value is given on form submit

  • March 8, 2018
  • 1 reply
  • 16291 views

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?

Best answer by SanfordWhiteman

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

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
Level 10
March 8, 2018
Grégoire_Miche2
Level 10
March 22, 2018

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

SanfordWhiteman
Level 10
March 22, 2018

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.