Skip to main content
L
loozle
Inspiring
August 5, 2023
Question

Validate 2 fields have same data

  • August 5, 2023
  • 2 replies
  • 405 views

Hello,

I would like to confirm two fields have the same data in them. I've a dropdown list with months listed January through December. I would like the user to confirm the month in another dropdown that has an identical list and if possible, provide a warning if they do not match.

 

Is there an out of the box way accomplish this?

If not, what else might be done to check this?

 

Thank you

This topic has been closed for replies.

2 replies

Meenakshi_Negi
Meenakshi_Negi
Legend
August 13, 2023

Hi loozle,

 

Thank you for reaching out, and sorry about the delay in response.

 

We have checked that you have found the solution. Thank you for sharing your findings here.

It will help other users with similar issues.

 

Thanks,

Meenakshi

L
loozleAuthor
Inspiring
August 9, 2023

After researching further, I wondered about using a formula and found a few tips along the way, played with it a while and came up with this.

 

I have three fields:

DOB Year, DOB Year Confirmation  & DOB Year Match?

 

The third field I set up as Read Only with a Value Type of Calculated Value and after trial and error found this formula works great for me.

if([DOB Year] = [DOB Year Confirmation], "", "Please confirm and correct the DOB Year as these fields do not match.")

The first empty set of quotes would display a true message if I needed that, but I only wanted the second set of quotes to display the false message. This alerts the user and that works for me.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices