This is great @Robert_Petitto! Exactly what I needed! Thanks again for your tutorials!
I have a question in regards to the setup:
First, some context: we have an app that hosts multiple businesses and pages that include their hours of operation. I literally updated each individual set of hours Sun-Sat for 237 businesses - I know, shoot me!
I didn’t even think to do this - but would it be possible to use this setup, but for multiple listings?
Aka - allow said businesses to be able to input/edit their own hours of operation from a single sheet or table?
I assume I would have to create Admin access pages/toggles, user specific profiles/columns, and then throw in the kitchen sink…
Yes. User specific columns would be the EASIEST by far…but it would only work if users were ONLY looking at their own business. If you needed to have the user view the hours of MULTIPLE businesses, then you’d need a form to track the hours for each business.
Ok great! yeah they would only be looking at their own business! So on their details page, I would just create a form (that only allowed users could see, conditions) that says “Edit Hours” and it could then pull up just that data from their column(s), etc…?
I guess I could just create a toggle switch that would trigger an “Open/Closed” image or button on their details page as well…I’m just a sucker for good UX so I wanted it to look good!
Potentially. I did something similar with a different room booking app…The difference is that the meet with me doesn’t use a true time column because it’s fabricated using the choice component. However the logic is still sound because I could compare the fabricated value with a fabricated Now value. It’s worth looking into.