Jump to content
Rich

Schema setup - where to go from here?

Recommended Posts

(I apologize if this isn't the correct forum for this, so feel free to move it to the proper one, please.)

I'm stuck. I built a solution with a parent-child portal setup, the user can see the four, court reservations for the day (Current Setup attachment). However, she'd like to be able to see a "big picture" view as depicted in the Capture 5 attachment.

I figure a popover or a jump to another layout is in order, but beyond that I don't know how to pull this off schema-wise, especially when it comes to filling out a range of time slots shown in Capture 5, e.g., Court 1 would have the time slots 8:00 and 8:30 populated with Practice (Emilio Lizard), blank spaces from 9:00 am to 10:00 am, then from 10:00 am to 1:00 pm each half-hour time slot would have Practice (Emilio Lizardo)...and the rest of the time slots after 1:00 pm would be blank because there aren't any reservations for that court number.

I thought of using four, repeating fields (one for each court) of 32 "slots" each that would span the 32 half-hour time slots from 6:00 am to 9:30 pm, but dealing with repeating fields with scripting to loop through each reservation to populate the appropriate slots...that's so ancient FileMaker Pro and it would be convoluted as all get out. (Note: since we're still using v.17, I can't get creative using the new scripting commands in v.18)

If I could have some direction which way to go, I'd greatly appreciate it!

Current Setup.png

Capture5.PNG

Share this post


Link to post
Share on other sites

One possible solution is to keep a Slots table with 128 permanent records (32 half-hours * 4 courts). related to the Reservations table and populated via the relationship.

Another option is to look for an existing Javascript library and build the display in a web viewer.

Share this post


Link to post
Share on other sites
Quote

 

 

Thanks for the suggestions!

Cheers,

Rich

Share this post


Link to post
Share on other sites

Feel free to check out my OPEN SOURCE version of Appointment 1.0v9.  FULLY UNLOCKED and CUSTOMIZABLE Resource Calendar module.

http://appointment10.com

Good Luck!

  • Like 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.