You need to sign in to do that
Don't have an account?
DeepV
sql table to salesforce object mapping fields
Hi Friends,
I have a table (Detail) in SQL and creating a custom object in Salesforce (Detail__c).
Below are the fields in SQL Detail Table:
WIll they be a picklist? But how can I relate Detail_Acc_no, Description, TYpe and Detail_account_class all in one picklist? How can this be structured?
TIA
I have a table (Detail) in SQL and creating a custom object in Salesforce (Detail__c).
Below are the fields in SQL Detail Table:
WIll they be a picklist? But how can I relate Detail_Acc_no, Description, TYpe and Detail_account_class all in one picklist? How can this be structured?
TIA
You may create two dependent picklist for Details_Acc_No and Description with 1 to 1 correspondance and hide Details_Acc_No from users.
You may also use single picklist for both the fields. From Spring '17 release, Picklist can be represented as Key-Value pair(Label and API Name).
Please refer
https://developer.salesforce.com/blogs/developer-relations/2017/01/keeping-picklist-integrations-safe-using-api-names.html
Hope this helps!
All Answers
If the values in the fields Description, Type and Detail_account_class are generic and repeat across rows, you should create picklists for each of them. When you are creating a record in the Detail__c object, you can chose the corresponding values from the picklists.
As for Detail_Acc_No, it can either be a auto number field or a lookup field.
Hope this answers your question.
Thanks,
Sarabdeep
You may create two dependent picklist for Details_Acc_No and Description with 1 to 1 correspondance and hide Details_Acc_No from users.
You may also use single picklist for both the fields. From Spring '17 release, Picklist can be represented as Key-Value pair(Label and API Name).
Please refer
https://developer.salesforce.com/blogs/developer-relations/2017/01/keeping-picklist-integrations-safe-using-api-names.html
Hope this helps!