Creating a Check In/Check Out App
I have 3 tables (Items, Check In/Check Out, Employees) I am having a tough time figuring out how to show if the Item in the Items table is currently Checked in or Checked Out. I have a list of chec...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp
Make a summary of the maximum Record ID# of the check in/outs. call it [Record ID# of most recent Check in / out]
Look up down to check in/outs
Make a combined text summary on the relationship of the field [Check in out status] (ie the in or out multiple choice field I presume you have. .. but filter that to where the [Record ID#] = [Record ID# of most recent Check in / out]
Then because that will look like a bubble format, make a new field called
[Status]
with a formula of
ToText(combined text Check in out status)
That's your current status!
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Make a summary of the maximum Record ID# of the check in/outs. call it [Record ID# of most recent Check in / out]
Look up down to check in/outs
Make a combined text summary on the relationship of the field [Check in out status] (ie the in or out multiple choice field I presume you have. .. but filter that to where the [Record ID#] = [Record ID# of most recent Check in / out]
Then because that will look like a bubble format, make a new field called
[Status]
with a formula of
ToText(combined text Check in out status)
That's your current status!
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------