Getting number of users and products ordered

How to get these values and display it in text.

1.Total number of users logged in
2.How many product ordered based on the orders with each product many products ordered based on the order with category

It’s all about how you set up your data tables.

I imagine you have at least 4 sheets:

  1. Users
  2. Products
  3. Categories
  4. Orders (that include a product ID and category ID of some sort)

Create a multiple relation from the product table to the product ID in the orders sheet, then a Rollup of that relation to get a count of products ordered.

Do the exact same process in the categories table to get the count of products ordered of that category.

As for your first request (number of users logged in) not sure if that’s achievable in Glide (but would be nice to know!)

Not sure if Google Analytics helps here?


It does.


Good to know!

I want to display it in my to display total number of users?

Unless you have some sort of integration outside of Glide that regularly updates your spreadsheet with Google Analytics numbers, I don’t think there’s a way to do this. I know that google sheets does have A Google Analytics add-on that could possibly update your spreadsheet regularly with current numbers, but it wouldn’t be a live sync…it would be an update on an interval.

I will try it.


Now what I did,

Created a relation column
Rollup that relation column getting the count values
in orders table.

Then in category table,I created lookup column to get values from orders table,and created rollup column ,it’s summed up correctly but it’s display same value for all the categories.

Values to be different based on how many times it’s been ordered in order table.


I don’t have any id in product table as well as category table.i only having row id.

I change my mind n just need only categorytype wise bought orders need to be count and display in inline list like,

100 orders bought

I have 4 category type

For example,


5 times 3 times 2 times. 5 times

Problem solved .

In my app, I have a control table with 1 record where I store all kinds of common stuff for the app. Then I have a relation between that table and the users table so I can “lookup” stuff and have the data available as computed columns. I just added a ‘rollup’ to the control table from the users table and it gave me the count. As you can see, this app is just getting started – all I have are beta users at the moment…

1 Like