I am working in a board which populates per Shopify order, using a Zap from Zapier. All the information I need from Shopify is successfully getting into my board, and it’s populating the board one order per item line. When there are multiple line items, though, they populate in the following format:
Ultimately, I need to split these line items into separate values so that I can create invoices and track values individually. I feel as though this probably should be done via subitems, but I’m open to other solutions. This feels like an issue that would be encountered in any integration with a NoSQL data set, so I’m surprised there isn’t an existing solution. Is there an easy way to break these into individual components without adding dozens of columns with formulas that break it up using “mid” or “search” functions?