sirmatter

The only problem is that I want the user to be able to see all of the rooms, even if they are booked. There was an Airplane Seating File that was provided to me in the past. It did exactly what I want but I could not figure out how to implement it. It showed all the seats and had a graphic for seats that were booked and seats that were empty. It was based on a repeated field and I could not understand how it worked. I can still create a script to show which rooms are booked and which rooms are available but I would still need a visual way to determine which rooms meet the criteria. I guess I could still use the portal I am using but I would have to have separate buttons to add these items to the portal. Does this make sense? I am not very advanced in filemaker design.

Hi Gismo, I already have the double booking system working perfectly with all 50+ rooms. I am envisioning some type of button or repeated field system where a person can see what rooms are available and then click on a room to book it. That would seem to be the easiest way to add more than one room. You would have to click 50 times but that makes the most sense due to the volume of rooms available. Also, The example above would not work for what I am doing. These are very specific selections that must be made depending on what a customer wants. We need to manually enter these requests as the facility has rooms spreading over 500 acres and many of the buildings are separated by quite a lot of distance. I could have special buttons to select blocks of rooms at a time but these would have to be preset options that would then have to be manually edited if there was a conflict. P.s. we use to use just a standard check box set and value list. We would then compare each room for each booking timeframe. This took hours of extra work but was the only way we could set it up at the time.

I have a working database that uses a Double Booking system provided by the FMForums commenters (attached). My problem is that I need a way to quickly select multiple rooms and apply them to 1 conference. My goal is to use a one click method on either a button or field to add the room to the list. I also need a visual way to determine if a room is booked or not. I have already experimented with conditional formatting and buttons but this seems to not be the best way to make this work. It would also be nice if the item clicked to assign and the conditional formatting were one item. I already have the system functional using this example but I cannot seem to figure out a way to quickly and effectively add rooms. Some groups use up to 50 rooms at a time. If you have any ideas, please let me know. DoubleBooking.fmp12

If anyone has any ideas, please let me know. I am still working through this issue. Thank you.

Hi EOS, I figured out part of the problem. I am using a Cartesian related TO to show all of the available records. This (I believe) is why it is not working. As you requested, this is what I am attempting to do... I have 100 rooms that can be booked. I am attempting to Conditionally format fields for rooms that are booked for the current date. I want to be able to see all of the rooms in the portal and easily see which rooms are booked and which are available. I will then have a script attached to book the room for the current customer if it is available. I was using the If(ArrivalDate = Get(CurrentDate) & MatchID = Self, 1, 0) to begin my calculation but it didn't work correctly, so I stopped. I will eventually want to add more to the calculation but I wanted to get a basic one working first to verify it can be done.

Eos, What I was trying to do is make sure that the Match Id from the related record matched the portal row. It didn't work the way I though.

Sorry for the late response. When I have applied the above calculations, I either get one portal row to change or the whole portal set. I can not get the portal rows with the correct date to highlight on their own. I will continue to see if I can come up with a solution. Thanks.

Thanks Eos, I'll give it a try. Is still don't understand why it will not work on multiple portal rows. It is only working on one with the current calc. Could syntax cause this problem?

Hi Fitch, I am using an If statement. The date field is a plain stored field. I am note at my computer, but I will try to remember the exact format of the calc. If(Date = Get(CurrentDate) & MatchID = Self, 1, 0)

Hi Everyone, I am having an issue with conditional formatting on a portal. Currently, I am attempting to have portal text change color when a record exists on a specific date in a related table. My problem is that it is only working for one portal row and not for the others. I have observed that it is only changing the portal row that is the "first" record created in the related table. As soon as I delete this record, the formatting is "bumped" to the next record that was created. Any ideas how I could have the entire portal format correctly? Thank you!

It worked like a charm. Thank you EOS and Comment. You guys Rock!

Hi Everyone, This is the continuation from another fantastic answer from you all. This is similar to another post I did but a little different. http://fmforums.com/forums/topic/95686-room-double-booking/#comment-438428 I have set up my Rooms using the instructions from Comment and La Retta. This has worked great except for one problem. I need to incorporate time into the mix. I have tried a variety of ways to do this and have not been able to get it to work. I have a StartTime and EndTime field in my bookings database. When I add ArrivalTime and DepartureTime fields to the relationship between Bookings and the TO ConflictBookings, it only functions some of the time. It will show a double booking sometimes but not others. I am sure I am missing something. Bookings BookingConflict Booking ID Not Equal Booking ID Room ID = Room ID StartDate >= EndDate EndDate <= StartDate ArrivalTime <= DepartureTime DepartureTime >= ArrivalTime Any help is much appreciated!

For people to reference later. This post seemed to help me understand TO (table occurrence) a little better. http://forums.filemaker.com/posts/3d8b364a6c Thank you everyone for the help. I learned a ton!

Thanks EOS, I think that I understand this but let me write it out for clarification. Tables: Organization - Organization_Contacts - Contacts Which is a one to many relationship AND Organization - Primary Contact (Second occurrence of Contacts) Which is a one to one relationship I would then need a PrimaryContactID field in Organization table which relates to the ContactID in Primary Contact Table (Second occurrence of Contacts). Does my Primary Contact Table need a separate ID or can I use the same ID that already exists in Contacts? Thank you for the help!

EOS, Are you saying that there should be a second occurrence of my contacts table to assign the main contact? I just want to make sure I am understanding this correctly. Also, If I do create a second occurrence of the contacts table, would this allow me to change it without corrupting the relationship?