-
Here is some information.
http://www.infopathdev.com/forums/thread/7344.aspx
I would recommend multiple version that use conditional formatting but there is an advanced method.
-
Yah I tried it to and I think the rule on the field is the best solution. If you are having an issue with it executing more than once or early I would put some conditions on the rule to check the new value first or another field tht you can flag once it has been ran once. I often use lots of expresion boxes to pop the field value in between ...
-
I have successfully used rules to query data connections in the form open rules. Typically I believe your field value should be there but I am not sure. Can you put a query rule on a field? So that when the field is updated it would run the query? Can't test at the moment but I believe you might.
-
Hey Paula.
Did you create the form library as you were publishing via InfoPath or are you using an existing form library?
Also what version of InfoPath are you using?
-
http://msdn2.microsoft.com/en-us/library/Bb251021.aspx
Deploy a Fully Trusted Form to a SharePoint Form LibraryOne of the most useful features in Microsoft Office InfoPath 2007 is the ability to publish a form to a document library on a server that is running Microsoft Windows SharePoint Services. By default, forms published to SharePoint ...
-
Are there always the same number of characters or the same number of "-"?
If so you could use the substring length or nested substring-after functions.
There are quite a few examples on the site here.
-
you would just do whatever logic you needed in your form. I would probably reject their input and reset the field when a duplicate is detected but you could also pop an alert and use conditional formating to disable submit.
If you are using the toolbar submit, I would use validation. You could use an existing field or create one just for ...
-
Welcome to the forum.
You would need to query the database with a secondary data connection. I would create a view in SQL that just showed the field you need to check. Then in your form you can have a rule check this data connection if there is a duplicate when data is entered by the user.
If you are working with databases a lot you should ...
-
Welcome to the forum.
You would probably need a secondary (mirror) set of data. The user off-line saves their updates into the secondary data source. You could also just add a copy feature to "backup" their changes into this secondary location, that would make the changes to your form pretty minimal.. When you submit for ...
-
Welcome Tim.
This sounds interesting. Do you have a link to the video ypu can post?