Write an array column (via Lookup) to Google sheet

Report a Bug
5

Hi again @Jeff_Hager

Here I put a GIF to show you what I try to get (I know you hate GIFs but a set it to almost slow motion :smiley:)
The steps are (sorry for Ping Pong effect that sometimes appears, it is like a plague) :

  1. You choose the restaurant (Firenze)

  2. See its menu to select dishes

  3. Check mark the dish and quantity to ask for and with every clic on dish name, its quantity +1 (if you want to change quantity due to error, just uncheck the dish and start over)

  4. While you are selecting dishes and their quantities, the APP shows the total order amount in a green box at bottom

  5. You can see your list of dishes and quantities in the Inline list I put bellow as well (horizontal orientation)

    array-gif

Up to here, everything is normal but using Data Editor you can see:

  1. The Restaurant name colum
  2. The selected Quantity column
  3. The Dish name column
  4. A Template column to join Qty+DishName (TP_CantyPlatoPedido)
  5. The famous Lookup column where I put all dishes selected by user but using only my Template column indicated aboved. Here I have my dynamic list (3 products of 10 possible) ready to send the order and write to GS but, Glide doesn’t allow use a lookup column if this looks like an array with multiple values. It doesn´t make sense!

My Lookup column is an array unidimensional (LK_ListaPlatosPedidos) and could be written to any cell in my GS without problem. With regard to the format and delimiters, I understand the problem but I can live with a simple list separated by a comma, slash or whatever that Glide wants to use (I can configure my Template to separate/split items).

If I copy the Lookup column value from Data Editor manually and past it into a cell, I get a wonderful result as my picture shows…(no spaces, no empty data, etc… only the info/values found by my lookup as a list). It’s what I want!.

image

If you have a plan C to get it I will appreciate it although I think that a little modification inside Glide could fix it forever.

Thanks again for your help and time

Te cuidas, seguimos mañana! :slightly_smiling_face:

1 Like