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
3.how 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:
- Users
- Products
- Categories
- 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?
3 Likes
Good to know!
I want to display it in my app.how 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.
Hi
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.
Hi
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,
A B C D
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