Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 16, 2022 03:19 PM
Hi all,
I’m new to airtable. My students complete a form that captures their goals for the year. Is it possible to have another form that will populate the goals after I choose the student’s name? I’d like to use the second form to create notes on goal progress.
Thanks!
Aug 16, 2022 03:30 PM
Hi @Ordinarie_Heroes,
Yes, you can prefill a form with existing data in your base. Take a look at this documentation: https://support.airtable.com/hc/en-us/articles/234982508-Prefilling-a-form
Aug 16, 2022 04:26 PM
Hi @Vivid-Squid. Thanks for the reply. Will this allow me to choose a different student every time? For instance if I pick student A, I’d like their info to populate. If I change to student B, I’d like their info to show.
Aug 16, 2022 10:47 PM
Welcome to the community, @Ordinarie_Heroes! :grinning_face_with_big_eyes: Could you please share more details about your base design? It’s tough to get a clear picture with what’s been shared so far. Field types and table names are all helpful details. Screenshots are even better (even if they’re “doctored” for privacy). There’s likely a way to dynamically update a form URL for a specific student, but without knowing the design of your base, it’s tough to go beyond, “I think it’ll work.”
Aug 17, 2022 04:53 AM
Hi @Justin_Barrett . Thanks for the suggestion. I’ve created some screenshots that will hopefully help.
I have a Goal form that students fill out with their name, goal, and grade.
I’d like to use another form that will allow me to choose the name of any student that completed the Goal form and pull their goal into the new form Progress so I can add notes.
I’d like the name field on the Progress form to offer a dropdown or single select of all the names from the Goal form. After choosing a name I’d like the goal field on the Progress form to autopopulate.
Hopefully this makes more sense.
Thanks!
Aug 17, 2022 08:46 AM
Hi @Ordinarie_Heroes,
The Form view in Airtable is most often used to bringing in information to Airtable from users that do not have access to your Airtable base. Forms submissions also always create a new record.
Since you have the Goal already submitted, you may want to look into Interfaces to build you a layout that lets you view each person, their goals and add notes directly to the Goal.
Something like this:
Aug 17, 2022 09:12 AM
@Vivid-Squid this looks exactly like what I want. I’ll play around with it. Thanks you!