Match input in form field with data in specific Column

Hi yo everyone,

I have a challenge I’m looking to solve. People outside of my organization need to send me information using a form. However, I would like to prevent them from sending the form if an input the give (a number in that case) does not match a number I already have in that board.

Does that make sense? any suggestion on how do I do that?
The basic monday.com Form doesn’t seem to allow something like this. Thank you all!

You can use the Duplicates and Uniques app for that.
For your use case, you can create a template that searches for unique numbers. If a unique number is found (that is, does not exist) the app will delete it.

Here is a demo on how to create a template to delete duplicates (but in your case, you will have to select “Unique values”)

This doesn’t solve what I was talking about, unfortunately.

Hey @tomaz

Assuming your not doing this for verification reasons, why not make this question a Status field and have the submitter select one of the pre defined values you set (and make the question required)?

1 Like

The submitter of the form need to submit a number (ID in this case), to match their information from a large document (>60K items). I wouldn’t want to create >60K statuses.