 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / November 2006Populate E-mail Drop Down List based on other Drop Down List
I have a Drop Down List that has two categories: Category 1 and Category 2. I created two data connections, one to connect to Sharepoint Teamsite A's Contacts in, the other to connect to Sharepoint Teamsite B's Contacts. Both contact lists include first, last, full and email addresses. Within InfoPath, would there be a way to create an 'if..then' statement to say if category = Category 1 then use Teamsite A's Contacts, if category = category 2, then use Teamsite B's Contacts? If so, where and how would I do this? The reason I need this is I created a submit button that emails based off of the Contacts so it would be really REALLY helpful for me to be able to use the category to generate the appropriate list of Contacts. Any help would be much appreciated! Thanks! You can write the logic in code to do a check on which category was selected, and based on the category selected, loop through all the contacts in either the first or second secondary data source, and generate a recipients list from that by doing something similar as I did in this article: http://enterprise-solutions.swits.net/infopath2003/article.php?t=generate-string -email-addresses-list-vbscript&c=infopath2003. If it is a drop-down you want to populate with emails of either the first or second secondary data source, then you must create a repeating group in your Main data source, bind the drop-down to it, and then fill the repeating group through code using the logic of which category was selected, performing an XSL transformation on either the first or second secondary data source to conform to the structure of the repeating group in the Main data source and fill it. You may find this article useful: http://enterprise-solutions.swits.net/infopath2003/article.php?t=transform-data- secondary-data-source-xslt&c=infopath2003 --- S.Y.M. Wong-A-Ton > I have a Drop Down List that has two categories: Category 1 and Category 2. > [quoted text clipped - 13 lines] > Any help would be much appreciated! > Thanks! Thank you for the response, but I can't get to either one of the links. > You can write the logic in code to do a check on which category was selected, > and based on the category selected, loop through all the contacts in either [quoted text clipped - 30 lines] > > Any help would be much appreciated! > > Thanks! Yes, my site tends to go down sometimes, and especially when it is too busy. I do not have much control over that, sorry. You may want to try to access it at another time. In the meantime, try the pointers that I gave you. --- S.Y.M. Wong-A-Ton > Thank you for the response, but I can't get to either one of the links. > [quoted text clipped - 32 lines] > > > Any help would be much appreciated! > > > Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.