Is it possible?

[Darren_Murphy]

@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 to automate it there? (I’m not an Excel user, so don’t ask me for specifics )

@Amur

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 user selects 10k of them, would that ultimately result in 30k data rows? or how would that work?

Any row that is referenced anywhere in your app is counted. And no, it’s not per user. 20k rows is 20k rows, whether you have one user or one million users.

@Amur

Do you have any recommendations on where to start with, ie. understanding the multi user interface and customization?

A few pointers off the top of my head:

• You’ll want to familiarise yourself with User Specific Columns. These are very important when it comes to personalising the user experience. Creating things like custom dynamic filters, charts, tables, etc all require the use of USC’s.
• On the topic of charts, if you expect to be doing a lot of charting I’d highly recommend quickchart.io. Although Glide has a native chart component, it’s quite basic and you’ll very quickly find yourself bumping into its limits. Also check out this thread for some inspiration.
• 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 makes your apps perform much better, as everything is done client side and you eliminate any delays waiting for data to sync between the client and the back end.
• This community is awesome, and a great resource. Check out the #tutorials section, and pay particular attention to anything from @Robert_Petitto or @Darren_Alderman (not me, a different Darren). Both of those guys also have their own Youtube channels, with a bunch of Glide related tips and tutorial videos.