-
AgilityAssoc.CanadaAsked on July 21, 2018 at 2:39 PM
Hi,
On my form 80704754652964 I use a number of configurable list with only one row.
Each row is for Number of Events per class and Judges names. There are usually between 1 and 2 judges per event. I did this some time ago.
What I asking is, do you have an alternate method you might suggest for doing this.Perhaps a newer widget. I am trying to streamline the process. I was think of a check boxes that would use conditions to display only the configurable lists required, but that may just add an unnecessary step.
Below is one class, Starters, with 4 configurable lists. The applicant has to put in how many events for each discipline in the class, Judges or Judges and a note if any.
There are 3 Classes with the highest having one more discipline and a Games Class with 2 disciplines.
This form is one of the most filled and one that is most complained about. We had a PDF version that is actually easier but is out dated.
Any help with this particular part of the form would be appreciated.
Best, Robert
-
Vanessa_TReplied on July 21, 2018 at 4:43 PM
Below is one class, Starters, with 4 configurable lists. The applicant has to put in how many events for each discipline in the class, Judges or Judges and a note if any.
May I suggest using an Input Table field instead. You would then need to create one Input Table per Class.
-
AgilityAssoc.CanadaReplied on July 22, 2018 at 11:06 AM
Hi,
I did try this option some time back but for some reason I don't recall I abandoned it in favor of what I am using. I don't remember how the data is shown on the notifier email. Right now if a event class is not filled in it is not submitted. Only filled in data fields are viewed. I believe this makes it a bit easier for the coordinator.
I do like the table because it takes up much less form space and one table per class is good.
I think I will make a clone and try it out again. If you can think of any other options I am open to suggestions.
Thank you, Robert
-
Mike_G JotForm SupportReplied on July 22, 2018 at 12:19 PM
The whole table is shown in the email notification regardless if the rows/columns are filled or not.
How about we create a main Input Table for a Class that has all the discipline then sub-tables that separate each discipline.
Only the main tables are shown on the form, however, in the email notification content, it will be the sub-tables.
Each sub-tables are filled conditionally based on the input in the main table.
Calculate-Values-in-the-Input-Table-Through-Condition
Here's a Sample Form — https://form.jotform.com/82024875435964
Feel free to fill it in and/or clone it so you can inspect it.
If you have other questions or concerns, please do not hesitate to let us know.
-
AgilityAssoc.CanadaReplied on July 22, 2018 at 1:53 PM
Hi,
I like the idea. But i'm not sure I am getting the logic just right on 82024759059967.
Also note that after I submitted the image I noticed an error with mine, where it indicates "Starters Standard", I have replaced them with "Advanced Standard"
Thanks, Robert
-
Mike_G JotForm SupportReplied on July 22, 2018 at 3:48 PM
Apologies if I have made you confused. I checked the form you shared and I see where the issue is.
Allow me to explain to you further how it's done.
To begin with, let's say we have this condition.
That condition means that we're passing the value of the cell (0, 0) in the Starters table into a cell in the Starters Standard table.
It starts with "Starters" because it's from the Starters table. Then, the first 0 is the row and the second 0 is the column in that table
And which cell in the Starters Standard table should we pass it in? (Please refer to the image below)
It should go to the cell on Events column of the Standard row in Starters Standard table.
Now, in your screenshot, you have these conditions.
Those conditions mean that the cell value that is being passed to the cell(s) in the Advanced Jumpers table is from the cells on Events column and Judge 1 column of the Jumpers row in Advanced Jumpers table and not from the Advanced table.
This is the reason why those aren't working.
To correct that, the condition should look like this:
Here's how that condition was created:
Here's an illustration that explains the logic behind that condition.
You just have to remember that it should be from the cell in the Main Table to the corresponding cell in the Sub Table.
I hope this helps. If you have other questions or concerns, please feel free to contact us anytime and we will be glad to help you.
-
AgilityAssoc.CanadaReplied on July 22, 2018 at 5:21 PM
OK...
I have the rhythm now. Now, will field manager to copy logic as well, or do I have to start from scratch, adding this to the existing form... I have a feeling it is from scratch. You need a tool that can do this.
Thanks for this option, it's a bit of work and a thinking, (brain), exercise.
Robert
-
Victoria_KReplied on July 22, 2018 at 5:30 PM
Hello Robert,
Unfortunately, you can copy only fields with their settings using Field Manager tool. Conditional statements need to be set up manually. But, that is probably better as you will re-check every step.
We will gladly assist if you need help.
Thank you.