Data Connections

Re: To populate from database

Jollybaba — Wed, 10 Sep 2008 06:04:11 GMT

Hello,

Thank you very much. It got how to use it, and it works fine.

Re: To populate from database

swathip — Wed, 10 Sep 2008 05:01:37 GMT

Use the following expression in Text box as default value.

count(field1[. = "Open"])

Here field1 -> status Column

Hope this helps to you.

Re: To populate from database

Jollybaba — Tue, 09 Sep 2008 08:08:19 GMT

Hi Swathip,

Very glad for the active reply. I think i was not quite clear in my previous reply. I want to know the number of 'Open's in the status column. That number should come in the text box.

Re: To populate from database

swathip — Tue, 09 Sep 2008 07:47:24 GMT

Take a hidden field and increment that field whenever you select 'Open'. Put that value in a text box.

Re: To populate from database

Jollybaba — Tue, 09 Sep 2008 06:23:11 GMT

One more problem, can i fire a query to sql and get the result into a text box. For instance when i select 'Open' in the status column can i get number of 'Open's in status column and get the value into a text box?

Re: To populate from database

Jollybaba — Tue, 09 Sep 2008 06:13:54 GMT

Thanks a lot for the quick response. It worked.

Re: To populate from database

Clay Fox — Tue, 09 Sep 2008 06:02:36 GMT

Put a rule on the dropdown.

Add a set field action.

Use the email with a filter of name = name selected from the dropdown.

To populate from database

Jollybaba — Tue, 09 Sep 2008 04:21:06 GMT

Say these a table with few rows and two columns, like name and email id, which is my secondary data source. The entries of a drop-down list box is the name column. I want to populate a text box with the corresponding emaid id(from the secondary data source) when a certain value is chosen in drop-down box.