 |
 | 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 / May 2007Required fields by View
I am designing a form based on a data connection to a SQL table in IP 2003. Field 1, 2 and three are required for the initial submission. But when the form gets emailed to a second person, I change the view. On the second view,I want to make field 4 to be required. However, field 4 being required stops the initial submission. How can you make fields required or not required by view? Hi Art, You can make field 4 to be required in OnSwitchView( ) event in coding. > I am designing a form based on a data connection to a SQL table in IP 2003. > [quoted text clipped - 7 lines] > > How can you make fields required or not required by view? By coding, do you mean custom code in JS or VB? If yes, I am not there yet and do everything through IP wizards > Hi Art, > [quoted text clipped - 11 lines] > > > > How can you make fields required or not required by view? I think you can do this without code, Art. Add a field to your main data source to save the name of a view in. You do not need to put this field on any view; it can remain "invisible". You can then add an action to the same rule you use to switch views and set the value of your invisible field to the name of the view you are switching to. Then use data validation on field 4 to make it required if a certain view name is present in your invisible field. Give it a go and let me know if it works. --- S.Y.M. Wong-A-Ton > By coding, do you mean custom code in JS or VB? > [quoted text clipped - 15 lines] > > > > > > How can you make fields required or not required by view? Thanks - that makes sense. Will give it a try on a new form I am working on I surprise meyself that I have done more than 20 forms in just the past 2 months. > I think you can do this without code, Art. Add a field to your main data > source to save the name of a view in. You do not need to put this field on [quoted text clipped - 26 lines] > > > > > > > > How can you make fields required or not required by view? |
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.