Forums

Sign Up Sheet

sw2211 03 Nov, 2024

I am looking for recommendations if this extension is able to create sign up sheets for a client.

They need the ability to have multiple volunteers for a single task/job/assignment for specific times across the course of a day. Bonus points if it supports multi-day events.

An example of an event might look like this:

8 AM - 9 AM Set Up 6 volunteers needed.

9 AM - 11 AM Kitchen Help 4 volunteers needed.

9 AM - 11 AM Servers 6 volunteers needed.

11 AM to 1 PM Kitchen Help 4 volunteers needed.

11 AM to 1 PM Servers 6 volunteers needed.

1 PM to 2 PM Clean Up 4 volunteers needed.

Thanks,

Steven

Max_admin 03 Nov, 2024

You can build a sign up form, but you will need a way to track the number of bookings under each time slot, this will need a custom database table to store the count of bookings for each slot

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
sw2211 04 Nov, 2024

Thanks for the quick reply. 

Is there a tutorial that you recommend for getting up to speed on this sort of project?

Steve

Max_admin 04 Nov, 2024
Answer

unfortunately no, but if you are familiar with Chronoforms8 then this is how you can do it:

First, to be clear, you need a form to sign up users for time slots, with limited availability, users will choose a time slot from a dropdown, and full timeslots will be removed.

  1. Build your form
  2. your time slots dropdown will use "Dynamic options", where it will read the slots options from a db table you will build
  3. The db table will have 3 columns, slot_id, slot_title, slot_empty_seats
  4. You will need to setup the "Read data" conditions which will feed the Dynamic dropdown to read all records from that db table, and the condition is slot_empty_seats > 0
  5. In the last page of your form, in the submit area, you need to use a "save data" to decrement the slot_empty_seats of the selected time slot

if you need help building the form for a fee then we can help

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
You need to login to be able to post a reply.