DataGrid Helper 2.5 Preview
Moderators: heatherlaine, kevinmiller, robinmiller, Zryip TheSlug
-
- VIP Livecode Opensource Backer
- Posts: 163
- Joined: Tue Jan 26, 2010 10:15 pm
- Contact:
DataGrid Helper 2.5 Preview
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
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
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
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
-
- VIP Livecode Opensource Backer
- Posts: 9867
- Joined: Sat Apr 08, 2006 7:05 am
- Location: Los Angeles
- Contact:
Re: DataGrid Helper 2.5 Preview
Nicely done, Zryip. Thanks for posting this.
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn
-
- VIP Livecode Opensource Backer
- Posts: 163
- Joined: Tue Jan 26, 2010 10:15 pm
- Contact:
Re: DataGrid Helper 2.5 Preview
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.
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.
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
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
-
- Posts: 19
- Joined: Thu Sep 04, 2014 3:32 pm
Re: DataGrid Helper 2.5 Preview
Wow, very nice!!
I am very much looking forward to this update
I am very much looking forward to this update
-
- VIP Livecode Opensource Backer
- Posts: 163
- Joined: Tue Jan 26, 2010 10:15 pm
- Contact:
Re: DataGrid Helper 2.5 Preview
Thanks Paul!paulrichards999 wrote: ↑Tue Jan 23, 2018 11:10 amWow, very nice!!
I am very much looking forward to this update
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:
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
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
-
- VIP Livecode Opensource Backer
- Posts: 163
- Joined: Tue Jan 26, 2010 10:15 pm
- Contact:
Re: DataGrid Helper 2.5 Preview
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
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
-
- VIP Livecode Opensource Backer
- Posts: 163
- Joined: Tue Jan 26, 2010 10:15 pm
- Contact:
Re: DataGrid Helper 2.5 Preview
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:
Here is a preview of the result:
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
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
-
- VIP Livecode Opensource Backer
- Posts: 163
- Joined: Tue Jan 26, 2010 10:15 pm
- Contact:
Re: DataGrid Helper 2.5 Preview
Another feature we are working on for the 2.5 version, is a script for finding text inside a datagrid:
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
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
Re: DataGrid Helper 2.5 Preview
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
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
-
- VIP Livecode Opensource Backer
- Posts: 163
- Joined: Tue Jan 26, 2010 10:15 pm
- Contact:
Re: DataGrid Helper 2.5 Preview
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:
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.
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:
Yes DGH can do that for datagrid table and form. And this will be included natively for form in the datagrid 2 control.
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
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
Re: DataGrid Helper 2.5 Preview
Thanks, you made it clear now !
Hope we can get this DG2 ready soon...
Hope we can get this DG2 ready soon...
-
- VIP Livecode Opensource Backer
- Posts: 163
- Joined: Tue Jan 26, 2010 10:15 pm
- Contact:
Re: DataGrid Helper 2.5 Preview
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 "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.
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
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
-
- VIP Livecode Opensource Backer
- Posts: 163
- Joined: Tue Jan 26, 2010 10:15 pm
- Contact:
Re: DataGrid Helper 2.5 Preview
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.
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.
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
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
Re: DataGrid Helper 2.5 Preview
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.
..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.
Re: DataGrid Helper 2.5 Preview
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.
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.