Data Driven Forms Parsing JSON Splitter that may help.

[Michael1954]

If you are building forms from the Template this code may help.

Video of Data Driven Forms

https://www.youtube.com/watch?v=8xVtxn3Y6lM

----------------------------------------------------------------------------------------------

function getName(){
// get the value of the JSON data returned by the form
var result = {dialog.Object}.getValue('JSON');
//If there is no data we do not want to loop through "result" so we set our display message and write it to the div with an id result
var txt = 'No extra results';

if(result.length > 1){
//if we have data then we set txt to an empty string.
txt = '';

jQuery.each(jQuery.parseJSON(result), function(k, v) {
// we are building the display string
txt = txt + k + ': is ' + v + '<br>';

});

}

document.getElementById("result").innerHTML = txt;

}
--------------------------------------------------------------------------------------------------------------
The output looks something like this
Field1: value entered by the user
Field2: value entered by the user
......
Fieldn: value entered by the user

Not very pretty but all fields in the JSON are displayed on a new line.

[RichCPT]

Re: Data Driven Forms Parsing JSON Splitter that may help.

Kind of a related question that comes to mind is, "How to setup Selwyn's data driven from to behave like a real LISTBOX or GRID that has multiple rows(records) and fields (columns)?" Trying to dump the data from that type of form is not quite as easy or more precisely getting the ViewBox to store the data changes for posting back to the server isn't so easy.

[Michael1954]

Re: Data Driven Forms Parsing JSON Splitter that may help.

Here the list box is bound to a UX and you can edit the viewbox by clicking on the element you want to edit.

http://www.datadrivensystems.co.uk/alphasnip/ashobiz/

Our form data does not lend itself to being displayed in a table because of the changing structure.

I think your question is interesting for people collecting rows of identical data. Are you hoping to edit the form data after it is collected?

[RichCPT]

Re: Data Driven Forms Parsing JSON Splitter that may help.

I have my form working, but there must be a much easier way of doing it than what I found. Selwyn's video tripped me up a little bit because it treats each row in the viewbox as a field and not a record. So, in your example it would be like trying to send the three properties: SubHeading, Percent, CSSClass for each row in the ViewBox to the server to processed by an xBasic function. It's easy to send the data from the repeating sections (where the data is edited) up to the server. But sending it from just the Viewbox's data array was a challenge. I'd like to know the best way of doing that.

[Michael1954]

Re: Data Driven Forms Parsing JSON Splitter that may help.

The method we follow

Let's talk about a service booking program.


So the services are

1 Beauty
2 Airport pick up
3 Speedboat.

So for these services, we have created some hard-coded fields

Who is requesting the service?
Where will the service be performed?
What date?
What Time?

This is all handled by a mapping to predefined SQL columns.

As we don't understand every question to be asked we have a free form editor.

Beauty extra fields.
Do you want tea or coffee?
Do you want Betty or Marge?

Airport pick up.
Do you require child seats?
How many bags?
Any extra large items?

Speedboat
How many guests?
Will you be fishing?
Number of very large life vests
The number of children life vests?

This text is saved as name value pairs. This is the text I am splitting. It is saved in one column per record.

Example both strings are saved in the same column just different records

Stored
{"Where":"In horizon hotel","DropPlace":"In khalifa mall","Passengers":2}

Displayed
Where: In horizon hotel
DropPlace: In khalifa mall
Passengers: 2

Stored
{"integer":2,"Phone":"085640911080","item":true,"radioButton":"Alpha"}

Displayed
integer:2
Phone:085640911080
item:true
radioButton: Alpha

The code I published splits without you having to know the "Key" so the name in the name value pair is not a problem and you do not have to predefine it in the way you normally define a column in SQL.

[WebDesignShop]

Re: Data Driven Forms Parsing JSON Splitter that may help.

There is a way to do what you want with a normal list control. I developed a component that I'll be demoing at the DevCon. Are you going to be at the DevCon?

[Michael1954]

Re: Data Driven Forms Parsing JSON Splitter that may help.

Yes, will be at Devcon. I am at Heathrow now and flying in a few hours. I will sleep at the Viking tonight

[peteconway]

Re: Data Driven Forms Parsing JSON Splitter that may help.

Look forward to seeing you.

[RichCPT]

Re: Data Driven Forms Parsing JSON Splitter that may help.

I will not be at DevCon this year. (sad face)

Sean, I assume you were talking about Michael's example.

Just for the record, I looked at using the regular LISTBOX with a freeform template layout, but I did not see how I would be able to edit data from both a parent table and a one-to-many child table. The Nested SQL that can be setup for a ViewBox really seemed to fit what I needed. I'd just would like to know:

How to postpone gathering of the ViewBox's underlying data array until a submit button is clicked. At the moment I constantly rebuild the "value" of the viewbox as a JSON string the instant a change occurs from editing data in the ViewBox, like Selwyn's example. I think the solution has to do with calling my attached custom function of the ViewBox with a js "apply()" with a proper "this" value. It would be helpful if Selwyn had an example of collecting row and column values from a ViewBox just at the time of Submit.