TOPIC:

Customize Reservation Calendar 2 weeks 3 days ago #259837

  • sciencemkt's Avatar Topic Author
  • sciencemkt
  • Offline
  • Expert Breezer
  • Expert Breezer
  • Science applied to marketing
  • Posts: 233
  • Thanks: 0
Hello:

I am making a form for restaurant appointment booking, and I have the following doubt:

In the form created:
- Calendar (responsive)
- Select hours (from 00 to 23)
- Select minutes (from 00 to 59)

For COVID issues it is not possible to have more than 20 people in an establishment.

1. How can I set a schedule, for example from 8:00 to 14:00 and from 15:00 to 22:00?
2. How do I make reservations for a maximum of 20 people and disable the time and can be booked at other times?

Thank you.
Alejandro Cobo
Neuromarketing Company

==============================================
Blog: www.alejandrocobo.com
==============================================
Facebook: @AlejandroCobo.Neuromarketing
==============================================
Instagram: @alejandrocobo
==============================================

Please Log in or Create an account to join the conversation.

Customize Reservation Calendar 2 weeks 3 days ago #259838

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 6086
  • Karma: 3
  • Thanks: 429
Hi,

I have a question:
you want to have 20 people per day?

Regards,
Tihana

Please Log in or Create an account to join the conversation.

Customize Reservation Calendar 2 weeks 3 days ago #259839

  • sciencemkt's Avatar Topic Author
  • sciencemkt
  • Offline
  • Expert Breezer
  • Expert Breezer
  • Science applied to marketing
  • Posts: 233
  • Thanks: 0
Hi Tihana:

It would be per hour.
Alejandro Cobo
Neuromarketing Company

==============================================
Blog: www.alejandrocobo.com
==============================================
Facebook: @AlejandroCobo.Neuromarketing
==============================================
Instagram: @alejandrocobo
==============================================

Please Log in or Create an account to join the conversation.

Customize Reservation Calendar 2 weeks 3 days ago #259841

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 6086
  • Karma: 3
  • Thanks: 429
Hi,

it is a little hard to get, but I will try and get back to you

Regards,
Tihana

Please Log in or Create an account to join the conversation.

Customize Reservation Calendar 2 weeks 3 days ago #259842

  • sciencemkt's Avatar Topic Author
  • sciencemkt
  • Offline
  • Expert Breezer
  • Expert Breezer
  • Science applied to marketing
  • Posts: 233
  • Thanks: 0
Thank you very much Tihana:

I know you can get it. :)
Alejandro Cobo
Neuromarketing Company

==============================================
Blog: www.alejandrocobo.com
==============================================
Facebook: @AlejandroCobo.Neuromarketing
==============================================
Instagram: @alejandrocobo
==============================================

Please Log in or Create an account to join the conversation.

Customize Reservation Calendar 2 weeks 3 days ago #259844

  • tihana.krivic's Avatar
  • tihana.krivic
  • Offline
  • Moderator
  • Moderator
  • Posts: 6086
  • Karma: 3
  • Thanks: 429
Hi,

please try it like this:
-go to your form->Advanced->More options->Form pieces->Before form->check Custom and put this:
$user = JFactory::getUser();
$db = JFactory::getDbo();
$db->setQuery('SELECT COUNT(id) FROM #__facileforms_subrecords WHERE name = "elementname" AND value="14"');
$db->loadResult();
if($db->loadResult() > 20){
  alert('This hour is booked');
  exit;
}
Please replace elementname with name of your select list for hour (not title), and "14" with value of select list (on this way you can do it for each hours).

Hope this helps

Regards,
Tihana

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
  • 2
Time to create page: 0.048 seconds

BreezingForms Pro 1.4.7 for WordPress Released!

Available in the membership section.

September Discount!

Massive discounts on all subscriptions!

Get Your Subscription Here

Quick Links

Downloads

BreezingForms

ContentBuilder

BreezingCommerce

Templates

Documentation

BreezingForms

ContentBuilder

BreezingCommerce

Apprendre BreezingForms (French Community)

Apprendre et maîtriser BreezingForms par des tutoriels et exemples, le tout en français

breezingforms.eddy-vh.com

Questions et réponses sur les forums de l'AFUJ

AFUJ

Special Offer

Summer Sale! All subscriptions at a special price!

Includes prio support, all of our current and future Joomla!® extensions and Joomla!® templates for the duration of your membership.

Get it from here

3rd Party Discount - 25% Off

We help you to keep your costs under control. If you are a new member and purchased a form building tool from a different form vendor, then you'll get a 25% discount on our subscription plans.

How to receive the discount:

Send us a quick email to sales@crosstec.org with a proof of purchase (for example a paypal receipt), await payment instructions and enjoy your membership!