Tools to Output documents from DB based on selections
Posted on 2016-09-23
Any advice or tool suggestion is helpful and will get points!
I'm currently in an IT services role where I'm creating client facing statements of work that are composed of various blocks of steps. For example, installing a firewall, configuring content filtering, installing a switch.
My existing process is a word doc template and a one note full of steps that I paste in as needed. The problem with this is that it's too manual, has no time formulas, and I also need to corollate work instructions with each step. For example installing the switch is on the SOW but the work instructions are more detailed: update current firmware, configure client snmp string, etc...
To solve these problems, I shoved it all into excel and also got some nice math time estimating features. It's still alpha but looks like it could work, abit clunky, hard to manage and version, hard to share with a team, etc...
I've got a sql background and I know I could use something like access to make the forms and output report docs but I know that adp is dead and I'd prefer something web based.
I do not want to pay for a giant document management or proposal generation application which probably doesn't event have the key feature of tying the sow lines to the work instruction steps. I also don't really want to do the DB work and then have a custom program written just for the forms and document generation.
Ideally this would be a webapp (saas or hosted) where I can check some boxes, select the steps I want, enter some numbers and have the two documents generated.
Does anyone know of anything like this for any industry? I'd imagine there are other uses for a tool like this besides IT services. I'm also very open to a saas something like access/adp/sql where I could create the logic myself drag and drop, I just don't want to make custom web forms from scratch in .net or similar.