Regarding Arrays

Hi,

I just want to ask if glide can do this

Suppose I am making an invoice of products, user will select product from a list and then they type in the amount that they want. for example I have 3 products from my list

Products

  1. Banana
  2. Orange
  3. Apple

Then in the Amount column they put in an amount that they want

Banana | 2
Orange | 1
Apple | 2

now all the information will be in table list form, once save I want to combine those answer into 1 cell. I am able to do that if I do a template as in Banana-2 and then join list with the other products. But then if I want to edit them, I cant relation it back to the original form.

Is there a way that glide can save the item as an array in one cell (banana 1, orange 1, apple 2) then if the user want to edit, I can relate the product name and set the column value of the “amount” to the number that they input.

I’m not sure if I’m making any sense

You can try this method.