Asset Managment using Metastorm Question

Sean Brown

I am trying to create an asset management system for a more-or-less static set of assets that need to be inspected every so often.

All the assets are arranged in rooms and I would like to start a new process that pulls all the assets in a certain room from a sql table into a grid.

 

Then, this grid would be editable and have an extra column next to each asset to allow a user to type an inspect number (1-5)

 

Finally, after the user entered all the number for assets, the bottom green arrow would be clicked and new rows would be created in a sql table with all the data in the grid.

 

I can pull the sorted data into the grid, but I am stuck after that with making it editable having an extra row and created new rows. Is this even possible in Metastorm, and if so where might I start to look for the answer? Thanks

Brian Mellert

Not 100% I understand what you mean by "making it editable having an extra row and created new rows".

 

Presuming your table is a single table (no joins, etc.) then you can easily make the grid editable to allow the update of the other column(s).  On form save the system will take care of the updates for you on save.

 

You can also choose to allow rows to be inserted or deleted and the system will handle the insert/delete for you on save as well.  If deletes are allowed, rows are removed via the delete key.  If inserts are allowed, rows are added via the insert key.  (If you need to allow entry of the other columns you don't want editable while updating (asset name perhaps), you may want to consider a separate grid for inserts.  It all kind of depends on what you want the users to be able to do