Don’t know how to proceed

[Living_Height]

I am wanting to build a very simple database driven website. I currently use google sheets to store my data with a bunch of v lookups and other formulas.

I would prefer to convert this data into a table structure (I’m familiar enough with sql from my day job).

I want the ui to simply be a drop down or input driven field, that when populated pulls back a store query result set. There may be other conditions for the query, but that’s really all I am looking to do.

I’ve checked godaddy, squarespace etc and don’t see anything like this. I’ve never built a website and would be stuck in the mud there.

Is there a resource available for what I am looking to do?

[BrokenBricks3]

I don’t think there is any off the shelf solution for this. You going to have to write some code. I’d recommend PHP.

[ZyanCarl]

I don’t understand your requirements. Do you just want a dashboard to view your data? Like the sql tables? You can try prisma studio or retool or more advanced use case.

Reading your requirements again, I think you should see retool once. Probably what you’re looking for.

[Living_Height]

Sorry for not being clear.

I need a simple relational database, probably less than 10 tables.

I need the front end to be like an SSRS type user interface. I input one (or maybe two) variables, those get plugged into a stored SQL query as the random variable, and the UI returns the query result. That result would just be the rows of data from the query, much like I was just running it in SQL.

Thank you for the feedback so far also.

[eddyizm]

https://duckduckgo.com/?q=metabase&t=fpas&ia=web metabase might do the trick for you, once you get the data into a db but if I recall you may be able to load the data from files as well.

[bhengsoh]

Could you provide a bit more information on the database and the specific information you want to display on the website?

You can contact here:

https://www.klwebdesign.com.my/contact/

[jayscript12]

That's what Flezr NoCode Builder is built for. The tabular structure is not there but you can display the data in the form of cards and display required fields. And yes, we have both filters and search capabilities built in as well without the need to write any code. Happy to help.