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

[THOMAS SEBASTIAN]

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 · Accepted solution]

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