Hai bisogno di aiuto con una formula per escludere una certa età?

Buongiorno,

Vi scrivo in quanto abbiamo necessità di implementare il calcolo di età per ogni ospite all'interno dei nostri form di cui in vi mando il link. Al momento calcoliamo l'età di 14 anni affinché un campo non venga visto.

Dobbiamo applicare un nuovo calcolo di data per ogni ospite in modo che il widget di calcolo escluda nel calcolo gli ospiti al di sotto di 18 anni. E' possibile?

Mi potreste guidare passo a passo includendo anche le formule per:

1. Calcolare l'età;
2. Escludere gli ospiti sotto i 18 anni dal pagamento delle tasse;

Grazie mille con anticipo

Hi Marco_Romano,

Thanks for reaching out to Jotform Support. Our Italian Support agents are busy helping other Jotform users right now, so I'll try to help you in English using Google Translate, but you can reply in whichever language you feel comfortable using. Or, if you'd rather have support in Italian, let us know and we can have them do that. But, it might take a while until they're available again.

Now, coming back to your question, just to confirm, do you want guests that are under 18 to not pay taxes, or to not be included in the calculations? Also, can you explain a bit more about how you want the process to work so that we can have a better idea of what's going on and help you with this?

As soon as we hear back from you, we'll be able to move forward with a solution.

The guests under 18 need to be EXCLUDED therefore NOT pay taxes.

We have the calculation Widget in the form that calculates the days the guests are staying + the number of guests. Each page of the Form has got the info of every guest. There should be a calculation of the age for every single guest and that calculation should be included in the final taxes calculation widget. Does it make sense?

HI Marco_Romano

Thanks for clarifying, you can achieve this in your form using conditional logic alongside the calculation widget. Here are some example steps to do so.

1) Calculate Age Automatically by adding a Date Picker field for the guest’s Date of Birth the use the Form Calculation Widget to calculate the age by subtracting the birth year from the current year

2) Apply Conditional Logic by going to to Settings > Conditions > Update/Calculate Field. Then Set a rule If Age is less than 18, then set Tax Amount to 0. For guests 18 and older, keep the normal calculation.

3) Adjust Final Tax Calculation by making sure only the tax values from guests aged 18+ are included in the final calculation.

Let us know how you go with the above.