theClerk Posted May 9, 2019 Share Posted May 9, 2019 I'm tasked by my employer to turn a complex Excel document into a web-based form that must output as a clean, customer-facing PDF document as the final end result. This document must be used for different jobs, so employees currently save a copy on their computers and fill it out, giving it a different file name. My current thought is HTML + JavaScript will do the trick. The form must do the following. Summarize inputted numbers from input fields throughout the document so the numbers can be summarized on a single summary page. (see attached image.) How this currently works with the Excel doc: We have 4 summary pages and over 30 input field pages Plain numbers are entered in the input field pages The 4 summary pages use the Excel addition formula to add up the numbers from each input field on the input page, corresponding to what each summary page is summarizing Inputted data must have ability to be saved any time, so user can return to it and finish filling it out whenever. Output as a presentable, client-facing PDF Everything else, like the ability to rename the header and with each use of the document is something I believe can be done so long as the document is saved offline by users. Link to comment Share on other sites More sharing options...
justsomeguy Posted May 10, 2019 Share Posted May 10, 2019 I'm building something vaguely similar with React, if you've worked with that before then that might be a good option. Depending on what your skill set is, you can probably think of other ways to do it. If you have specific questions that you need help with then feel free to ask. Link to comment Share on other sites More sharing options...
theClerk Posted July 16, 2019 Author Share Posted July 16, 2019 On 5/10/2019 at 12:49 PM, justsomeguy said: I'm building something vaguely similar with React, if you've worked with that before then that might be a good option. Depending on what your skill set is, you can probably think of other ways to do it. If you have specific questions that you need help with then feel free to ask. Thank you, JustSomeGuy. Sorry for the late reply. I'll check out React and get back to you with any questions I have. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now