Dynamic Form Rules Message on Change
I wanted to see what is the easiest way to have a dynamic rule that shows a message when a field is updated/changed. I don't see a basic native way unless I'm missing something. ----------------...
Forum Discussion
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
------------------------------
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?
- Forever. It's a reminder to do something else.
------------------------------
cowannbell cowannbell
------------------------------- C,
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
------------------------------- They 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
------------------------------
- I 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.- I 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
------------------------------
