Does anyone know if the Unique ID can be configured when creating a synced table to Salesforce (with the AirTable ‘out-of-the-box’ connector)?
The table Primary Field can be set, which I presumed should be the unique field within the Salesforce report for future syncs. However, when I select to set the primary field to be a custom column from the Salesforce report (which should be unique), then run the sync, I get an error that there are duplicate Opportunity values (which is not the field I set as the Primary field in sync configuration settings, and is not the unique column in the SFDC report).
Curious if anyone else has hit this issue?