→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!
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.
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
→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.