Form rule to populate a date field
I am creating a new form UI and am now to the form rules. I have a rule that basically says " if [field] is not blank, change date to today". However, the date field is not even an option in the list...
Forum Discussion
Just curious (ruling out the simple first), is the date field actually on your form? I have found that the field has to be on the form for it to show up in the form rules.
------------------------------
Jamie Low
------------------------------
Yes, that appears to be the case with the new UI form. However, it was not required to be on the form with the current form. This creates an issue of putting additional fields on the form that are only for reporting purposes. I guess I can create a 'hidden' section on the form so I can add those fields, but this should not be necessary.
------------------------------
Amy Gosz
------------------------------Hi, to test for NULLS you can use the formula section of the new UI rules definition to test about anything - as long as it TESTS to a Boolean result. You can then have a RULE trigger when the result of your test is TRUE. (e.g. test for NULL or UNSET fields). It's ugly I know. But a work around.
That's how I got it to work. Another trick I did was just add a dummy field to the table, don't put it on a form, keep it unset and then test against it in your rules. (Again, ugly, but it works. )https://community.quickbase.com/discussion/new-forms-rules-test-for-null-or-unset-dates
------------------------------
joe vandervest
------------------------------I just created an admin page and hide it from all other users. Probably the easiest way to do this, but not sure why the new UI requires the field on the form when the current one does not.
------------------------------
Amy Gosz
------------------------------
