LiveCode Forums

Dear DGH Users,

We are working hard on a new DGH version, supporting the datagrid 2 control and adding new features.

Here is a list of the features we are adding for this next release:

1. Datagrid tables:
- possibility to change the sort icon of the datagrid
- capability to custom the header of a column, for adding a checkbox or an image for example.

2. Datagrid forms:
- new datagrid 2 properties
- possibility to change the new templates introduced by datagrid 2: left swipe, right swipe, etc
- capability to edit these new templates in the DGH form builder

3. New objects available in the form and table builder:
Widgets are now supported.

4. More features to come:
- actions scripts in controls outside of the datagrid for adding / deleting rows, searching inside the datagrid, displaying the number of rows in the datagrid and the number of rows selected
- columns actions: having the row number in the first column, perform calculations (for example col3 = col1 * col2)


Datagrid 2 properties


Datagrid 2 template editor

Nicely done, Zryip. Thanks for posting this.

Thanks Richard.

We have now the new template editor fully working with datagrid forms. Here is an example of customization into the new datagrid 2 control.



In the DGH's template editor, templates are loaded from the template card corresponding group (or wherever the developer has defined the templates). One can edit them directly, experiment the changes in the preview and once satisfied by the result, apply the change to the final datagrid. Nothing is changed in the selected datagrid until the developper decides to apply the changes.

Wow, very nice!!

I am very much looking forward to this update

paulrichards999 wrote: ↑

Tue Jan 23, 2018 11:10 am

Wow, very nice!!

I am very much looking forward to this update

Thanks Paul!

Now, a quick word about datagrid headers customization. We still have work to do on this but, basically here is the result we are expecting by allowing to customize datagrid headers:
- checkbox headers
- images headers
- widgets headers
- multi line headers

For accomplishing this, one has different headers presets available to drag in the template header area for adding all the controls required by the header.

Here is a screenshot of the result of our last experimentations:

In addition to the new DGH's header editor we think developers must have the possibility to keep an hand on the header of each column by code, even if DGH is not present (for example in the standalone), so we have defined a couple of properties for doing that. Here is sample of some available parameters:

In the DGH's Header Editor, we have included the possibility to use a widget instead of the classical sort arrow icon.

Here is a preview of the result:

Another feature we are working on for the 2.5 version, is a script for finding text inside a datagrid:

HI everyone,
Does that DataGrid Helper enable moving Datagrid´s lines up and down ?
...like moving one on top of the others to change their order...using the touchscreen ?
I saw a small video weeks ago - on facebook if I remember well, cant find it anymore !
...I m looking for to know if that more fancy Datagrid is available yet ?

Anyone has seen it or has info about it, is it reliable to use
Tks

Hi Teriibi,

For clarifying things a bit.

1. Data Grid Helper is a commercial Plugin for customizing near all of the aspects of a datagrid from properties (color, line height, etc) to templates (adding fields, checkboxes, buttons in datagrid rows). It contains ready to use scripts such one for reordering rows in a datagrid, coloring columns, adding number formatting to cells, etc. It is also capable to create coherent code (I hope, but this is the goal ) for datagrid template by detecting the controls added by users.
https://livecode.com/products/thirdpart ... per-1-3-4/

2. DG2 or datagrid 2 is the new datagrid control coming from LiveCode in remplacement of the old datagrid control. This topic is a preview of what the Datagrid Helper Plugin I'm actually working on, will contain of new features built around the datagrid 2 capabilities and not only.
https://livecode.com/project/datagrid2/

So now for replying to your questions:

teriibi wrote: ↑

Fri Feb 09, 2018 8:41 pm

HI everyone,
Does that DataGrid Helper enable moving Datagrid´s lines up and down ?
...like moving one on top of the others to change their order...using the touchscreen ?

Yes DGH can do that for datagrid table and form. And this will be included natively for form in the datagrid 2 control.

teriibi wrote: ↑

Fri Feb 09, 2018 8:41 pm

I saw a small video weeks ago - on facebook if I remember well, cant find it anymore !
...I m looking for to know if that more fancy Datagrid is available yet ?

Anyone has seen it or has info about it, is it reliable to use
Tks

You have probably seen this video on youtube.
https://www.youtube.com/watch?v=qHTRX6D2N8U

The datagrid 2 is still in development and will come with the new LC version 9.
DGH, our plugin, is still in development and will be released after the datagrid 2 release.

Thanks, you made it clear now !
Hope we can get this DG2 ready soon...

The DGH 2.5 is still in progress.

The "Action Scripts" are now fully implemented in DGH:



One can select a field in a project, and then DGH is installing a ready to use script for finding text inside a DG. Color to use is a parameter.
Another action script is capable to show how many rows are found. The text displays is using a customizable pattern so one can display the required text.

All of these parameters are custom properties added by DGH, so they are scriptable.

The next challenge of DGH is to come with a convenient interface for implementing calculation.

In our Lab we have prepare script for supporting simple formulae and for doing grand total using functions such as sum, max, min and average.



Yellow columns are locked and are the result of the formulae listed in the field below the datagrid.

I do not know if this will be in a real interest, but this is giving me the idea to add in DGH ready to use scripts for having the datagrid behave as a spreadsheet:
- navigation by using arrow keys
- one click for editing a cell instead of two.

Sure looks really cool, already can see how I could use it...
..if then condition ...Col1 = Col2 + Col3 possible ?
..and count too ?!
(number of items in a column based on criteria count text, count numbers, count empty space., null...)

PS: if for small devices screen, I bet the navigation buttons would be very usefull. especially if you can freeze the first(s) columns (as well as the horizontal - Title line)
i.e, first column has students name : next columns on the rights side , contains notes for each month.
(scroll datas to the right...to see each month..Last column, sums up anual Average/number of exams yearly.

About editing Cells in 1 or 2 clics.

Would it be possible to customize a partial editing on selected columns like in 1 or 2 columns only.
Say, I send a proforma invoice to a customer, asking him to confirm quantity of items.

Editing columns :
Col1 : Item Ref. / blocked
Col2 : Item Name / blocked
Col3 : Qty to order /Editable = allow edition by client
Col4 : Unit Price. / blocked
Col5 : Total price per line. / blocked
Col6 : Tilde Ok/No / Editable = allow edition by client

Client can edits only Col3 and 6
Totals updates automatically.
Client can then send back the Datas, no messing possible with other columns.