Forum Discussion

SehunJoo's avatar
SehunJoo
Qrew Member
4 years ago

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

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
------------------------------

4 Replies

  • AustinK's avatar
    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.
  • 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/
        ------------------------------