Skip to main content
Question

Creating a Check In/Check Out App

  • July 15, 2021
  • 0 replies
  • 45 views
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 check ins and check outs, but I would like for the items table to show if the item is currently checked in or out. Anyone have a solution?

------------------------------
Justin Phan
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
np
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement