I have a HTML-table in my confirm mail and would like to fill it with data from a grid question in my form. Let's call it MONTH with 31 DAYS with 7 different options. In the form spreadsheet it gets the header name "MONTH [DAY_1]" and "MONTH [DAY_2]" and so on, with the chosen options. If I use ${"MONTH"} I get a long comma separated row like ",OPT_1,,OPT_2,,,OPT_3,,,,OPT_4,,,,OPT_5,OPT_6,,,,,,OTP_7,,,,,,,,,".
Is it possible to pick out the OPT_X? If so what is the correct way to do this?
Hope this can be done! :)
/Jorgen