JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Can I change an excel report (Ex: Manually inserting "Paid" in a new row when checks come in.)Asked by NWIHabitat on March 10, 2015 at 05:15 PM
When I open 'My Report', select Excel report, manually enter the text "Paid" to a new column then click Save I find my Admin Entered Data does not remain saved in the new column. I had assumed it was saving to JotForms; because when I click save I am not prompted with dialog as you would see with a newly saved document.
I can work around this but, this is being passed off to another user who I would like to make this as easy and manageable as possible for.
The ideal situation is...
1. Open Doc via JotForms\reports
2. Input Information
5. Repeat when needed
Let me know if this is possible, if not I'll add some password protected hidden fields for her to populate on the backend via the Submission Veiwer 'Edit'.
I keep thinking I'm missing something really easy over here because this functionality just seems like it would be the normal practice.
Thanks a bunch!
Apologies but I am having a little confusion following your instruction. Mind giving a little clarification here? :)
When you say reports, are you referring to the submissions or reports? Check this image:
What confuses me is this "manually enter the text "Paid" to a new column then click Save". I can't figure out how you manage to enter text to a new column on the report? Or are you perhaps referring to the downloaded excel file?
We'll await your reply. Thanks! :)
By the way just to confirm, we only have one method to update data in the back end which is the submissions edit you mentioned.
Let us know if you have questions. Thanks!