Forum Discussion

SehunJoo's avatar
SehunJoo
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's avatar
SehunJoo
Qrew Member
4 years ago
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
------------------------------
ChristopherWhe1's avatar
ChristopherWhe1
Qrew Member
4 years ago
How are users "submitting" their Approval Entry?  Is it a Record Creation, or do you have a URL Button that marks a checkbox or kicks off a Pipeline? Something else?

------------------------------
Chris Wheatley
------------------------------
  • SehunJoo's avatar
    SehunJoo
    Qrew Member
    4 years ago

    Users submit their approvals through an input form that adds a record, so Record Creation yes.


    In my case, the biggest reason why I've locked the record editing is because I would like for users to press a specific button that will allow editing + delete all former received approved notices for that approval request.



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

    • BlakeHarrison's avatar
      BlakeHarrison
      Qrew Captain
      4 years ago
      Ok, I admit, I'm getting a bit confused. Can you outline the structure of your tables/relationships involved in this approval process and answer the following:
      1. Where are you wanting to put this Update button
      2. What records do you want it to Edit/Add/Delete
      3. What is your user's process (step-by-step)
      I think if we can get a clearer picture of the situation, we should be able to point you in a good direction.

      ------------------------------
      Blake Harrison
      bharrison@datablender.io
      DataBlender - Quickbase Solution Provider
      Atlanta GA
      404.800.1702 / http://datablender.io/
      ------------------------------