I read relevant posts to my problem below, but have not had these methods work
Problem:
I want a lookup/query/relationship/formula (I don’t know what the preferred method is) to extract Array column values in ‘table 1’ cell and create ‘table 2’ rows.
Table 1 Array column snip:
Context here - Each row is a receipt. Each receipt is unique and identifiable to a user & rowID
Table 2 Desired outcome (SUPPORT NEEDED):
Create a row for every array item. For example ‘Unie Sauce Chili’ should be a row & ‘Green Lentils’ should be a row, and so on. Once all items are in a separate row then the next receipt will begin filling rows. all items will be related back to a receipt in table 1 and the rowID.
Let me know how I can kickstart this process, cheers!
Does it have to be a JSON query for this to work though? Going back a further step, how was the original JSON created? This eventually will lead you to a situation where you have to use the Glide API/Call API action to add mutliple rows, so I have to make sure I understand how it’s created in the first place.
I have a glide maker subscription and do not have access to the glide API being used. I cannot rationalize getting an upgrade just for API access. is there an alternative method, or integration to externally do this?
