Skip to main content
Question

Require field update when record is saved

  • April 8, 2020
  • 0 replies
  • 19 views
Hello,

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 properties of the field itself.

We have a contact record and it has a "Next Contact Date" for when the customer will need a followup.  I want to set that field that it HAS to be edited/updated anytime someone adds a note and saves the record.  I don't want someone to be able to save the record without updating that Next Contact Date field.

Any help  on this is appreciated.


------------------------------
Marshall Azar
------------------------------
This topic has been closed for replies.

QuickBaseJunkie
Forum|alt.badge.img+15
Interesting problem!

You may need a combination of actions.
  1. Create another field to capture the current value of the "Next Contact Date" on save. This does not need to be visible on the form.
  2. Build an automation to populate the new field when a record is added or modified.
  3. Create a custom rule that will abort the save when the Next Contact Date is equal to the value in the new field (unless it's blank). If you're not familiar with Custom Data Rules, here's a video I made https://www.youtube.com/watch?v=X5J9e3YjA1c
Let me know if this helps 😊👍

------------------------------
Sharon Faust (QuickBaseJunkie.com)
Founder, Quick Base Junkie
https://quickbasejunkie.com
------------------------------
Terms & ConditionsAccessibility statement