Submissions EXCEL/CSV reports: How to separate payment information into multiple columns

→Is there a quick way to get to a specific submission. i.e. a search for a name?

Welvin: Hi, I'm Welvin from Jotform Support. Good day!

→Hi Welvin.

Welvin: Meaning, across all forms you have?

→Yes. I have an amount discrepancy on my downloaded excel file and I need to check the original to see why the totals don't add up.

Welvin: Unfortunately, we do not have that feature. You have to access the form submissions page and use search below the grid list.

→ok. Thanks.

Welvin: You're welcome!

Welvin: Is there anything else I may help you with?

→I do need to have our form remade to not have all the data in one column when I download it to Excel. But that is probably something a programmer needs to address?

Welvin: I think so. For example, Address field.

Welvin: Matrix Field.

Welvin: Payment Tool

Welvin: You cannot just add these fields to your form and separate each option/section to a different column in Excel Spreadsheet.

Welvin: I would suggest to use single input field, i.e textbox if you want to separate the result into column(s).

→The programmer put all the purchases in one field. So all the data is in one sentence in one column. I am separating them by hand which is time consuming.

→My question would be how to make sure that each field has a credit card charge attached to it?

Welvin: Did you integrate the form to one of our payment integrations?

→I didn't make it, I just have to use it! I am a PTA treasurer. I will try to contact the person who made the form. I don't have time to fix it right ont. Thanks

Welvin: I'm checking now. What is the form name? or form URL?

Welvin: Okay, I think this is the correct one: http://www.jotform.us/form/41898166703161

→Thanks.

→Yes.

→All of the purchase options are in one field. Is there a way to separate them so that they go straight to their own column in Excel and still maintain the purchase total for the credit charge?

Welvin: Unfortunately, that is not possible to the form builder.

Welvin: That is part of the backend process.

→Okay. That would be a good fix.

Welvin: Our developer would have change that, if ever. But we'll have to create a request and submit it to them.

→I need to have the amounts separate so we can keep track of them.

→It seems like it would be an easy fix, but I'm not a developer. It would sure help me out!

Welvin: I would suggest to create a request to our support forum for that matter.

Welvin: http://www.jotform.com/answers/answer.php?

→Ok. Thanks.

Welvin is typing...