Automation to re-link Linked Records in Synced Tables after splitting by comma

Are you trying to relink data from two synced tables, that were originally linked to each other in their source base?

As long as the primary fields of the tables are 100% unique and do not contain commas, quotes, or other special characters in the primary field values, you should be able to relink them by having an automation update a linked record field with the synced linked record field that becomes a text field upon syncing.

Because the two tables might have slightly different delays in syncing, you might want to introduce a delay before running the automation that relinks them in order to be sure that the records exist in both tables.

Hello @kuovonne, thanks for coming back to me. Yes, I’m trying to do that, and I was able to relink the linked record but when is only one ID and not multiple IDs separated by comma.

That’s why I asked on this other post about your services, since I could find a way to create inside an automation, a dynamic array or summary of multiple IDs after splitting a text field separated by commas.

Were you able to achieve this in the past?

Without seeing the actual data and field types, for both tables, as well as the automation configuration, it is difficult to say what is going on. I have created many different automations that link records, and there are slightly different nuances depending on field type.

I think you are trying to link records based on primary field value with commas between them. I’m not sure where the “find” action comes into play. There is also a possibility that you have a lookup field involved that seems to have commas but doesn’t really.

I did reply on the other thread how to book a meeting with me.

@kuovonne I will try to record a video or explain this better to increase the chances of support. Thanks!