Skip to main content
Question

Mark a record in a record picker

  • March 18, 2023
  • 0 replies
  • 76 views

I have a parent table called Housing and child table called Enrollment. As part of the enrollment process, user will assign a housing unit via a record picker in Housing table. When this happens, I'd like to mark that housing unit as "booked" so I can then filter it out of record picker results. Is it possible to mark a record in a record picker or is there a better way to accomplish end result--i.e., prevent double-booking?

    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+22

    np,

    Just go to the relationship and create a summary Checkbox if there are any Enrollments, call it perhaps [Housing is Booked?].

    The create a report called "Used on Enrollments" which will have the preferred sort and columns for your drop down list of housings and filer it where [Housing is Booked?] is unchecked.

    The go to the FORM properties and set the drop down field to use that report instead of the standard Record Picker.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement