Creating multiple jobs to dispatch from a single form

[Jared_89]

Hi,
Relatively new to AppSheet and still learning. I’ll try to keep my question concise.
I’m creating a dispatch app to manage companies I subcontract work to for snow removal. I have three tables. One for subcontractors, one for Properties, and one to store jobs generated. At this point I’m able to generate jobs, add them to a route, ect.
My problem is I have dozens of sites per subcontractor, and about 20-30 subcontractors that I would have to add individual jobs for every time there is a snow event. This would potentially equal a couple hundred individual entries per event that I would have to do the night of dispatch.
Is there a way to automate the generation of the jobs, where I would basically select the company, the service they are performing, and then have jobs generated for any sites that have those services? If so what are some resources that I can use to learn how to go about achieving that?