Meaning that every time you will add a field you'll have to create new permission sets ?
Lol, after some time you would have dozens of PS, it would be hard to maintain, and messy :D
You can deliver a permission set for your managed package users ( or several, if you have different type of users), then everytime you add a new field, you can add rights to it ...
we would like to authorize changes, but show a confirmation pop-up if the change is done from the standard record page
What I can't figure out is how to ask for confirmation & get the callback to update ?
You can't inject code into the standard record page to run on save. You would need to override the entire record edit action ...
@vamsi-krishna is right.
You need to add Replacement_Part__c =true for your Product2
//create test objects
Product2 testEquipment1 = new Product2(Name='Test Equipment 1',
Product2 testEquipment2 = new Product2(Name='Test ...
This is not a direct answer to the question but an attempt to provide the context and resources required to arrive at an answer.
You should read the following documents in their entirety:
Best Practices for Deployments with Large Data Volumes.
Big Objects Implementation Guide
Using Batch Apex.
The questions you're asking here are not directly answerable ...