Check if value is unique | Community
Skip to main content
Nick_Deboo1
Nick_Deboo1
Level 2
September 22, 2016
Question

Check if value is unique

  • September 22, 2016
  • 2 replies
  • 1952 views

Hi

We have a software that links contact form on our website and the link contains a ID number. It's easy to store the ID but I would like to check if the ID is unique. We only allow one form submit.

Is is possible to check if the value of a custom field is unique?

ps. I know that an id is not the best solution, a custom solution in the software would be better...

2 replies

SanfordWhiteman
SanfordWhiteman
Level 10
September 22, 2016

Unique across your entire Marketo database?

Or unique as in the form was not already posted on behalf of this email address with this ID value?

Please explain the use case a bit more.

Nick_Deboo1
Nick_Deboo1Author
Level 2
September 23, 2016

This is my use case. Notice that the form ID comes from our software in a parameter. Our software generates an unique ID.

October 1st

Person A submits form:   john.doe@example.com     ID= 1234   -> ok

November 1st

Person A submits form:   john.doe@example.com     ID= 1234   -> not ok, we don't want the same person submitting the form again. The person will get an email saying he has done this already.

Person A: john.doe@gmail.com ID=1234    ->not ok because this is the same user as on October first. We know this by ID

Can we in the last submit check if the same ID has been used by another email address?

Nick_Deboo1
Nick_Deboo1Author
Level 2
October 7, 2016

So far I haven't been able to check if a field (across the entire database), contains the same value.

Terms & ConditionsAccessibility statement

Loading footer...