Trying to figure out the best way to overcome the limitations of the Page Designer and hoping a formula might be the answer.
I’m collecting a lot of data in a table called “Rooms”. Each room record has linked products, materials, and concepts, and then I use a bunch of lookups to retrieve the information I’m hoping to display on my Page Designer. The problem is how the Lookup field combines my information. Here is my Product Name Lookup field for one room as an example:
Aqua 2 Complete Shower Rail, Lapiana Towel Bar, Lapiana Towel Ring, Lapiana Robe Hook, Lapiana Paper Holder, Square Tubular Pull Handles for Back to Back Mounting, Square Trim for 1/2" Valve, Caso Single Hole Faucet
It obviously collects the information in a list, but that’s not what I want. I would like to be able to hand arrange each name in my page design so that each text string can be under their respective images. For that, each name has to be in its own field.
Is there a formula that would separate my lookup field again and “break it out” into pieces that I could then arrange freely?
Not opposed to the idea of having 10+ formula fields called “Product name 1” “Product name 2” etc. I can see some potential in separating out the text by somehow using the commas as markers for stopping and beginning points, but I’m just not sure on how to put it together.
Maybe the array functions are useful here…?
Anyone willing to help?