Table Grid Editor - how to add comma under default value using gd.query.rowX

unknown

Hi,

We'd like to know how to add a default value in a table grid editor that has a comma in its value - using gd.query.rowX.  At the moment the comma will separate the value into different columns, but we want to include it into our default value of one of our columns that has string type.  I tried using ' and " as well as escaping the comma using \ but it doesn't work.

Any suggestion?

francis

There is a workaround which requires some additional configuration, but which might be usefull going forward.

The table grid editor supports to load data using a dyamic query
https://wiki.idalko.com/display/TGPD/gd.query

 

This query can retrieve its data from a driving table
https://wiki.idalko.com/display/TGPD/Driving+Tables

 

So the workaround for this request is

 

a) setup a driving table
b) enter all static data into the driving table
c) replace the static data in your grid configuration with a dynamic query using gd.query

 

Hope this helps,

 

Francis