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.
