how to set status of bed not available. and how to set status of bed available if person leaves that bed?
I prefer boolean values of 1/0 or 1/null. Much can easily be done with boolean values with calculations. Great for like hide or conditionals, etc. If you use Yes/No, or Full/Empty, then you can't so easily do boolean conditionals or hides. Also good for counting just by doing a sum.
An often-overlooked option is to store the 0/1, but set the layout object to display as desired. Including Emoji.
Just my $0.02 worth.
sir how can i set the emojy on the result of two records to show that is available or not.
my situation is in pic
Please explain what it is that you are trying to do in much more detail. Why would you need two records to show whether or not a bed is free?
dear i want to show true or false on the base of previous fields. my condition is in pic below
i want which rooms are free and which are full. and when a person leaves how to set them again free.
Rather than show a check or X in that box, use a graphic and use FileMaker's Hide/Show conditions to show either the check or the X.
Putting those characters in a field doesn't serve any purpose. As you say, you want to show the character. You don't need to store it, so an icon is a great user interface display of the data.
dear sir i want automatically set status free or not free. more detail is in pic
It can be done automatically. What is your logic? When would the status be set to 'free'?
Repeating the same picture over and over does not improve your explanation. It shows two fields, not records and as Jeremy has pointed out, you have not explained what logic controls whether or not a bed should be shown as "available".
please help me.
Hi. i'm glad to help. What is your logic? When would a room be free? When bed = 0?
basically i am designing a filevfor a hostel. in which they can watch which rooms are availabe/free and which are not.
dear sir i did not use any boolen logic behind it.
basically i am working on hostel database file in which i want show which rooms are free for use and which are not free.
as you know in a hotel's room there are two or three beds may accommodate. and when a person leaves that bed of that room i want to show that bed's status free. that's what i want to do and trying for last 4 days. but not successfull
The attached is how you could start.
Something has to trigger the be status of the bed. I simply added radio buttons to do that.
Study this file carefully. I put the beds in a separate table and related them through the primary key of the room. (the ID field)
and how to set them to free again if it bed is released. thank you very much for your help.
I have a Hotel Reservations solution with a 'room grid' showing availability of rooms based on relationships (image attached). This works great if there is only a few rooms, as in small hotels and hostels. When the entity has a lot of rooms (hundreds or even thousands), the unstored calcs in the 700+ relationships show a performance hit. You can view a free demo of my solution here: www.compu-reservations.com
I have another model that uses a 'posting' script system to 'set' the availability of rooms/beds, and it's quite complicated. You have to attach scripts to capture every possible way a user may touch a room/bed reservation - adding, editing and deleting. It has to be 100% fool proof to work.
I also work with a 3rd party to show availability online as well. My solution will 'post' to the online calendar the availability, and download reservations taken from the end-users website. See more about that here: Online Reservations | Compu-Reservations.com
Hope that helps!
thanks to make my life easy for a bit.
Retrieving data ...