I am developing a project which allows to sync Salesforce data with it.
Steps: 1. User select module i.e. Leads, Contacts 2. Displaying all column from my database and salesforce in dropdown
Now what I want to do in step 2 is that sort and mirror the column so user don't misplace data.
In my leads table columns are: FullName, Designation, Contact, Mail,
Salesforce's leads table columns are: Name, Title, Mobile, Email
So when user select FullName from the dropdown then select another dropdown of salesforce column with Name and vice versa and same with others columns
So the thing is that columns remain dynamic so what would be the better approach ?