I am importing to 2 entities from a single spreadsheet
The first entity has to exist before the second is created
How do I enforce this behaviour?
To be specific there is a custom entity that has notes
I want to create a record in the custom entity and then link the notes to it
Currently the import creates the notes first - or it would but they fail as the record in the custom entity is created second
The issue was that the key linking the entities was allocated on import. In one case I was importing into 4 entities at the same time. The only way to do this was to do 2 imports. The same .csv file was used. The first import was to the entity that allocated the key. The key was then added to the spreadsheet and the imports to the other 3 entities were successful as the allocated key could now be used to link back to the parent entity.
Hope that makes sense!
As suggested above, you have to split your import and do the main records import first and then do the custom notes entity records import.
Please make sure your custom notes entity has the column with the correct lookup field display name and value for each row.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (