Require field update when record is saved
Can someone PLEASE help me out with this as I cannot figure it out. I'm trying to force a field to require an update when the record is saved and I cant figure out if I need a rule or to change the...
Forum Discussion
The "note" field is just a blank field for contact notes. The main issue is the "Next Contact Date" field which is a calandar date field. Even if it stays the same, I want to make the form require that the field is clicked before the record can be saved.
Purpose is to prevent customer contacts from going over SLA and forcing agents to HAVE to double check and edit the Next Contact date field if needed.
Sorry if this doesn't answer your question fully.
------------------------------
Marshall Azar
------------------------------
Purpose is to prevent customer contacts from going over SLA and forcing agents to HAVE to double check and edit the Next Contact date field if needed.
Sorry if this doesn't answer your question fully.
------------------------------
Marshall Azar
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendHere is one approach.
Create a text field called [Previous Note] by copying the Note field. (that will populate it with the current value in [Note].
Create a checkbox field called [Date OK].
Create a date field called [Previous Next Contact Date] by copying the [Next Contact date] field. ((that will populate it with the current value in [Next Contact Date]
Make a form rule that says when the record is saved
Change the value of [Previous Note] to the value in the field [Note]
Change the value of [Date OK] to unchecked.
Make another form rule that says when
The record is saved
all of
[Note] is not equal to the value in the field [Previous Note]
[Date OK] is unchecked
[Next Contact date] is not equal to the value in the field [Previous next contact date]
Abort the save and display message Please update or confirm he the Next Contact Date
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Create a text field called [Previous Note] by copying the Note field. (that will populate it with the current value in [Note].
Create a checkbox field called [Date OK].
Create a date field called [Previous Next Contact Date] by copying the [Next Contact date] field. ((that will populate it with the current value in [Next Contact Date]
Make a form rule that says when the record is saved
Change the value of [Previous Note] to the value in the field [Note]
Change the value of [Date OK] to unchecked.
Make another form rule that says when
The record is saved
all of
[Note] is not equal to the value in the field [Previous Note]
[Date OK] is unchecked
[Next Contact date] is not equal to the value in the field [Previous next contact date]
Abort the save and display message Please update or confirm he the Next Contact Date
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------