How to run calculations on Input Table, and export data to Google sheets

I am sorry I am confused by what you are saying, I specifically need to run calculations in using specific cells, or I guess I have to have a whole individual field to run the calculations so I can just choose that field if it is going to select a whole row and a whole column versus just one cell for the data I need? How then can you add to cells in a row?

So you are saying that to have the data exported to excel or a google spread sheet every entry has to be a completely seperate field?? It seems like that doesn't make sense given the whole purpose of gathering data? Why have any other question option then, than just one field with one column and one row, for every possible option??? I don't understand what you are saying?

Hi Krista,

Thanks for using Jotform. You can run calculations in the Input Table using the Update / Calculate field condition. See the screencast below:

Here's the result:

As for the data being exported, each field in equal to a column. So all the information entered to the Input Table, will reflect in one column only. See the screenshot below:

This also applies when you exported the submission to Google Sheet. The rows will reflect each submission in the form.

Let us know if you have any other questions.

How do you calculate statistics with the entries like that then?

Hi Krista,

Thanks for getting back to us. We're sorry for the inconvenience this may have caused. Please note that each submission is listed in one row, and when downloaded as Excel or CSV, also the input table info get listed in the same submission row, but each cell will be shown as a new column. Check out the screencast below to better understand our explanation:

If you would like to obtain the information differently, can you please provide us more information? This way, we will be able to send a feature request to our developers.

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

I know I made a google sheet for this to get export to and automatically update but now I can't find where you make that assignment in jotform so I can find what the google spreadsheet was called.....can you please assist?

It would be SOOO much easier, for data research purposes if each cell would obviously download as its own row and column assignment - that would equal its own field ID, or ID or whatever, that doesn't seem like software wise that would be too hard to do? because I would think even for marketing reasons, people want the data from one cell, not repeated over and over? They will have cell 1 with a certain column header and row header and that will be different data for each cell in that row if the column header is different for each column? Then what happens?

This is NOT working I need help please, I am not getting the options you are and the options for the cells are not even listed. Please assist. I have so many calculations more than this and I haven't been able to get help on this yet, it looked simple in your demo so I thought it would be but it isn't working.

Hi Krista,

Thanks for reaching out to Jotform Support. You can integrate your form with Google Sheets so that the submissions will be sent automatically. Let me show you how:

• In Form Builder, click on Settings at the top.
• Go to Integrations on the left menu, then choose Google Sheets.

As for the input table, unfortunately, each cell in the input table cannot have a separate column in the submissions table.

About the calculation, can you tell us more about the calculation you're working on so we can work on a solution? You can follow this guide on Calculate Values in the Input Table Through Condition.

Let us know if you need any more help.

It is an effect size calculation, I need them to enter the mean values of each group, or pre post for 1 group, the SD of each, and the n of the group into my table and then I need to run this

=G3-D3 the difference in the means ( I am just using my excel info to just show you the equation

=H3+E3/2 pooled SD

=SQRT(((N3-1)*E3^2+(P3-1)*R3^2)/(N3+P3-2)) pooled SD if 2 groups

=Q3/S3 mean difference divided by pooled SD = Cohen's D

Hi Krista,

Thanks for getting back to us. I’m sorry you're having issues with your form. Let me look into it and get back to you with a solution.

Hi Krista,

Upon checking, the input table value will have a separate column for each cell when saved on Google Sheet. It would look like this as an example (I shrunk the column width so they will look visible)

Based on the image example that you have shared regarding calculation, please provide us more details about what you would like to achieve with the calculation formula as shown in the screenshot you provided for us to easily implement the calculation that you wanted to achieve.

If you would like a separate field for the result of the calculation, I would recommend using this guide.

Let us know if you have any other questions.

You asked me -------Based on the image example that you have shared regarding calculation, please provide us more details about what you would like to achieve with the calculation formula as shown in the screenshot you provided for us to easily implement the calculation that you wanted to achieve.

I just need to have the calculation Cohen's D from the data that is in the cells used to calculate that result. I need the Cohen's D to know the effect size of the intervention. A separate field is a good idea.

For the rest I just need the numbers from those cells to calculate that answer, but it is that answer that is all I need, does that make sense?

Unfortunately I have to calculate it again, with more than just 1 group pre and post, and it is a different calculation, but again for that I only need the final answer after the person filling out the form gives me the information, but I may be able to pull it from a different table in the form, would that help?

Thank you,

Dr. K

I am confused about what you showed me above, there will be only `1 row per submission, and each column is ALREADY its own cell, I don't understand why yours has SO many columns? Can you help me understand that? So it is like transposed? So each row becomes a column, but there is ONLY 1 ROW? besides the headers, aren't the headers seperate?

If I have to run calculations, from data input into a table, how do you suggest I do that?

I have to be able to run statistics on the data that is provided by the form, should I just skip jotform and use excel???

Hi Krista,

If I understand correctly, you would like to apply the calculation that you have provided as shown in the screenshot

to the Input Table on your form as shown in the screenshot.

If yes, could you point out to us which columns G3, D3, H3, E3, N3, E3, P3, R3, Q3, and S3 represent? Currently, we can't tell if G3 represents N Pre, Mean Score Primary Outcome Measure Pre Intervention or (Mpre) etc. just based on the screenshot that you have provided.

Once we hear back from you, we'll be able to help you with this.

Sure thank you so much

G3 = Mpost

D3 = Mpre

I need the difference between Mpost and Mpre - so that is probably G3-D3 this calculates the difference

I think the equation is from a different part of the table I can't match it up to the one inserted into jot form -

basically above I need

Mpost - Mpre = Difference

Pooled SD = Sd pre+SDpost/2

Cohen's = difference/pooled SD

If we could just start there then may be I could tell how to make it more complicated if I had to?

Does this help?

I=G-D

J = (E + H)/2

K = I/J

And this is for the harder equation you have with the Sqrt and all that jazz. If you could help me make it easier I would be eternally grateful.

Hi Krista,

Thanks for getting back to us. I have created the Update/Calculate Field conditional logic based on the information that you have provided as shown in the screen recording.

I=G-D

J = (E + H)/2

K = I/J

Result:

You can check out my demo form and clone it so that you can review the configuration.

Give it a try and let us know how it goes.

I haven't filled it in yet but I put in the calculations and really appreciate the step by step instructions!