Configure date relationship

Question

Hi All,I have table contains some of date field. There are recruitment process phase in sequence1. Advertisement date2. Selection date3. Interview date4. Contracting date5. Contracted dateHow to configure this date field for this condition, for exampleIf 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 dateMany thanks------------------------------Syaeful Bahri------------------------------

jeffmickelsen · Answer

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.&nbsp;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------------------------------

syaefulbahri3 · Answer

Hi Jeff,Thank you for your response.Can you please give me a reference for this push button and form rules?. I think I will need a lot of this push button and form rules thingsMany thanks------------------------------Syaeful Bahri------------------------------

jeffmickelsen · Answer

This is how I do it.&nbsp; Create a Formula-URL field (It is easier than using a Formula-Rich Text field) using the following as a template for how to fill it out.

Change your field Label to your choice.Change the Formula where it says "_fid_87" to the field id for your correct field.&nbsp;

The numeric part of the field id ("87" in this case) can be determined from the details on your field list.&nbsp; You may have to enable click on Advanced Options and then click Field ID if you want to see it in the field list.
You can also see the Field ID by on the usage tab for the field (Show Field Properties and then click on the Usage tab).

Change the Link Text to whatever you want it to say.You can also change the color of the button, but if you are going to have a group of buttons, make sure all are set to the same color by setting the RGB numeric values.You can then place this field on your form where ever you want to show it.There are two Sample Apps on QuickBase that are worth their weight in gold especially for the beginner.&nbsp; They are Magic Buttons v2 and URL Formula Buttons for Dummies v1.As far as Form Rules, they are explained quite well in the QuickBase Help under the topic Create Dynamic Form Rules.&nbsp; If you have a specific question, please provide an example of your form rule and what is wrong.------------------------------Jeff Mickelsen------------------------------

syaefulbahri3 · Answer

Hi Jeff,Thank you for your direction, I'll get back again for any question.------------------------------Syaeful Bahri------------------------------

Forum Discussion

Configure date relationship

Related Content

Configuring Your New Account

Qrew Tip: When One Relationship Isn't Enough

How to configure global app search

Many to Many Relationships

Cross App Relationships