0

Date Fields

If I have date fields in a table A and Date filed B.

How can I reject/stop the selection of any date in field B being before filed A? (and bonus have B jump to A when first opened)

Making data entry quicker and stopping any mistakes.

Thank you

2 replies

null
    • Jorg
    • 5 yrs ago
    • Reported - view

    Hi, 

    You could use the options "Writable if" or "Display field only, if" in the data field properties and use as condition:

     

    Field A

     

    Best, Jörg

    • Mconneen
    • 5 yrs ago
    • Reported - view

    Not sure I follow... Are the two date fields on the same table row  or are they in different TABLES?

    If the SAME table row.. you can use an after update trigger.. however, there is nothing preventing the user from leaving the second field BLANK. 

    afterUpdateFieldB

    You can put the converse in Field A.

Login to reply

Content aside

Categories

View all topics
  • 5 yrs agoLast active
  • 2Replies
  • 1365Views