- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 11, 2023 11:56 AM - edited ‎Apr 11, 2023 11:57 AM
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.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 11, 2023 12:10 PM
You can turn on "smart links" in your Make scenario to pass the primary field value instead of the record ID.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 11, 2023 12:10 PM
You can turn on "smart links" in your Make scenario to pass the primary field value instead of the record ID.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 11, 2023 02:29 PM
Yep this worked! Thanks!
