Skip to main content
Question

Not allowing child records saved under a parent record have the same date

  • November 20, 2023
  • 0 replies
  • 30 views
Forum|alt.badge.img+8

Hello, 

I'm needing help to solution a rule/way to make sure that 2 records related to the parent record can't be saved with the same date in a date field. 

Thanks, 

LB



------------------------------
LB
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    You can create a text field with a long explanatory name like [same Parent cannot have multiple children with same dates]

    Then make a formula like

    List("-", ToText([Related Parent]), ToText([My Date Field]) and then mark it Unique.

    When the record fails to save due to duplicate date the long field name will be exposed to the user to help them understand what the problem is.  



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------

    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement