Adding data to Google Forms from Google Sheets?

Question

Google Apps Script

Good afternoon, dear forum users!
Please tell me if it is possible to do this:
Yes. There is a "Google-form-1", where the personal data for the candidate is manually filled in based on the results of the interview. The results of this Google Form 1 are automatically stored in Google Sheet 1 in the Form 1 Responses tab. In the same "Google-table-1" there is a second tab "positions", it serves as a directory of positions: secretary, manager, analyst, journalist, writer, etc. This guide is updated manually as needed.
Required. It is necessary to somehow add data from the “Google-table-1” from the “Posts” tab to the required field in the “Google-form-1”.

Answer 1

This process is called "auto-completion of Form fields". Look for the addon that suits you from the list of addons of the Form itself.
It is also possible to develop your own script.

Answer 2

This video describes the solution to your problem in great detail .