Using JSON table to populate UX Component

[PevishaJ]

Hi,

Just wondering if JSON table can be used to populate the UX Component?

Thanks,

Pevisha

[Davidk]

Re: Using JSON table to populate UX Component

Overall, yes.

It's not really a JSON table... rather JSON data. Do you have JSON data in a table? In a file?

[PevishaJ]

Re: Using JSON table to populate UX Component

Hi David,

I just created a JSON file which is something like:

{"Questions":[
{"Questions":"Name"},
{"Questions":"Address"},
{"Questions":"Phone"}
{"Questions":"Email"}
]}

I want to be able to write the data from JSON file to static text in a UX.

Thanks,

Pevisha

[Steve Workings]

Re: Using JSON table to populate UX Component

Pevisha - you've now asked for two different things:

1. Populate a UX component, which suggests populating more than one field/control, and
2. Write to a static text in a UX which suggests putting the values into a single static text control.

Please clarify which you want here?

[PevishaJ]

Re: Using JSON table to populate UX Component

Hi Steve,

Either would work actually. I was thinking of using more than one static text. Each static text corresponding to a question. The reason I chose static text was because I did not want the users to change it but I am assuming I could use other fields/controls and change their editing property.

Pevisha

[Davidk]

Re: Using JSON table to populate UX Component

Hi David,

I just created a JSON file which is something like:

{"Questions":[
{"Questions":"Name"},
{"Questions":"Address"},
{"Questions":"Phone"}
{"Questions":"Email"}
]}

I want to be able to write the data from JSON file to static text in a UX.

Thanks,

Pevisha

I think I understand. You want to take a JSON object and populate a series of Static Text controls. Your JSON object contains the "Labels" of those controls. As if you're building a UX through code... kind of. You will already have the controls in the UX waiting... you're just assigning values.

The attached UX will take your JSON object and populate both Textbox controls and Static Text controls with the values in that object. You're just looping through the JSON.

[PevishaJ]

Re: Using JSON table to populate UX Component

Hi David,

Thank you so much, that is exactly what I was looking for. Just one more question though, is it possible to maintain a separate file containing just the JSON data?

Pevisha

[Davidk]

Re: Using JSON table to populate UX Component

I would store your JSON data as a string in a sql table. You're building variable UX forms, sort of, so you'll need to get that data easily. You'd know what form you want to build, so go after that JSON which is sitting in a record in a sql table.

[PevishaJ]

Re: Using JSON table to populate UX Component

Thanks David,

I will definitely try it that way. :)


Pevisha

[CharlesParker]

Re: Using JSON table to populate UX Component

jeez you could use node.js and build a UX almost instantly....right?