I have a project in mind to automate a manual process. Essentially what I need is the following:
- A ticket will be presenting a form to the user. The accepted values for each control of the form is dynamic, extracted from database.
- The user enters the data and saves the changes on the ticket.
- When the user checks the ticket in the corresponding webpage, the ticket will show additional information which will be calculated based upon the data contained in the ticket and some other data found in a database. The needed calculations are not expected to be hard.
- A report should be able to be extracted from the ticket. This report will contain the calculated fields from the ticket.
My main question is: how can I do this?