-
CollageofPhysiciansandsurgeonAsked on May 13, 2021 at 9:11 PM
-
Vanessa_TReplied on May 14, 2021 at 1:53 AM
Please follow this guide when doing calculations related to an Input Table field:
https://www.jotform.com/help/343-how-to-perform-form-calculation-in-the-input-table-field
-
CollageofPhysiciansandsurgeonReplied on May 14, 2021 at 9:11 AMI dont think you read my question......I know how to used input calculations however it does not break down the actual responses which is what I need to calculate.
... -
Yau_CReplied on May 14, 2021 at 10:41 AM
Perhaps we are not seeing what you are seeing from your end.
There are 49 forms in your account. Please provide the url of the form which you are referring to.
More detailed explanation and screenshots would help us to understand your issue.
Looking forward to your reply.
-
CollageofPhysiciansandsurgeonReplied on May 14, 2021 at 10:54 AM
ok,
I have 10 charts that have all the same input tables with the response of yes, no or n/a.
I need to add the response to each row in the table to the response in the same row in all 10 charts.
So at the end when I create a report I have 1 table looking like this from the responses of all 10 charts, the only why I've been able to do this is to make a calculation widget for every row times 3 for each response which I am ending up with a lot of fields and conditions.
I am wondering if there is a better way to accomplish this . https://form.jotform.com/211154656989266
Thanks
-
CollageofPhysiciansandsurgeonReplied on May 14, 2021 at 10:55 AM
Also, I had originally had a question in my original submission, not sure why it didn't show on your end.
-
Tommaso_FReplied on May 14, 2021 at 12:10 PM
Hi, thank you for contacting support.
Could you please give us more details about your concern so we can assist you properly?
Unfortunately, your description doesn't let us provide the best support. Could you please rephrase?
We look forward to your response.
-
CollageofPhysiciansandsurgeonReplied on May 14, 2021 at 12:19 PM
I don't know how else to rephrase this, I need to count every yes, every no, every n/a on every line in every input table. I need it to then compile the all those yes, no and n/a from all 10 completely same input tables into one that shows all 10 together.
example; out of 10 charts for the first row for "phone number": 6 were yes, 3 were no, 1 was n/a.
-
Tommaso_FReplied on May 14, 2021 at 2:05 PM
Greetings,
We tried to use the count function in Form Calc, but it only counts up filled inputs, doesn't care about the value. Did you already try our report builder?https://www.jotform.com/products/report-builder/announcing-jotform-report-builder/
Best regards. -
CollageofPhysiciansandsurgeonReplied on May 14, 2021 at 9:16 PM
Report builder wont work either as I can combined the input tables they all appear separate.
-
Girish JotForm SupportReplied on May 15, 2021 at 3:01 AM
It is possible but a bit cumbersome considering the huge number of input tables.
You will first need to assign calculation values to the Yes, No options in the input table and then use calculation conditions to pass on the total into another input table against the Yes column - https://www.jotform.com/help/343-how-to-perform-form-calculation-in-the-input-table-field
Here is a simple form showing how this can be done.
https://shots.jotform.com/gerard/screencast15052021_3.gif
Likewise, you will need to create conditions for each cell/column.
-
CollageofPhysiciansandsurgeonReplied on May 15, 2021 at 11:14 AM
So I tried this and it doesn't seem to work either....I used the two highlighted for examples as I tried using different input chart response settings.
All the conditions are set this way, all going to the different areas, however when testing it all counts in the one spot for the second input table and shows nothing for the first input table. I am using the different Matrix field for the questions I want together.
Record 1Record 2Record 3Chart at the end.......
The form is https://www.jotform.com/build/211335549388261
Thanks
-
Amin JotForm SupportReplied on May 15, 2021 at 1:37 PM
Hi again,
Kindly note that, unfortunately, it's not possible to assign calculation values to dropdowns in Input Tables. Therefore, it is not possible to perform calculations with the Input Table field when using a dropdown field as an Input Type.
Calculation values can be assigned to only radio buttons and checkboxes in Input Table.
Your understanding is most appreciated.