LiveCode Forums.

Posted: **Fri Sep 30, 2011 6:06 am**

Hi Guys,

I am working on project using table field to display data so I now want to use datagrid instead.
The problem is there are any way to generate dynamically columns of datagrid by specific arrays. For example:
1. I have drop box have 2 options to select: option1,option2
2. I want only 1 datagrid to display records. If user select option1 the columns of datagrid now is ID,Name and Age. Otherwise, datagrid now is ID and Name

Could you guys please give me some solutions with this problems?
So appreciated !

Regards,
Quang

Posted: **Fri Sep 30, 2011 11:45 am**

Hi Quang,

you can show and hide a single column in your datagrid!
So you can use the SAME data, but only show/hide the AGE column.
Maybe this will help you?

Check the DataGrid docs for:
---------------------------------
dgColumnIsVisible [COLUMN]
- Get/set the visibility of the column.
--------------------------------

Get the complete docs as PDF here:
http://lessons.runrev.com/s/lessons/m/datagrid

Best

Klaus

Posted: **Fri Sep 30, 2011 11:50 am**

Hi Klaus,
Thanks so much for your reply.
I just found the ideas but it just only create 1 column.Here is my code:

Code: Select all

 
      put "Test" into tLineArray1[1]
      put "Test1" into tLineArray1[2] 
      repeat for each key tKey in tLineArray1
      set the dgprops ["columns"] of group "List3" to tLineArray1[tKey]      
      end repeat

It's just create column with name "Test1".
Thanks in advance,
Regards,
Quang

Posted: **Fri Sep 30, 2011 12:14 pm**

Hi Quang

please check and read the PDF!
This property needs a CR list for the new columns!

Table properties:
....................
columns
- Line delimited list of columns in your table.
....................
You are overwriting the one and only column in your repeat loop!

Try this:
...
put "Test" & CR & "Test1" into tColumns
set the dgprops ["columns"] of group "List3" to tColumns
...

Best

Klaus

Posted: **Mon Oct 03, 2011 3:20 am**

Dear Klaus,

Thanks you very much ^^. I'm so stupid

Regards,
Quang

LiveCode Forums.

Generate dynamically columns in datagrid

Generate dynamically columns in datagrid

Re: Generate dynamically columns in datagrid

Re: Generate dynamically columns in datagrid

Re: Generate dynamically columns in datagrid

Re: Generate dynamically columns in datagrid