Aug 07, 2022 05:11 PM
Hello, I have been trying to figure this out for days now with no luck! Any help would be greatly appreciated!
I am trying to use an automation to find several records that all have the same name. I want to take those records after they have been found and copy them over to another table. To be clear if the automation finds 4 records, then I want 4 records to be copied and I do not want them to be in the new table as 1 record with 4 in the linked record column. I have successfully found the records using an automation, but how would I copy those found records over to a new table.
Any help would be greatly appreciated! Thanks in advance!
Aug 07, 2022 06:30 PM
Yes, that makes sense. Either Make.com or the workaround method above would work for this.
Aug 10, 2022 01:19 PM
@kuovonne How would you clear the backlink field with an automation? Is there a formula that you input in your automation? Any help would be greatly appreciated! Thanks!
Aug 10, 2022 02:19 PM
Use an update record action for the linked record field and leave the field value blank. When you clear the link from one side, it also removes the backlink from the other side.
Aug 10, 2022 03:10 PM
@kuovonne That worked great thank you! My only concern is that when the automation deletes the field, it reruns the second automation because it is watching for the field to be updated which it is when it is deleting. In other words, where I should only create 4 fields, it is actually creating 8 in total. Do you know how to solve this problem? Thanks!
Aug 10, 2022 03:25 PM
You are using the wrong trigger. Do not use the “when record updated” trigger. Use the “when record matches conditions” trigger.
Aug 10, 2022 03:47 PM
Perfect! Worked like a charm! Thanks!
Aug 16, 2022 09:37 AM
Perfect thanks so much!