ADD from another table using Glide Tables?

Ask for Help
1

Hi! I am pretty new to glide, so this might be very basic (or impossible).

Basically I have an “Orders” table and a "Products in Order table"

Inside the Orders table I have a related column populated with the corresponding products from the Products in Order table

So far, so good.

In the Orders table I have a Total column which I am supposed to fill with the SUM of the prices of the products for the corresponding order (remember the products come from the Products in Order table)

I need this in order to tell the Checkout Button how much the order will be.

I understand this would be “simple” with google sheets, but can’t find a way to do it with Glide Tables.

Any suggestions will be appreciated!
Thanks a lot! Hope I was clear enough.
Happy easter!

2

You can do it like this:

  • Create a multi-relation from your Orders table to your Products in Orders table, that joins by Order Number (assuming you have that)
  • Now you can use a Rollup column that gets the sum of all products for each order via that multi-relation
3

Thanks a lot! Will try this out!

4

Thanks! your solution worked! but… the Buy Button won’t take rollup fields as “Price”

Do you know of any way I can convert that into something that the Buy Button would like?

Thanks again for all your help!

5

Sorry, I’ve never never used the buy button, so I’m not sure.
But you could try converting it to a math column (multiply by 1) - that might work.

6

Price can only take Sheet columns as input, as far as I aware, due to security issues.

7

Thanks @Darren_Murphy , @ThinhDinh for your time!

@ThinhDinh ouch, I really needed to use dynamic pricing. I will see if I can find some workaround in the flow.

Thanks again, have a great week!

1 Like