I need to set a column value indicating if a lead was added during data import from Excel. I would like to avoid creating a column in the Excel file to do do. Is it possible?
Like
2 comments
20:32 Feb 07, 2020
Hello Ricardo,
There is no need to add columns in the application or in Excel file since if the record was created or modified via data import it gets unique tag that contains "Data import" part + date when this import was performed. In case CreatedOn of the record equals to ModifiedOn of the record and there is import tag on this record it means that the record was created using import from Excel. But if CreatedOn not equal to ModifiedOn and the record has import tag it means that the record was modified using data import.
Best regards,
Oscar
Show all comments