Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009

    Unanswered: Price calculation for a booking system


    I am new to filemaker and am making a hotel reservation system.

    So far the reservation side is working as i wanted it to. The problems comes when i want to check a guest out and automatically generate their bill...i have no idea how to do this and am hoping someone could point me in the right direction.

    I have 3 tables: Bookings (where all of the confirmed bookings end up), AvailableRooms (list of rooms) and Availability (allows searching for available rooms via date and type (dorm, single, double etc - a dropdown value list)) and entering guest name, transfers to booking)

    each type of room has a different price.

    I'm lost, please help!!

    Thanks so much,


    Oh, when i check people in i have a checkin date and a check out date. so if a room is $25 per night and someone check in on the 5/5/09 and checks out on 7/5/09 then i need to calculate the cost for that date range (2 nights)...

  2. #2
    Join Date
    Jul 2010
    Hi there,

    You can do it this way. create a room table with all the price info. When a guest checks out, you click the check out button which runs a script to subtract the check in date with current date(FileMaker date field is actually the number of date from Jan 1, 0001 so it is a number, you can simply subtract them.) and multiply by the room price in the room table. This is the amount you need to bill him/her.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts