Re: "I'd thought about using a view to render JSON but we can't as there's no way to make sure each row is followed by ", " apart from the last row. Unless we did an @DBLookup and imploded them?"...
You could create a "$$ViewTemplate" form for the View and hardcode the last element on the form after the "$$ViewBody" field. You would then need to add the "," at the end of each row in the view.
After that, all you need to do is to ignore the last entry in the results returned!
Later
Patrick
P.S. I have never tried using JSON, but the above should work...!
Hi Jake,
Re: "I'd thought about using a view to render JSON but we can't as there's no way to make sure each row is followed by ", " apart from the last row. Unless we did an @DBLookup and imploded them?"...
You could create a "$$ViewTemplate" form for the View and hardcode the last element on the form after the "$$ViewBody" field. You would then need to add the "," at the end of each row in the view.
After that, all you need to do is to ignore the last entry in the results returned!
Later
Patrick
P.S. I have never tried using JSON, but the above should work...!