Is there a way to allow only specifc text in Forms?

Hi!

I am trying to have specific email addresses (those in the email column of my user profile sheet) be the only valid email addresses that work behind a form button I created.

I’m also looking for the same thing in a text box I created in the form. That the text be the same as the text I have in a text colulm I created in a sheet.

And that both email AND text should match for the form to Submit. If someone hits submit without meeting both it doesn’t go through and they get an error message.

Is there a way to do that?

Thanks!

To do so, you need to create user-specific columns and validate them using relations to your data outside of a form.

1 Like