Help

Automations with CSV import running all at once vs in sequence

Topic Labels: Automations
746 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Anthony_Cassel
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi, I am currently using CSV import to fill out a table1. In this table1, a groups of records will have duplicate field values(Item#). Then in Table2 I have a single record for each group of matching Item#'s that are all linked.

My automation wont trigger until at least 3 of the fields are filled(in case of manual entry) on Table1. Then it looks to see if Item# exists on Table2. If not, it creates a record. If so, it fills out the linked record field in Table1 to link it to the existing record in table 2.

image

If I input the records to Table1 one at a time it works without an issue. When I use CSV import or do a bunch at once, it doesn’t register that there is a record in Table2 and creates a bunch of duplicates in Table2. I can look to see that it creates a record and that its still in progress for another record but still creates a duplicate anyways.

I can provide more screenshots or info if it helps!

1 Reply 1

Hi Anthony, if I were to hazard a guess I would say this is down to a timing issue of when the automation’s running, so you could try fixing this by delaying the automation’s trigger somehow, either by a script action where you just make it wait, or some kind of formula field with a “Created Time + 2 minutes” or something

However, before you go down those roads, I was wondering if we could try something else

If you’re just trying to make sure that the records are linked properly, you could try:

  1. In Table 2, make your primary field the “Item#” value
  2. In your automation, have a single Update Record step, where it updates the record in Table 1 and pastes the “Item#” value into the linked field to Table 2

I think this should do what you’re looking for: Create a record in Table 2 for that “Item#” value if it doesn’t exist, and link it together if it does