I have the tables "units" "location," and "event." Events have a lookup field to location, and a location has multiple units. What I want to acheive is to create an automation so that when a record is created in event, a new event for evry unit in that location.
I started, but seem to be stuck on
To give an example: Units are lightbulbs, locations are buildings and events are service missions. A user can change one or all lightbulbs in a location via a form as part of a service misson. If the user changes all lightbulbs in a location I want to create a new record for each of the lightbulbs in that location. The point is that it's important to track when the lightbulb last had maintenance.