List of records - edit and create new in form

Scriptcase 8 Discussion
#1

Returning newbie so I might be missing something really simple to accomplish this.

I want to have a list of records from the database (grid) and then edit those items in a modal form. I also want to create new items in the modal form.

I can get editing in a modal form (the form is limited in its layout options so its not ideal) but the add new record still happens in the grid. I don’t want this operation because 1)its ugly because of what I call the scriptcasejump. The change to input fields drastically increases the form width 2) the grid list should only show a few fields while the detail popup has all of the fields for this entry.

The only way I can see to do this operation is to create a grid application and then link a form application. Aside from the extra work, the issue I see is that when data changes on the form, the grid needs to be updated to match. Ideally this means requery-ing the single record so the entire page doesn’t jump. I didn’t see an option to requery one row - sc_ajax_refresh(); does the whole grid. It also brings up pagination issues that I haven’t explored yet.

Can anyone point me in the right direction to create the basic application?

#2

Not a nice answer I’m affraid, but with scriptcase as a case tool you are limited to the way the tool works. If you create a link to a form from a grid you simply have to accept that after closing the form, the grid is rebuild and the last inserted record is not repositioned. There has been some attempts that you can find on this forum, but I never found a decent working application that did this.
You can consider to create a multiple edit form. That way you will enter data in a grid and the inserted record remains in focus. But it will not work on records with a lot of fields.