What is the appropriate format to store specific JSON formatted query value as a variable using javascript? For example how would I save {{recordset.data[0].value}} as a variable (var newvalue = {{recordset.data[0].value}}). Any ideas or help with this? I am also open for workarounds. I am attempting to do this as a standard HTML document.

Lastly, when will the DISTINCT query functionality be in place for queries? Based on what I have read on the support forum, this feature has been in the works for a year or so. Is it about ready for release now since it is an important query function.

Thanks