An Airtable workshop materials signup can collect each attendee’s preferred kit before an event, then give staff a reviewed picking list. Use a miniExtensions Form for requests, linked records for the approved options and separate quantities for requested, confirmed and issued materials.

Fictional Harbor Makers runs a Saturday printmaking workshop. Attendees choose either a paper kit or a fabric kit. The organizer needs to prepare supplies without treating every submitted preference as guaranteed stock. This workflow begins after registration: it coordinates materials, not event admission, payments or seat allocation.

Model a choice as a specific request

Create Workshops with Workshop name as primary text, Session date as date/time, Location as text and Materials coordinator as text. Create Material options with Option name as primary text, Workshop as a link, Description as long text, Unit as single select and Available for requests as checkbox. Use descriptive options such as “Saturday printmaking: paper kit” rather than “Option A.”

In Materials requests, use Request reference as autonumber, Submitted at as created time, Attendee name as text, Contact email as email, Registration reference as text, Material option as a single-record link, Requested quantity as number and Request note as long text. Add staff-only Confirmed quantity and Issued quantity as numbers, Review state as single select and Staff note as long text.

For the simple version, one submission requests one option. A participant needing two distinct supplies submits two requests with the same registration reference. This preserves quantity per option without implying a single multi-select field can hold a different quantity for every selection. Staff can later group the requests after verifying their registration.

Offer only the relevant materials

Create a miniExtensions Form for Materials requests. Show the attendee, registration reference, option, requested quantity and optional note. Keep confirmed quantities, issued quantities and staff review decisions outside the attendee inputs.

For a session-specific form, configure the Material option field’s Filter Records with static conditions matching the Saturday workshop and Available for requests. The linked-record filtering guide explains that the default Record Finder mode filters the selection list. Do not describe this as stock reservation or as a rule that retroactively removes existing selections.

Keep attendees from adding or editing the Material options catalog through the linked field. Review its child-form creation and expansion controls separately from the main form’s creation settings, following the creation and editing documentation. The public experience should offer approved choices, not a path to invent a new kit.

Match requests to registered attendees

Send the materials form with the event’s ordinary preparation information. Explain the deadline and describe a submitted quantity as a request pending staff review. A registration reference helps reconciliation but is not proof that the person submitting it owns that registration.

The coordinator compares each request with the actual registration record, checking the workshop, name and contact details. A mistyped reference remains Needs review rather than being silently matched to another attendee. Where an attendee submits twice, staff determines whether the second submission is a correction or an additional request before counting both.

For example, Jamie first requests one paper kit and later requests one fabric kit. The coordinator confirms the change, marks the original request Superseded and counts only the reviewed fabric request. Preserve both rows and the explanation so someone preparing supplies does not accidentally pack both kits.

Turn reviewed demand into a picking list

Staff reviews available supplies using the organization’s actual stock process. Set Confirmed quantity only after that check. If six fabric kits were requested but only four can be allocated, record four confirmed kits on the relevant reviewed requests and communicate alternatives to the remaining attendees.

Prepare a staff view grouped by Material option, showing attendee, registration reference and Confirmed quantity. Use the confirmed quantities for packing, not the raw number of submissions. For kits assembled from several components, maintain a separate staff checklist identifying the contents of one kit; multiply or count those requirements deliberately during preparation.

This design does not reserve inventory atomically, prevent simultaneous oversubscription or decrement a warehouse balance. A filtered option and a quantity field do not provide those guarantees. If multiple organizers allocate the same stock, agree which system and person controls allocation before offering confirmations.

Keep the event-day handoff visible

On the day, a staff member checks the reviewed attendee list and records Issued quantity after physically handing over materials. A confirmed kit is not necessarily an issued kit. Keep unexpected shortages or substitutions in Staff note and distinguish an agreed replacement from what the attendee originally requested.

If Jamie cannot attend, follow the event’s policy for unused materials instead of automatically reassigning the kit. If another participant collects on Jamie’s behalf, record the arrangement in the staff process. Do not put attendee details into a public picker or imply the materials form establishes collection authority.

The broader event registration and check-in guide covers the separate attendance workflow. Linking the two processes can help staff reconcile names, but receiving a materials request alone should never create an admitted attendee or a paid registration.

Test choices, corrections and shortages

Use fictional sessions with different material catalogs. Confirm that the Saturday form offers only Saturday’s enabled options and provides no catalog-creation route. Submit a valid request, a duplicate, an unknown registration reference and a quantity above what staff can fulfill.

Check the records in Airtable, then walk through confirmation and issue manually. Verify that the picking list excludes superseded requests and uses confirmed rather than requested quantities. Change an option’s availability and inspect how existing requests remain represented; do not assume the finder filter rewrites old relationships.

These are preparation checks to perform, not observed results. The workflow fits workshops where a coordinator can review preferences and organize supplies. Its practical outcome is a traceable materials handoff: what someone wanted, what staff agreed to provide and what was actually issued.