Question & Answer > View Question

List grid isn't fill in a form. But it is in the userview...

Confluence User - 15 Mar, 2017

Configured list in the form.

The Value are the same as the label.

Here's the list in the userview:

Here's the list in the form:

Here's what I have modify:

and like I said, my table name is "machine":

**** NEW PICTURES****

Here's my the form and list I use:

here's the date of the form "Gestionnaire des paramètres :

Here's how I set up my list grid to be fill:

here's my list of "Gestionnaire des paramètres" :

list

6

Confluence User •

15 Mar, 2017 •

confluenceUser •

•

confluenceUser •

Hi Jonatan Nadeau

The free GRID tutorial app in Joget Marketplace (https://marketplace.joget.org/jw/web/userview/mp/mpp/_/vad?id=APP_jlearn1) would be useful for you to analyse and learn on how to implement the GRID form elements.

You can view all the forms and list and userview items and see how everything fit together.

Confluence User •

16 Mar, 2017 •

confluenceUser •

•

confluenceUser •

Thank you very much.

Confluence User •

16 Mar, 2017 •

confluenceUser •

•

confluenceUser •

I have read all the documentation and also check how the list grid was set. So what I did is to fill the "load Binder"with JDBC BINDER then did a select. It still not working and I really don't understand why... Thank you.

Confluence User •

16 Mar, 2017 •

confluenceUser •

•

confluenceUser •

Database tables are usually case sensitive. Best you type as follows: "select * from Machine"

Confluence User •

16 Mar, 2017 •

confluenceUser •

1 •

confluenceUser •

Hi Jonatan Nadeau

List grid are used when you want to select from a popup list of items, and after selecting, it populate the list in the form. That is why the list grid has a property field call "Datalist", which you have set to "List-Machine". And the Load and Store Binder should be set to MultiRow Form Binder, to a new form which you need to create for it to store the list records as a child table.

So there are 2 components here: 1) first is the datalist to display a selection list, 2) second is the 2nd form that acts as a child table (with a different table name from the parent form), with a foreign key field that acts a reference from the parent to the child table. This form stores the list records.

Confluence User •

17 Mar, 2017 •

confluenceUser •

•

confluenceUser •

Hi Matthew,

first I decide to try filling the list with a other list " list - Gestsionnaire de paramètres". This list is link to a form called " Gestionnaire des paramètres" ( see new picture in responds).

Now, what I am trying to do is to fill the list grid in the form "Gestionnaire des paramètres liées à machine" with all the data of " Gestionnaire des Paramètres" ( see new picture).

My question is: 1)

Do i need to put every columns of the list in the list grid ? ( see two pictures)

2) I am trying to load the list grid like you said with multirow Form binder which I setup. ( see picture) I tried to do as you say with a parent form, but I don't understand verywell the configuration of it. How am I suppose to say this form will be the child of this other form...

Thank you very much for the time you take for this request. Have a nice day.

1

CSV | Excel | XML | PDF

Your answer

Print

List grid isn't fill in a form. But it is in the userview...

6

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

6.builder-style-2e014304-9902-4865-9286-a3ee2078be58{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-f1f7484a-1ca1-413f-9761-1b35fd4b672f{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

6

Your answer