I have this code:
Guest_Planning_Worksheet__c gpw = new Guest_Planning_Worksheet__c(); update gpw;
When running it as the guest user profile, which assigned to our Site code, it fails on the update with 'INSUFFICIENT_ACCESS_ON_CROSS_REFERENCE_ENTITY'.
The update fails, I obviously don't have Update access on the table. Looking around, I don't see a way to give the user profile UPDATE on the table.
What is the right way to approach this?
My Guest_Planning_Worksheet__c has lookup fields of type 'Opportunity', 'Account', and 'Event'.
I have looked in the Guest Planning Worksheet profile, and while there is no object wide permission for Update or Delete available, I have 'Edit' on for all the fields that are editable. (I have some formulas)