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.
Put a rule on the dropdown.
Add a set field action.
Use the email with a filter of name = name selected from the dropdown.
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?
Hi
Take a hidden field and increment that field whenever you select 'Open'. Put that value in a text box.
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.
Use the following expression in Text box as default value.
count(field1[. = "Open"])
Here field1 -> status Column
Hope this helps to you.
Hello,
Thank you very much. It got how to use it, and it works fine.