Write an array column (via Lookup) to Google sheet

Report a Bug
13

Mark, the problem we have been facing is a very simple one. We are not able to transfer multiple items created using a multiple relation to a new sheet via a lookup. Below is an example:

Menu Sheet

Customer X selects following items from sheet “Menu”:

Item 1 (on row 1)
Item 2 (on row 2)
Item 3 (on row 3)

Orders Sheet

All 3 items get passed to sheet “Order” in the following order:

Customer X (fetched into sheet “Order” either using Lookup or Column) Item 1 (on row 1)
Customer X (fetched into sheet “Order” either using Lookup or Column)Item 2 (on row 2)
Customer X (fetched into sheet “Order” either using Lookup or Column)Item 3 (on row 3)

Sheet “Confirmation”

This is where it all begins to get complicated. Let me take you through the process item by item:

The normal process/workarounds

  1. When X confirms order, the Confirmation sheet is created but with only 1 item (not all 3, and we will come to why?). If that is so, then how was I able to show all items on the “Confirmation” sheet (without using scripts). This was just a trick many before me used and we all still sometimes over use. We are able to perform this trick by pulling the “Orders” sheet as an inline list, displaying only the items ordered by tying the items to X. All good and well! So what’s the problem>?
    The Problem

  2. The problem: If we set the “Confirmation” sheet to edit in- app, and we have to to save rows, what gets deleted is not what’s on the Confirmation" sheet but "what’s on the Orders sheet. When this happens, all we are left with is the Qty and total price, email of X etc. Poor chef does not anymore know what he needs to prepare!

Solutions:

A. Google scripts - my opposition to scripts is not a personal one but a common sense one. We are past the age of google scripts. Our competitors are growing by the day, if not hour, making all sorts of wild claims. Give us the tools mentioned in B below, and we will take the competition to the so called competitors.

B. Glide script: currently, you can paste any single row to any row on any sheet you like via a lookup, provided a single relation has been created between the shits in question Give us the ability to do lookup of multiple items by row/column, whether created by single or multiple relations. This would give us the ability to pass all 3 items (in our example) to the Confirmation sheet.

Thank you

1 Like