Forum Discussion

ReneeHansen's avatar
ReneeHansen
Qrew Member
4 years ago

LOCK A FIELD OR ENTIRE RECORD FOR BULK UPLOAD

Hi! We have some data that can't be changed once it's been deemed "completed", but we often work in bulk updates because of the amount of data that changes for each record.

Is there a way to lock fields, or records, so they can't be updated from a bulk update?

Basically,

I'm trying to lock certain fields (or sometimes the entire record) from being edited in form mode, but also from being updated during a bulk upload/update.

~Renee



------------------------------
Renee Hansen
------------------------------
Data import and export
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    4 years ago
    Records, yes. Fields, possibly, but I don't think so. Also, if you were able to set something up, and then attempted to update that record via an upload, you'll get an error. If you're doing the upload through the UI, any errors like that would be caught before anything was actually uploaded and nothing would get updated. If you're doing something with the API to upload the data, I would think that you would need to build in additional logic in that upload process to determine if something CAN be updated before attempting to update a record.

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------
    • ReneeHansen's avatar
      ReneeHansen
      Qrew Member
      4 years ago

      Hi Blake,

      how would I do this? I'm not using an API to upload the data. Just copy/paste usually.

      Thanks!



      ------------------------------
      Renee Hansen
      ------------------------------
      • BlakeHarrison's avatar
        BlakeHarrison
        Qrew Captain
        4 years ago
        So...you're Copy/Pasting into Grid Edit?

        ------------------------------
        Blake Harrison
        bharrison@datablender.io
        DataBlender - Quickbase Solution Provider
        Atlanta GA
        404.800.1702 / http://datablender.io/
        ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    There is a technique to do what you want.
    The first step will be to import your data into what I call a scratchpad.  This is a temporary staging table to hold your proposed import a date up before it gets imported into your final destination table. Then based on the relationship look up values from the real table back into your scratchpad table and based on that you will determine the eligibility of which records and maybe even which fields are to be imported.
    Then when you import data from the scratch pad into the target table you will be able to control which records get included in that import and buy formula which fields will get updated.




    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------