Jump to content
Sign in to follow this  

Creating a Complex Form - What's the Best Language(s)

Recommended Posts

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.

  1. 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
  1. Inputted data must have ability to be saved any time, so user can return to it and finish filling it out whenever.
  2. 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.

What summary pages do.png

Share this post

Link to post
Share on other sites

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.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...