Activity scheduler

[CestM0i]

I’ll start by saying this is possibly the wrong forum as it’s not strictly educational, but I’ve always found the members here incredibly helpful (please point me in the right direction if there is a forum better suited to my query)

 

Simply put we would like to have a self filtering form that spits out a table (a pretty one but that’s a minor point)

 

I’ve had a search of the web and to be honest I don’t know what keywords I need to find what I would like.

 

I have moved from education to work at an activity centre and we have a number of activities that we run that are appropriate for different age ranges and different group sizes. We would like a teacher to be able to arrive at a web page, input an age range and number of students attending an activity day, have that filter out activities inappropriate to the age range and allow a teacher to then choose; 4 activities from a list (if there are a low number of students) or 6 activities (if there are a larger number of students. Using this information we would like to spit out a timetable for the day.

 

I can think of ways to do this using branching logic in ms forms and using power automate to fill a table (but I don’t think they’d be particularly front of house pretty)

 

Are there other solutions that people are aware of? Anything goes. Wordpress plug-ins, power apps, purchasing from a company that has already built it, commissioning someone to build it in html 5 or even coming back to a way of making forms do the job but make it pretty. (I suspect a fresh build might be out of budget but I’m open to listening)

 

The caveat would be that a capable IT person would need to be able to edit the lists behind the scenes for updating later.

 

I look forward to hearing peoples ideas (or telling me where I should be asking instead 😉)

[Rooty]

You could probably achieve a lot of this using something as simple as Google Sheets or even Microsoft Excel.

 

If it needs to be a web page, ignoring where it'll be hosted and so on, you could achieve this with just some HTML and some fairly simple javascript realistically. If you're comfortable with tech then you could learn how to do this yourself, otherwise you'd need to find/hire someone to do it - it's not a huge job assuming all the requirements are in your post.

 

Something like WordPress is a firehose to put out a match, and you'll end up fudging complicated plugins together that just about get what you want - and then they'll break next update.

 

It sounds simple-ish as it is, it depends on the logic required in structuring a timetable, the format it 'spits out', how you're hosting/accessing it, and so on.

 

Any questions feel free to message me!

[CestM0i]

Thanks for the pointers. We have an excel spreadsheet that is used behind the scenes to do most of the job so the logic exists.

 

I know a little html (mainly basic tables and formatting), so it sounds like I need to start finding my way around JavaScript to create the logic to use input fields and filter the data in to a couple of tables.

 

I’ll drop you a quick PM

[Al_Balone]

How complex does the generated timetable need to be? Sounds like you may need a few back end scripts and some form of rudimentary database. In terms of creating a nice front end form, for ease of use I would check out bootstrap, as it'll minimise the amount of CSS you'll have to use.