So I have a csv file which needs to update Accounts on Salesforce.
Here's my question I have 138 different phone/product types(in the csv file) and each Account in the csv has more than one phone/product types with quantities(column). So how can I create a picklist in the salesforce if I had to select more than one types and provide the quantities ?
If I use multi picklist I will be able to select more than one product type but how will I specify its respective quantities ?
Example: Account1 has Type -Phone1 and Phone2 and quatity - for phone1 -3; for phone2 - 4