Skip to main content
Question

Configure date relationship

  • September 25, 2019
  • 0 replies
  • 14 views
Hi All,

I have table contains some of date field. There are recruitment process phase in sequence

1. Advertisement date
2. Selection date
3. Interview date
4. Contracting date
5. Contracted date

How to configure this date field for this condition, for example

If the advertisement date is 1 September 2019, the selection date must be later than advertisement date, user can not choose date 1 september 2019 and before 1 September 2019, and so on for interview date, contracting date and contracted date


Many thanks

------------------------------
Syaeful Bahri
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+5
    • JeffMickelsen
    • Quickbase Alumni
    • September 25, 2019
    The way i have done this is to make the date fields read-only so the end user cannot change the dates and then use a push button for each field to load the actual current date values in that field. You can use form rules to only enable one button at a time. 

    So for instance, you have a pushbutton that is labeled "Set Date1" and when no dates have been loaded, that is the only pushbutton enabled. When the user clicks that pushbutton, the formula invoked by the pushbutton loads the present date into the Date1 field and the form rules will then hide the "Set Date1" button and will then show the "Set Date2" button. This will make it impossible for the Date2 field to have a date earlier than the Date1 field and it makes the user interface clean. and simple.

    ------------------------------
    Jeff Mickelsen
    ------------------------------
    Terms & ConditionsAccessibility statement