- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 29, 2024 06:18 AM
Hi!
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 29, 2024 11:33 AM
Here's what I would do:
- Create a new table called "Maintenance"
- Add a linked field on Maintenance table that links to "units"
- Create a form within "Maintenance" table where users can select each item they serviced from a drop down selection of "units" table.
- Add a "Date serviced" field to Maintenance table. Allow users to input this field in the form.
- Create a "Last Updated" column in "Units" table that only looks at the linked "Maintenance" field.
Hope this helps. If you need more support, you can schedule time w/ me.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 06, 2024 12:46 AM
The form will not work, as the input is received from an external application.
If it is not possible to create a service record for each unit as an automation, I will need to make some kind of lookup for last serviced to track it.
