Forum Discussion

MarshallAzar's avatar
MarshallAzar
Qrew Trainee
6 years ago

Require field update when record is saved

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 rec...
Custom Data Rules
roles and permissions
QuickBaseJunkie's avatar
QuickBaseJunkie
Icon for Qrew Legend rankQrew Legend
6 years ago
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
------------------------------