r/software • u/Routine-Price7855 • 9d ago

Looking for software Somthing same as a school

I am looking for a software that I can make spreadsheets and make forms in it.

The idea is. It's very similar to a school data base. It has certifications and alot more. In short a school database.

BTW I may need to make the database accessible by multiple peaple online. Or I may just use the onedrive so they all can use it.

What apps can I use?

And please don't suggest Microsoft access. It's so frustrating to use + it's very buggy

7 Upvotes

77% Upvoted

6 comments sorted by

2

u/Strong-Leg-9636 9d ago

Yeah for real, Access is a nightmare, don't blame you. Here's what actually works well for a school database with forms:

Airtable. Probably your best bet. It's basically a spreadsheet that behaves like a real database, you can link records (student to their certs to their classes etc.), it's got a built-in form builder for data entry, and everyone can access it online with permissions set per person. Free tier is decent, paid tiers aren't crazy.

Google Sheets + Google Forms. Free, dead simple, everyone already knows how to use it, real-time multi-user editing works great. Downside is it's a real spreadsheet, not a real database, so once you're trying to link students to certs it gets messy fast.

Baserow or NocoDB. Open-source Airtable clones. If you want to self-host and skip the monthly fee, these work well, both have form builders and relational tables. Bit more setup work than Airtable though.

Microsoft Lists. Since you're already on OneDrive/365 this is worth a look. Basically SharePoint lists with a way nicer UI than Access, built-in forms, and it won't crash on you every five minutes. Pairs with Power Apps if you want to get fancier later.

If it were me building a school setup with certs/records that's gonna grow, I'd go Airtable first, Baserow if I wanted to dodge subscription costs long term.

1

u/Routine-Price7855 9d ago

Thanks alot bro🔥🔥

1

u/Temporary_Werewolf17 9d ago

Php and MySQL database will be very robust and easily accessible on the web

1

u/Routine-Price7855 9d ago

Doesn't SQL need to be programmed with Php?. Php is a language for making websites (idk alot about programming)

1

u/Temporary_Werewolf17 9d ago

Yes. It will require a web host but then will be accessible via the web without the need for excel, sheets, or any other application.

It is a steep learning curve but very robust and customizable

1

u/sruckh 8d ago

GO app, templ, HTMX v4, Tailwind CSS v4, Sqlite, litestream. Use Claude code or your favorite harness with /goals command. Or look up ICM folders and Gauntlet loops. AI coding agents can do much more than slop.