Can I calculate the Age and populate a value to another field in Jotform Tables?

Give it a try and let us know if you have any other questions .

Step_Onward Replied on May 9, 2024 at 1:31 PM
  1. 50-64 populates by default, even when creating a new entry.
  2. This field is editable, even though I have it set to read only. Nothing is in the default value (see below).

Screenshots below of my conditions and the field.

My other question:

  1. If I create the age group on the form and not the table, it does not populate the table, so is it possible to create this age group on the table directly? I do not see that I can do that with all the conditions etc.
  2. If I can't create the age group directly on the table, so it updates all of the existing entries, does that mean I have to go through and make an edit to each form to make it recalculate? Is there an easier way to force it to do this?

Thanks for your help!

Mafe_M JotForm Support Replied on May 9, 2024 at 2:29 PM

Hi Kris, Thanks for getting back to us. I’ll need a bit of time to look into this. I’ll get back to you as soon as I can. Thanks for your patience.

Mafe_M JotForm Support Replied on May 9, 2024 at 8:52 PM
  1. ln Form Builder, click Add Form Element on the left-hide of the page.
  2. Drag and drop the short answer fields in your form.
  3. Click the gear icon and go to Advanced tab and set Default Value to Age Group.
  4. Toggle the slider to ON for Read-Only Option.

II. Set up a show/hide condition that will show the age group depending on the age.

1. In Form Builder on the orange navigation bar, click Settings.

2. Go to Conditions tab and Click Add New Condition, then select Show/Hide Fields.

3. Set up a condition like ones below.

4. Click Save to apply the changes.

Here is the demo form I used. You can clone the form using the form URL so that you can check on how it is implemented. Cloning your forms using a form URL is easy to do. Let me walk you through it:

1. Open your My Forms page and click on Create Form on the left side of the page.

Can I calculate the Age and populate a value to another field in Jotform Tables? Image 4 Screenshot 103

2. In the window that opens up, click on Import Form .

Can I calculate the Age and populate a value to another field in Jotform Tables? Image 5 Screenshot 114

3. In the next window, click on From a Webpage .

4. Paste the form link into the Enter URL field and click on Create Form .

Can I calculate the Age and populate a value to another field in Jotform Tables? Image 6 Screenshot 125

After cloning your form, it will open up in Form Builder automatically. Now, you can edit the way you want it and publish it.

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

Step_Onward Replied on May 10, 2024 at 12:05 PM
  1. If I create the age group on the form and not the table, it does not populate the table, so is it possible to create this age group on the table directly? I do not see that I can do that with all the conditions etc.
  2. If I can't create the age group directly on the table, so it updates all of the existing entries, does that mean I have to go through and make an edit to each form to make it recalculate? Is there an easier way to force it to do this?
Angeli JotForm Support Replied on May 10, 2024 at 12:41 PM

Hi Kris, Thanks for getting back to us. I’ll need a bit of time to look into this. I’ll get back to you shortly. Thanks for your patience, we appreciate it.

Angeli JotForm Support Replied on May 12, 2024 at 9:55 AM

Can I calculate the Age and populate a value to another field in Jotform Tables? Image 1 Screenshot 30

Hi Kris, We really appreciate your patience and understanding while we’re looking into this. For your first question, when you say Table, do you mean the submission Table? If so, yes, you can calculate the Age there, but you can't create the conditions to populate the result on another field in the Jotform Tables. So you will have to do it in the form. As for the second one, yes, you need to edit each submission for the Age Group value to populate. But, I noticed that your condition is not properly configured, that's why it's showing an incorrect Age Group. You'll have to change the below conditions from 'Any' to 'All'. Take a look at the screenshot below: Let me show you how:

  1. Click the Pencil icon and change the IF condition from ANY to ALL.

Can I calculate the Age and populate a value to another field in Jotform Tables? Image 2 Screenshot 41

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

Step_Onward Replied on May 13, 2024 at 2:40 PM This works. I completely missed the Any/All setting! Thanks for your help!