How to link 2 Google Forms to each other?

Question

Google Apps Script

Good afternoon. There was a task to create a system for controlling the sale of promotional products using promotional codes.
How it should work:
The first Google form was created for issuing a promo code, the phone number of the person who wants to receive a promo code is entered into it. Through the script launched after the submit button, a promo code is generated based on the phone number and added to the adjacent right cell from the phone number added by the form through the script. Next, a request is sent to the SMS mailing service and the person receives a promo code.
When contacting the store, a person shows an SMS with a promo code. The seller drives the promo code and the purchased product into the second Google form .
What needs to be done:
1) Checking promo codes. Those. the promo code to be entered is searched in the list of promo codes generated by the first form, if it is not present, the form does not allow sending a response.
2) When entering the correct promotional code, the purchased goods entered in the second form should be transferred to the first table (with phone numbers and promotional codes).
I did not find how to set up validation of entered data from another table (as well as validation from the same table, if the results of both forms are transferred to different sheets of the same table). How to search and substitute values ​​by promo code too.
Friends, help me find a solution. Thank you.

Answer 1

The task is not trivial. I don’t even know if it’s worth solving it through Google Apps Script.
Let us suppose that there are two Forms. First, you need a place for the generation of promotional codes. And it should be a table. Secondly, when using a promotional code, you need to find out its validity. Ah, well, it's not worth continuing further - Forms are non-interactive . A form is an interface for collecting information. An interface is a set of means, methods and rules of interaction in which there is no possibility of feedback. The developer does not have access to the implementation of such methods as loading the Form, validating data on the client side, etc. the developer is unable to implement the Forms interface .
It has access to the Forms repository interface. Those. the developer can refer to the address of the Form, get its data, change its properties.
Only high-quality and verified content

• google-apps-script-english.gitlab.io