Editable Grid inserting new rows and not updating existing

Finlaysons IT

I have a requirement to create an list of tasks that is currently being done via a paper form and requires the user to tick or cross the task to mark the task as a success or failure and if there is a failure then there is a space next the the task for comments.  The list of tasks is stored in a database.

 

I am thinking of using a grid that uses a table BO, so that the user is using something that is as close as possible to the paper solution they are currently using.  My problem is that the task list shouldn't be updated, but instead each time the process is run and the user completes the checklist that a new set of entries is created in a history table that records the success/failure of these tasks.

 

Can anyone provide any possible solutions or pointers to how I can go about creating an editable Grid that will accomplish my objective, or any other ideas on how else I can achieve this?

 

The main aim of this is to ensure the user is doing the process in as close a manner to the current way, so an editable grid with a drop list to record the success/failure and an optional comment column would be well suited, but requiring the user to select the row and update fields below the Grid is something that I would preffer not to do.

 

Any assistance would be greatly appreciated.

 

Thanks,

 

 

Matt

Jerome_Pearce

We do this quite a lot. I do not have a specific example that I could give you, but we have something similar in our Development solution. In the System Build process, the developers add Deployment Instructions. The testers then have to check each one as passed or not in the testing step. You can download it here:

http://processmapping.com.au/freestuff/freemetastormbpm9solutions/Development.html

 

In many of our the systems we build, we add a 'review' process that copies data from another table into a table just for our process. Each row has a 'Yes/No' dropdown (or sometimes just a 'Yes') and an optional comment field. Some systems maintain the same rows, and they are updated with progress each time around. It all depends what you need from it.

 

From what you say, it looks like you need to copy a set of task from a template table into a table linked to that Folder, and with  additional 'Yes/No' and comment fields for the user to fill.