Skip to main content
Question

LOCK A FIELD OR ENTIRE RECORD FOR BULK UPLOAD

  • July 30, 2021
  • 0 replies
  • 60 views

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
------------------------------
This topic has been closed for replies.

  • BlakeHarrison
  • Quickbase Alumni
  • July 30, 2021
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/
------------------------------
MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • July 30, 2021
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement