Help

Convert a Comma Array into Linked Records

Solved
Jump to Solution
927 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Gospel_Musician
4 - Data Explorer
4 - Data Explorer

I have customers purchase information. in Make.com I'm able to store all of the customer's purchase information into a Long Text Field that looks like such:

37466774995108, 37466777616548, 43650268266737, 37466778697892, 37466778632356, 43650344222961, 43650236907761, 37466778173604

All of these values are linked to another record that has the Product information. How do I convert the numbers into Linked records. I can do this manually, but I want to automate this. I know you may be asking, but I have over 122 different products, so I would rather not manually add them. Also I'm using Make.com, and the only way to automate this is to upload as a comma array. 

So I need some sort of formula to convert a comma array into a linked field.

Link Record Example.gif

 

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

You can turn on "smart links" in your Make scenario to pass the primary field value instead of the record ID.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

You can turn on "smart links" in your Make scenario to pass the primary field value instead of the record ID.

Gospel_Musician
4 - Data Explorer
4 - Data Explorer

Yep this worked! Thanks!