Hi guys,
I am working on building a weekly schedule for the people in the “People” database.
TL;DR - What is the most efficient way to create, edit and delete records in a one (Person) to many (Availabilities) relationship? My method (Do a search…) works, but isn’t quick or, I suspect, the best way.
My Way:
Here’s what I came up with:
The way it works:
Al the date information is pulled from a URL param stored in Unix.
An RG is populated by the [People] in the database. When you click an empty box, you can select whether that person is “Available” or “Unavailable” for that day. Times are not important.
When you select either option, a new record is created in the “Availability” database with the selected date, the person and their availability status stored.
The only way I have found to reference the entries in the “Availability” database through a person is by pushing their uniqueID to the element in the RG and then doing a search of the whole database for the entry that matches that uniqueID.
It works. But it’s slow to make actions and you have to wait for it to load or unload data. The wait is only up to a second or two, but that’s with an empty database.
Is there a better, faster or less WU heavy method? - Feel free to tell me my approach is terrible so long as you have a better idea! Though please bear in mind I have only been doing this for a few weeks, so might need guideance.