I have a tool that scrapes data into an excel database. the data is sent to a live feed via a webhook and the data is also aggregated into a dashboard, where we analyze the data and visualize certain metrics. Currently, we have one dashboard and we manually run it as a total aggregate on the compl…

Absolutely doable with Glide. The only thing that I can think of that might be a challenge for you is the number of data rows. Glide currently has a soft limit of 25k rows. You can exceed this (it’s currently not enforced), but as you do the performance of your app will suffer. This is because Glid…

Awesome, Yeah, I imagine that we would be okay archiving after 25k rows without effecting the use. is there a way to automate this inside glide? Also, would it be 25k limit for the main data base, or would users data be included? for example, is the global data base has 20k data points, and the us…

[image] Amur: Awesome, Yeah, I imagine that we would be okay archiving after 25k rows without effecting the use. is there a way to automate this inside glide? Glide has an API that you can use to add/remove/change data, but if you’ll be using Excel as a backend then I’d imagine you’d be able …

[image] Darren_Murphy: Also, try and resist the urge to do lots of calculations in your backend spreadsheets. Glide has a very rich set of computed column types and plugins , including an Excel plugin column that supports all your favourite Excel formulas. Doing all your calculations in Glide mak…

[image] Amur: question on this bit though, what is the delay time for sync between client and backend. our data is near real time, and its important we keep it that way as best as possible. I’m not sure about Excel, but when you’re using Google Sheets as a backend the delay can be anywhere be…

okay, got it. well, in our specific situation, the user would not be giving any data to the system. all of our data is provided in the back end from our tool, and then analyzed. in this instance, would it still be beneficial to do the calculations in glide, since the data would not need to travel…

If you’re already aggregating/analysing/summarising data in the back end, then you probably won’t want to change that - and I don’t think it would make sense to do so. I’d say just keep my comments in the back of your mind. Any time you need to collect input from a user and “do something” with it, …

Is it possible?

Ask for Help

Darren_Murphy June 3, 2022, 2:20pm 7

oh, and here is my personal list of things I wish I knew when I first started out with Glide…

Topic		Replies	Views
How scalable is Glide Ask for Help	42	12407	January 12, 2024
Are there any other sites like Glideapp? Ask for Help	49	1774	February 5, 2021
🙏🙏>25K rows in GT, or external database. So needed! Feature Requests	38	1671	May 15, 2024
Manage Data in Glide Table Ask for Help	12	529	August 18, 2022
CRAZY USECASE: Overloading app in a level that created hours delay in writing to Sheet Ask for Help	53	1826	January 17, 2024

Is it possible?

Related topics