Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Create record in table B and link to multiple imported records in table A on import

55 0
cancel
Showing results for 
Search instead for 
Did you mean: 
jwag
6 - Interface Innovator
6 - Interface Innovator

Hi guys,

We'd like to be able to import a list of around 30 items (BoM) at a time to a Cost Estimates table, create a single record in a Cost Centres table and link all the items in the BoM import to this Cost Centres record. The name of the Cost Centre record won't be known on import, so can't be specified in the importing csv. Each import should create a new Cost Centres record.

I have tried playing around with automations but hit the issue of automations running in parallel and creating several Cost Centre records before the BoM records find them and start linking to them.

I'm sure this can be done with a script but I'm hoping there's a way I can avoid that. If not, I'm happy to pursue that avenue and am open to some advice on how best to implement that.

Thanks in advance for any suggestions!

Josh

10 Replies 10
jwag
6 - Interface Innovator
6 - Interface Innovator

That is a very creative solution - thank you very much Alexey!

There is definitely a possibility that multiple imports will happen within 15 minutes, but I will play around with additional conditions to see if this problem can be resolved.

Thank you for your detailed response.