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
- Banana
- Orange
- 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