Checking matches with Google Apps Script directly in Google Forms?
I collect people's full names through Google Forms, etc.the data, and the form writes it to the Google spreadsheet.
I really need now that when filling out each field, the form checks whether there is a match in the Google table. I.e., I check whether this person has sent their data before.
And if there is an exact match in all three fields F,I,O, he displayed a message or another option for instant display (for example, he circled the field in red).
Me it seems that with the help of Google Apps Script it was possible to do this, but I'm not good at programming.
2 answers
You can't do this, because Google Forms don't have a client-side API.
You asked me a question on my blog http://disq.us/p/24dufix
I duplicate the answer: There are no direct tools for implementing such a task.
But there are workarounds: 1) You can use the pages in the form to check the data entered in the form (this is extremely inconvenient). 2) You can write a web app (web page) that will work with the data in the table as you want. To do this, you will need knowledge of gas html css javascript.