My nonprofit uses Salesforce to record donor information and participation in various programs we offer. I'm having a problem related to two custom objects: Participation (records participation/enrollment in our programs) and Attendance (for each program day, records whether or not a person attended). For example, we have an after-school program that runs once a week for 30 weeks. Every girl in the program will have one Participation record showing she's enrolled and up to 30 attendance records, each linked via lookup to her Participation record.

My problem is creating multiple Attendance records without importing them from excel, which I certainly can do but would like to avoid if possible. It would be ideal if users could select the appropriate Participation records from a list and click a button that would automatically create and save one Attendance record for each selected Participation record and link to that Participant record via lookup. 

How possible do you think this is? And any ideas on how to make it happen?

Nonprofits generally don't have the funds to pay someone with the right experience for this job, and mine is no exception. I don't have any background in this but am learning as I go. I'd really appreciate any input. Thanks.

My nonprofit uses Salesforce to record donor information and participation in various programs we offer. I'm having a problem related to two custom objects: Participation (records participation/enrollment in our programs) and Attendance (for each program day, records whether or not a person attended). For example, we have an after-school program that runs once a week for 30 weeks. Every girl in the program will have one Participation record showing she's enrolled and up to 30 attendance records, each linked via lookup to her Participation record.

My problem is creating multiple Attendance records without importing them from excel, which I certainly can do but would like to avoid if possible. It would be ideal if users could select the appropriate Participation records from a list and click a button that would automatically create and save one Attendance record for each selected Participation record and link to that Participant record via lookup. 

How possible do you think this is? And any ideas on how to make it happen?

Nonprofits generally don't have the funds to pay someone with the right experience for this job, and mine is no exception. I don't have any background in this but am learning as I go. I'd really appreciate any input. Thanks.