Hi All,
New user (doing pro-bono work for a small edu business) so not too familiar with this but have read all the ‘form’, ‘pre-fill’ and ‘button’ articles here and around 60+ community topics to try to work this out.
- Teachers giving feedback/assessments on the students in their course.
- Students table, Courses table and the Assessments table linking them with all the questions etc
- Because of Airtable pricing, I need the teachers to use a Form to enter the assessments and I’m looking to automate the ‘listing of the students in their course’. So, ideally a picklist from the student names in the record cell.
I have a form where they add the Course-ID and then enter the Student Name. With 10 students in a course they have to do this same step 10 times so I’d like to prefill. I can do the course ID ok but not do the Student name (because it’s multiple names).
Q: I’m now trying to use a button to open the form prefilled but would be happy with the button opening 10 forms at the same time (all with one of the student names selected). Can this be done?
The form they see:
The Button/table (with the real linked name field and a testing field just as name strings): or https://prnt.sc/uz8ng2
My Button formula attempt:
“https://airtable.com/xxx?prefill_Course%20assessed=”&{Course Identifier}&"&prefill_Student%20Name="&ENCODE_URL_COMPONENT({Members in Course})
As I said, I can get it filled with course id and ONE student name but if there is more than one student it’s a no-go. Just looking for any ideas how to solve either with formula, field workarounds, automation or apps. Any hints appreciated.
Thank you. Frank