Discussions

Expand all | Collapse all

Creating a Check In/Check Out App

  • 1.  Creating a Check In/Check Out App

    Posted 20 days ago
    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
    ------------------------------


  • 2.  RE: Creating a Check In/Check Out App

    Posted 20 days ago
    Edited by Mark Shnier (YQC) 20 days ago
    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
    ------------------------------