Need help creating a trainee evaluation form. Let me explain, I have 8 trainees and I need to evaluate them using an evaluation sheet attached. I can develop the menus and submenus, but I’m stuck when it comes to integrating the form. I can’t figure out how to have this form once filled out integrated into a trainee sheet and on a line of the spreadsheet. Can you help me? Thank you.
If you absolutely need to have that layout, I would suggest trying to find a third-party service form builder that does this.
Then use the form link to embed inside your app, or have a button to open the form link.
After the form is submitted, either write the values back to Glide using the API, or generate a PDF and save the PDF file link back to Glide, also using the API.
If you don’t need that layout, create a bunch of choice components corresponding to each category, and give them 4 choices.
First of all, thank you for your response. I’m using the second solution, but the form containers are being saved on different lines. I can’t seem to get all the different form containers to be added on the same line for the trainee in their dedicated sheet.
That is to be expected.
Every time a Form is submitted, a new row is created. That is the purpose of a form, and there is no way to change that.
You either have to collect everything you need in a single form, or use a form to collect the first part/section, and then use an Edit form (that edits the existing row) to collect any additional data.
2 Likes