Forum Discussion

TerryStack's avatar
TerryStack
Qrew Member
4 years ago

Need help to make a comment mandatory when a date is changed

Hi folks.  I need your help. I am trying to have users add a comment whenever any of the dates in a record change. Currently, the comments field is not required but if a user changes a date, I would l...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
This question has been asked before on the forum and there's actually not an easy answer to it.

But I just thought of an easy answer.

Make the user put in the comment first and then when they have a comment have a form rule to make the date fields editable.

The user will have to tab out of the comment field in order for QuickBase to see the data entry and allow the form rule to fire.

So you would have to have some instructions on the screen to tell the user if they want to edit the dates they first have to give the comment reason and tab out of the field and then the date field(s) will become editable.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • TerryStack's avatar
    TerryStack
    Qrew Member
    4 years ago
    Brilliant! Now why didn't I think of that!  Thank you Mark.  I'll give it a whirl sir.

    Terry

    ------------------------------
    Terry Stack
    ------------------------------