DONE: Grid Editing

Question

The ability to edit the data in a grid to allow for more efficient entry.

Comments

This would be very useful for some of the more "Excel" type data that we use. The ability to alter data directly into the "Table" data and then just update it by clicking the Update button would be useful in a number of scenarios that we have here.
Regards
Colin
Update - 13th May 2020.
If this was also able to incorporate child tables too, it would even be better, something like:

Main Table>     Order Header       Order Date    etc..
                        12345AB              13-May-20
Child Table>    Item Number    Qty    Price        etc..
                       XYZ_123           12      34.56
              ABC_675              1     10.00
Main Table>     Order Header       Order Date
                         56789ZX              15-May-20
Child Table>    Item Number    Qty  Price
                        dfr_765               1   20.00
            P&P                    1     7.95

using colouring and banding to highlight each instance of a new Main Table and +/- buttons to Add/Remove rows on both Main & Child tables

---

PLEASE add this! We still need SQL scripts for bulk editing, currently.

---

@gruskada, dbFront 1.0.10.665 now allows for updating or deleting multiple records at a time.

---

@AnthonyV - this is a nice improvement. Thanks!

---

@grushada, Not sure you if got the update.  Grid Editing is now done with 1.1.0.3232.

---

@grushada, Color banding, or conditional row styling is now also available in this release.

Answer 1

Grid Editing has being released with the 1.1.0 version of dbFront.

No configuration changes are required to enable grid editing. Users can simply click on a table field and start editing.

• To edit the existing contents simply select the field and hit ENTER.
• To replace the existing contents simply select the field and start typing.
• Moving off a field will immediately post the contents to the server.
• To cancel the edit hit ESC.

For more on using the keyboard to navigate and edit see: Keyboard Shortcuts & Navigation

For release details see: dbFront Version 1.1.0 Release Notes

Comments

hi Anthony, 2 quick questions on grid editing:
1) Can a new row be added directly in the table grid?
2) It appears that grid editing doesn't currently work with cascading lookups, is that accurate?

---

Hello Daniel, 1) There is currently no ability to add a row from within the grid.  The form buttons [Create New, Create Copy] are required.  I do hope to add the ability to create new rows but would likely use a popup form. 2) Cascading lookups were too complicated to implement in the grid, both from a design and a usability perspective.  Grid editing is best designed for simpler changes.  A form allows for more opportunities for guidance.

---

understood, thanks!