Hello everyone,
Always with the ultimate goal of creating the perfect automated ToDo List,
I have a script I was able to write that copies tasks from one table, pastes them into another table. The script copies the important information (task name, task categories, who's responsible and when it needs to be done). My script then links the task to the event in the ToDo Lists.
But it's impossible to copy the dependencies between my tasks (link to another record) directly into the script. In any case, I was unable to do so and no one replied to my previous post. I got around the problem by asking the script to copy the dependency links from my main table into a text column in my ToDo Lists table.
So I created a second automation to "Update record" the new records created by my script, to copy the text from the text column to the parent Task column, which is a link column to other records.
As I said, I have about ten child tasks linked to its parent task (13 parent tasks) and I guess that's what's causing the issue?
My script copies the 110 tasks perfectly, but the record update creates 35 new unwanted records. How can I solve the problem?
I've already tried using created time or last modified fields, as shown here, to delay my automation.
I've also tried limiting the update record to one view only.
But in any case, I've got 35 new records appearing ...
I don't know what's causing the problem or how to get around it. I'm open to any help or comments!
Best regards
PS :
I've tried as trigger for the 2nd automation :
When a record is created
When a record enters a specific view
When a record has a filled checkbox (Then checkbox + specific view)
When a record matches certain conditions
And each time I had 35 unwanted records created in my update record automation.