cancel
Showing results for 
Search instead for 
Did you mean: 

Import trying to write to a formula field

lcmonroe
Enthusiast

I downloaded the latest version of DT - 5.46.1.0 - and am now having problems with an import that I haven't had before.  I have a field in my spreadsheet called "Company" and I use it to match on the Contact, Lead & Account Object.  On the Contact object it matches against a formula field of Account Name (which comes from the Account Object).  One of my final match criteria if there is no match on email, first name, last name, is to match on Account name, city and state against the Account object.  If there is a match it should create the new contact under that account.  I'm getting an error message where it's trying to write my "Company" field on my spreadsheet to the Account_Name__c formula field which is read only and therefore, the new contact doesn't get created.  This is the actual error message: 

INVALID_FIELD_FOR_INSERT_UPDATE:Unable to create/update fields: Account_Name__c. Please check the security settings of this field and verify that it is read/write for your profile or permission set.:Account_Name__c --

This only started happening after I upgraded.  I've created a support ticket, but thought I would ask here also in case anyone else has experienced this.

Thanks!

1 REPLY 1

Pugs_Validity
Validity Team Member
Validity Team Member

Hey @lcmonroe - Interesting to hear this started happening with the most recent version. Thank you for opening a support ticket, that is the best route for these sort of errors if they occur. I'll be sure to follow along and provide any additional assistance I may be able to offer after their investigation.