DataGrid Helper 2.5 Preview

Moderators: heatherlaine, robinmiller, kevinmiller, Zryip TheSlug

Zryip TheSlug
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 142
Joined: Tue Jan 26, 2010 10:15 pm
Contact:

DataGrid Helper 2.5 Preview

Post by Zryip TheSlug » Mon Jan 15, 2018 12:06 am

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
Image

Datagrid 2 template editor
Image
TheSlug
http://www.aslugontheroad.com - Tutorials, demo stacks and plugins for LiveCode
Data Grid Helper - An intuitive interface for building LiveCode's Data Grids
Excel Library- Extends the LiveCode language for controlling MS Excel

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 6044
Joined: Sat Apr 08, 2006 7:05 am
Location: Los Angeles
Contact:

Re: DataGrid Helper 2.5 Preview

Post by FourthWorld » Mon Jan 15, 2018 1:15 am

Nicely done, Zryip. Thanks for posting this.
Richard Gaskin
Community volunteer LiveCode Community Liaison

LiveCode development, training, and consulting services: Fourth World Systems: http://FourthWorld.com
LiveCode User Group on Facebook : http://FaceBook.com/groups/LiveCodeUsers/

Zryip TheSlug
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 142
Joined: Tue Jan 26, 2010 10:15 pm
Contact:

Re: DataGrid Helper 2.5 Preview

Post by Zryip TheSlug » Sun Jan 21, 2018 10:28 pm

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.

Image

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.
TheSlug
http://www.aslugontheroad.com - Tutorials, demo stacks and plugins for LiveCode
Data Grid Helper - An intuitive interface for building LiveCode's Data Grids
Excel Library- Extends the LiveCode language for controlling MS Excel

paulrichards999
Posts: 17
Joined: Thu Sep 04, 2014 3:32 pm

Re: DataGrid Helper 2.5 Preview

Post by paulrichards999 » Tue Jan 23, 2018 11:10 am

Wow, very nice!!

I am very much looking forward to this update :D

Zryip TheSlug
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 142
Joined: Tue Jan 26, 2010 10:15 pm
Contact:

Re: DataGrid Helper 2.5 Preview

Post by Zryip TheSlug » Wed Jan 24, 2018 12:42 am

paulrichards999 wrote:
Tue Jan 23, 2018 11:10 am
Wow, very nice!!

I am very much looking forward to this update :D
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:

Image
TheSlug
http://www.aslugontheroad.com - Tutorials, demo stacks and plugins for LiveCode
Data Grid Helper - An intuitive interface for building LiveCode's Data Grids
Excel Library- Extends the LiveCode language for controlling MS Excel

Zryip TheSlug
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 142
Joined: Tue Jan 26, 2010 10:15 pm
Contact:

Re: DataGrid Helper 2.5 Preview

Post by Zryip TheSlug » Sat Jan 27, 2018 9:31 pm

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:

Code: Select all

on mouseUp
   local tData
   
   put the dgh_CustomHeaderColumn of group "datagrid 1" into tData
   put "center" into tData["Col2"]["header control alignment"]
   put true into tData["Col2"]["checkbox hilite"]
   put 5 into tData["Col2"]["header control top margin"] 
   put "right" into tData["col3"]["header control alignment"]
   put 5 into tData["Col3"]["header control top margin"]
   set the dgh_CustomHeaderColumn of group "datagrid 1" to tData
   send "ResetList" to group "datagrid 1"
end mouseUp
TheSlug
http://www.aslugontheroad.com - Tutorials, demo stacks and plugins for LiveCode
Data Grid Helper - An intuitive interface for building LiveCode's Data Grids
Excel Library- Extends the LiveCode language for controlling MS Excel

Zryip TheSlug
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 142
Joined: Tue Jan 26, 2010 10:15 pm
Contact:

Re: DataGrid Helper 2.5 Preview

Post by Zryip TheSlug » Tue Jan 30, 2018 12:44 am

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:

Image
TheSlug
http://www.aslugontheroad.com - Tutorials, demo stacks and plugins for LiveCode
Data Grid Helper - An intuitive interface for building LiveCode's Data Grids
Excel Library- Extends the LiveCode language for controlling MS Excel

Zryip TheSlug
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 142
Joined: Tue Jan 26, 2010 10:15 pm
Contact:

Re: DataGrid Helper 2.5 Preview

Post by Zryip TheSlug » Thu Feb 01, 2018 11:17 pm

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

Image
TheSlug
http://www.aslugontheroad.com - Tutorials, demo stacks and plugins for LiveCode
Data Grid Helper - An intuitive interface for building LiveCode's Data Grids
Excel Library- Extends the LiveCode language for controlling MS Excel

teriibi
Posts: 254
Joined: Mon Nov 13, 2017 3:49 pm
Location: Bolivia

Re: DataGrid Helper 2.5 Preview

Post by teriibi » 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 ?
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 :x

Zryip TheSlug
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 142
Joined: Tue Jan 26, 2010 10:15 pm
Contact:

Re: DataGrid Helper 2.5 Preview

Post by Zryip TheSlug » Fri Feb 09, 2018 11:05 pm

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 :x
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.
TheSlug
http://www.aslugontheroad.com - Tutorials, demo stacks and plugins for LiveCode
Data Grid Helper - An intuitive interface for building LiveCode's Data Grids
Excel Library- Extends the LiveCode language for controlling MS Excel

teriibi
Posts: 254
Joined: Mon Nov 13, 2017 3:49 pm
Location: Bolivia

Re: DataGrid Helper 2.5 Preview

Post by teriibi » Sat Feb 10, 2018 12:32 pm

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

Zryip TheSlug
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 142
Joined: Tue Jan 26, 2010 10:15 pm
Contact:

Re: DataGrid Helper 2.5 Preview

Post by Zryip TheSlug » Wed Feb 14, 2018 12:01 am

The DGH 2.5 is still in progress.

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

Image

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.
TheSlug
http://www.aslugontheroad.com - Tutorials, demo stacks and plugins for LiveCode
Data Grid Helper - An intuitive interface for building LiveCode's Data Grids
Excel Library- Extends the LiveCode language for controlling MS Excel

Zryip TheSlug
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 142
Joined: Tue Jan 26, 2010 10:15 pm
Contact:

Re: DataGrid Helper 2.5 Preview

Post by Zryip TheSlug » Wed Feb 14, 2018 12:09 am

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.

Image

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.
TheSlug
http://www.aslugontheroad.com - Tutorials, demo stacks and plugins for LiveCode
Data Grid Helper - An intuitive interface for building LiveCode's Data Grids
Excel Library- Extends the LiveCode language for controlling MS Excel

teriibi
Posts: 254
Joined: Mon Nov 13, 2017 3:49 pm
Location: Bolivia

Re: DataGrid Helper 2.5 Preview

Post by teriibi » Wed Feb 14, 2018 12:15 am

Sure looks really cool, already can see how I could use it... :idea: :wink:
..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) :wink: :idea:
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.

teriibi
Posts: 254
Joined: Mon Nov 13, 2017 3:49 pm
Location: Bolivia

Re: DataGrid Helper 2.5 Preview

Post by teriibi » Wed Feb 14, 2018 12:34 am

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.
:?:

Post Reply

Return to “Data Grid Helper”