Forum Discussion

Qrew Member

4 years ago

How can I make a field editable every time a record is opened, even in view mode?

As the title says, I would like to make a text box (preferably multi line) that is editable in view mode. I can't seem to find any properties that specifically allow for this. I know it is possible...

javascript

SehunJoo

Qrew Member

Thank you for the input everyone, I had suspected some kind of javascript trickery was happening, but I wasn't sure if it was recreatable using the formula field or not.

My use case is that I would like for users to be able to submit a Approval Entry in Quickbase, but then not able to change their entries after submission outside of a few boxes that I want to host comments in. Would it better to simply lock write permissions after submission?

------------------------------
Sehun Joo
------------------------------

AustinK

Qrew Commander

4 years ago

If you want to lock it after submission on the form you could set a rule that prevents the fields from being edited once there is a valid date created, set the rule to be when Date Created is not equal to blank that it marks the fields read only. The date created is not there until the record is saved.

This would however prevent them from editing it at all after saving, even if they forgot to include the right information.

One thing to keep in mind is if the users have the ability to grid edit or import they will be able to get around any form rules you put into place. Form rules are only active on forms.