Creating Multiple Records (tasks) from Form Submission
We have a community event where we offer services. Customers come to our booth to purchase the service. The event is about a week-long so when they come to see us they typically purchase more than one service. I'm new to Creator but my current set up is:
- Attendance List
- List of attendees, contact info and site location of where they're located on the grounds (we obtain this form the organizers)
- Service Request
- Lookup field showing "First Last - Site"
- 8 Checkboxes, one for each service day.
- Formula Field - Calculating price based on number of checkboxes selected (pricing/payment functionality needs more thought but this is where it's at for the time being.
- Multi-Select list for status
- Not Done (default)
- Done
When saving the form a single record is created for the report. It does not matter if one service day is requested on multiple. If multiple, then the columns in the report for those days simply say "True". There is also a single Status field for that single line of record.
This all makes sense of how it's behaving but what I would like it to do is create a separate record for each day that is checked off during the Service Request form submission. By doing so, each service request, even if multiple are ordered in a single form entry, will have it's own status. How can I achieve this?
How would I go about doing this?