jbi Posted March 12, 2008 Share Posted March 12, 2008 For the life of me I can not figure out how to set-up an auto-calculation to have a Repeating Field [6] auto fill based on the results of a portal. I have an appointment setting "Month View" of a calendar. Each day has 6 time slots available for an appointment. Based on a daily portal relationship of booked appointment slots (the portal would only show a maximum of 6 records since there are only 6 appt slots per day), I would like to somehow calculate which appointment slots are taken and insert a boolean "1" in the specific Repeating Field [#]. Then using conditional formatting on the Repeating Field and placing it on each Day square of the Calendar Month View, it will show at a glance if there are any available time slots for that day. Link to comment Share on other sites More sharing options...
AHunter3 Posted March 13, 2008 Share Posted March 13, 2008 You're saying you want to use a calculation to determine WHICH of several repetitions in some other repeating field should be looked up (or otherwise reflected/copied/displayed) in a specified repetition HERE? Well, that's not going to happen without major major headaches. Repeaters expect that whenever you reference any other repeating field, you want repetition 4 of that other field to apply to repetition 4 of this field, and so on. Just say no to repeating fields. They're a horrible nuisance. Link to comment Share on other sites More sharing options...
jbi Posted March 13, 2008 Author Share Posted March 13, 2008 I am certainly realizing that. I think I'm going to give up and attempt to use portals the only problem is that if I have 6 appointment slots per day times 7 days a week that's 42 Relationships I have to create inorder to show whether each slot per day is either filled or not. I just don't know how many relationships is too many when building a database. My Relationship graph is already very busy! Link to comment Share on other sites More sharing options...
AHunter3 Posted March 13, 2008 Share Posted March 13, 2008 if I have 6 appointment slots per day times 7 days a week that's 42 Relationships I have to create inorder to show whether each slot per day is either filled or not Oh, no, not at all. You may need only one relationship. Possibly two or three (one showing all appointments, one showing appointments on a specified day via a global Date field, and one showing filtered appointments e.g., only tomorrow's appts or only appts in the 4 PM slot or only annual checkup appointments, etc). Not 42 most likely. Heck, you could do all of what I just described with a single relationship and a single portal! You may have 42 related records that you view through that portal but each individual portal row, being a record unto itself, has a time and a date. You can have the time field be a dropdown field whereby one picks from one of six possible time slots. And if you use the filtered portal to see only appts on a given day, you can quickly tell whether you've already set one up for 3 PM on that date. PS: While a concern on your part to keep your relationship graph simple is a very GOOD thing, rest assured that FileMaker would not have problems with 42 relationships... Link to comment Share on other sites More sharing options...
jbi Posted March 13, 2008 Author Share Posted March 13, 2008 Thank You AHunter3 for your advice. I was able to get what I needed using portals, I'm happy to see that my relationships where not out of control. Here is a view of what the relationship graph looks like and the final Month View. Nothing is polished yet, I've just been getting things to work and then I'll my it clean and tidy. Thanks Again. PS I previewed the post. Not sure why the pdf's are not working. I'm not sure how you posted your pictures? Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts