Forum Discussion
CarolMcconnell
6 years agoQrew Captain
I only want it to show up with a date field changes from null to not null. Maybe I can put it a hidden checkbox.
------------------------------
cowannbell cowannbell
------------------------------
------------------------------
cowannbell cowannbell
------------------------------
AustinK
6 years agoQrew Commander
So once it goes from blank to having data you want it to forever display a message on the form for that record? Or for only a certain amount of time?
- CarolMcconnell6 years agoQrew CaptainForever. It's a reminder to do something else.
------------------------------
cowannbell cowannbell
------------------------------- DonLarson6 years agoQrew EliteC,
So you have a Date field and need to know the Date of the Date.
Add another field called [Date DTS].
The program an Automation that will fill that field when [Date] goes from Null to filled.
You now use the [Date DTS] for your reporting on the change in the field [Date]
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------- CarolMcconnell6 years agoQrew CaptainThey only way I see that you get the option of when a field changes display a message is if you use when the record is saved.
What I have done right now is to save when Term date is not equal to Null, show message. However that is not the best way to do it. It seems that Quickbase only gives you the on change option if you use the on save option.
------------------------------
cowannbell cowannbell
------------------------------
- AustinK6 years agoQrew CommanderI see what Don is going for and he is right that you will end up with more reporting options by doing it that way. This is a good way to do it so you can have better reporting later on and see things like "15 records had their date changed in July of 2020". If you don't care about being able to see how many records had the date filled in X month or whatever, you can do it simpler.
Create a rich text field that has big red text or whatever attention drawing thing you want and have that show up when the date field is no longer blank via form rules. If you need help setting that up in the form rules I can give more guidance on that. That is one way to do it.- CarolMcconnell6 years agoQrew CaptainI don't care about capturing or reporting on anything. I just want the reminder. The red text won't help in my case because I have tabs and the field that needs to be checked is on another tab.
------------------------------
Carol McConnell
------------------------------