Abgleich von Werten mit maximal wert

Hallo

ich möchte ein Werkstatt Tool erstellen zum Buchen. Euer Kalender lässt nur maximale Termine zu, ich würde aber gerne sowas machen.

wir haben mehrere Tarife mit hinterlegten Arbeitswerten:

Wartung Fahrrad 10 AW

Wartung E-bike 12 AW

wartung Lastenrad 15 AW

Platten 5 AW

und noch mehr, aber soviel erstmal grob. Ich würde gerne folgendes mache. Pro Tag geben wir Gesamt 40 AW frei. Wie sich die 40 aw zusammensetzen ist egal, aber es sollen nicht mehr sein. Der Kunde wählt erst was er will und wenn noch die Anzahl an AWs frei ist, nur dann wird der Tag auf der nächsten Seite im Kalender als frei angegeben.

geht das? Ist im Grunde wie eure Termin Anzahl, nur halt mit der Rückversicherung, dass genug AWs frei sind.

danke Gruß Bernd

PS: ich hab das Formular schon erstellt, wenn ihr es euch ansehen wollt

Hi Bernd,

Thanks for reaching out to Jotform Support. I'd like to let you know that I am using a translation tool to provide assistance, but if you prefer to receive help in your native language, we can forward this ticket to our German Support Team. However, keep in mind that it could take longer to receive a reply from them. 

With that being said, I'm not exactly sure if I understood correctly what you would like to do after translating your response, but do you simply want to create an item with stock/inventory management? If so, then you may find the following widgets very helpful.

• Inventory Widget.
• Gift Registry Widget.
• Quantity Gift Registry Widget.

If that's not exactly what you're trying to do, let us know and provide more details.

Hi Lorenz
Thanks for the quick reply.
Well it’s more like that. We have a bike workshop and we have 10 Labor values per hour. We want to offer a booking form with Jotform where the customer can pick a workshop product like service ebike or service cargo bike or just a flat tire. They all have different Labor values (ie 10 ebike, 15 cargo, flat tire 5). We want the customer to book the right plan on their own to save time - therefore we offer 40 Labor values a day for the booking system and that’s where I struggle. We would have to declare 40 values for the day and each time someone books a product, it should decrease this 40 values by the amount booked by one of the products. And if not enough values are left the calendar on the next page doesn’t offer that day anymore.
Hope that was explained ok :)
Thanks
Bernd
……………………………………………
OO ERFAHRE Hamburg
Jetzt eBike buchen:
buchen.erfahre.com
Jetzt Werkstatt Termin buchen:
werkstatt.erfahre.com
ERFAHRE Hamburg
Eine Marke der EVOLTE GmbH
Vorsetzen 50
20459 Hamburg
T 040 300 34 666
E info@erfahre.com
I www.erfahre.com
Geschäftsführer
Bernd Repenning
Amtsgericht Hamburg
HRB 124964
Am 11. Nov. 2023, 10:56 +0100 schrieb Jotform <noreply>:
</noreply>...

Hi Repenning_Bernd,

Thanks for reaching out to Jotform Support. To implement a booking form with a limited number of labor values per day on Jotform, you can use conditions and calculation fields. Here's a step-by-step guide on how you can set this up:

1. Create a Dropdown Field:

• Start by adding a drop-down field to your form to allow customers to choose the type of service. For example, you can name it "Service Type" and include options like "Service Ebike," "Service Cargo Bike," and "Flat Tire."

2. Create a Calculation Field:

• Add a calculation field to your form. This field will be used to calculate the labor values based on the selected service type. For example, you can name it "Labor Calculation."

3. Set Calculation Values:

• In the calculation field, set up conditions to assign the correct labor value based on the selected service type. Use the "Update/Calculate Field" condition in the settings. For example:
• If "Service Type" is equal to "Service Ebike," set "Labor Calculation" to 10.
• If "Service Type" is equal to "Service Cargo Bike," set "Labor Calculation" to 15.
• If "Service Type" is equal to "Flat Tire," set "Labor Calculation" to 5.

4. Create a Booking Date Field:

• Add a date field to your form to allow customers to select the desired booking date.

5. Set Daily Labor Limit:

• Create a hidden field to represent the daily limit of labor values (e.g., "Daily Labor Limit"). Set the initial value to 40 (or the desired limit).

6. Update Daily Labor Limit:

• Set up conditions to update the "Daily Labor Limit" field based on the "Labor Calculation" field. For example:
• If "Labor Calculation" is greater than 0, subtract "Labor Calculation" from "Daily Labor Limit."

7. Set Up Calendar Conditions:

• Use the "Enable/Require Field" condition to show or hide the calendar field based on the "Daily Labor Limit." If "Daily Labor Limit" is greater than 0, show the calendar. If not, hide the calendar or display a message indicating that no more bookings are available.

8. Test Your Form:

• Test the form to ensure that the labor values are calculated correctly and the calendar behaves according to the daily limit.

By following these steps, you can create a booking form with dynamic labor values and a daily limit. Customers will be able to choose the service type, and the available dates will depend on the remaining labor values for the day. If the daily limit is reached, the calendar can be disabled or hidden to prevent further bookings for that day.

Give it a try, and let us know if you need any help.

Hi guys
You are great, thanks!
I’m struggling with point 2 a bit. Do I need an extra calculation field or do I add the values to one of my existing fields like „flat tire“.
I guess I need one variable (you call it Labour calculation) which I can then tell how much values (40) is the maximum. But how do I set it up?
Thanks
Bernd
……………………………………………
OO ERFAHRE Hamburg
Jetzt eBike buchen:
buchen.erfahre.com
Jetzt Werkstatt Termin buchen:
werkstatt.erfahre.com
ERFAHRE Hamburg
Eine Marke der EVOLTE GmbH
Vorsetzen 50
20459 Hamburg
T 040 300 34 666
E info@erfahre.com
I www.erfahre.com
Geschäftsführer
Bernd Repenning
Amtsgericht Hamburg
HRB 124964
Am 11. Nov. 2023, 14:28 +0100 schrieb Jotform <noreply>:
</noreply>...

Hi Repenning_Bernd,

Thanks for reaching out to Jotform Support. Aside from Conditional Logic, you can also pick the Form Calculation widget to help you. Let me walk you through doing that:

1. Under the Build tab, in the upper-left, click  Add Form Element

2 . In the left pane, select Widgets at the top.

3. Find and click Form Calculation.

4. To make your formula, use the Add Field button and the virtual number keypad in the settings pane on the right.

Note: Click on the item's wand icon to see its settings.

5. In the bottom right area, click Save when you're done.

Take note:

• You can change the value types of items in the formula by clicking on them. The [0–9] and [A–Z] at the end of each item show you which value type it is.
• In the panel settings, click the ellipsis button to see a list of math functions and other options.
• These are the choices you have:
• You can add fields to a solution as either text or a string.
• Read-only should be set on the result field.
• Make the decimal places empty.
• Leave out the secret fields.
• In place of the decimal point, use commas.
• You can change how many decimal places are shown in numbers.

Reach out again if you have any other questions.

Well ok - but I‘m still confused.
I really don’t get it 😂
I set it up like this:
The dropdown with 3 test services (5,10 and 15 Labor values).And a date picker on the next step - pictures attached.
But I don’t get how I calculate it now that the date picker only show the dates where the selected service is still available.
Sorry for all the questions! If this works out, I’ll be the happiest customer ever 😉 was looking for a decent booking system for many years now and this seems to be just perfect because we can change the input fields as we need them.
Thanks
Bernd
……………………………………………
OO ERFAHRE Hamburg
Jetzt eBike buchen:
buchen.erfahre.com
Jetzt Werkstatt Termin buchen:
werkstatt.erfahre.com
ERFAHRE Hamburg
Eine Marke der EVOLTE GmbH
Vorsetzen 50
20459 Hamburg
T 040 300 34 666
E info@erfahre.com
I www.erfahre.com
Geschäftsführer
Bernd Repenning
Amtsgericht Hamburg
HRB 124964
Am 12. Nov. 2023, 11:41 +0100 schrieb Jotform <noreply>:
</noreply>...

Hi Repenning_Bernd,

Thanks for getting back to us. I'm sorry for the confusion. Unfortunately, we do not currently have the ability to dynamically adjust Appointment field availability based on the service selected. However, a workaround would be to add multiple Appointment fields corresponding to the available services and utilize Show/Hide field conditional logic to display the relevant one based on the selected service. Let me walk you through it:

To begin, add three Appointment fields that correspond to the services you provide. Configure the availability settings for each field based on the associated service, and rename each Appointment field to reflect the related service. Make sure to hide those fields as well. You can learn more about how to schedule an appointment using an appointment field by viewing this blog post.

Now, set up a Show/Hide field condition to display the specific appointment based on the services chosen. Here’s how to do it:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
2. Click on Conditions on the left of the page.
3. Now, click on Add a New Condition, and then click on Show/Hide Field.

Here are the sample condition rules:

Sample results:

Let us know if there’s anything else we can help you with.

Hi Christian,

Ok we’ll try if that way works out.

Thanks for the quick help!

Best

Bernd