Search results matching tags 'rules' and 'infoPath2010'

Custom Pattern Validation Rule - Unable to use Apostrophes?

Nerge — Thu, 10 Dec 2020 11:27:10 GMT

Hi Everyone, I'm having a problem with a validation rule that we're using on text fields that we're using for email entry on some forms. We're using the following custom pattern to try and ensure people are entering emails in a standard format, if they don't they get the usual red outline/advisory text on the field: [a-zA-Z0-9._%+\-]+@[a-zA-Z0-9.\-]+\.[a-zA-Z]{2,4} The issue we have is this rule can't handle form users who have an apostrophe in their name, they'll get the invalid email text etc. I have tried to add an apostrophe in here but it always shows as an 'Invalid pattern' on the 'Data Entry Pattern' window; there's also no option for apostrophes in the 'Insert a special character' drop-down on the same window. I assume this is because an apostrophe may be some sort of reserved character in InfoPath, is there any way around this without resorting to code etc? Thank you.

Re: Rule for calculated field

jd422 — Fri, 27 Jul 2018 15:49:59 GMT

LOL. It is working now. I must have had some very minor typo or something. After looking at the XSL file associated with the manifest file, I suspected that it should work.

The data field is in the HistoryItems node (the repeating node/section) in the XDocument.DOM. The rule's context is the repeating node and therefore it works as I wanted it. I might say that a person could edit the rule and reference any of the sibling nodes and do something a lot more sophisticated.

Thank you for the reply.

P.S. My apologies for the following rather verbose commentary:

I am especially enjoying working with my InfoPath form. I am using more than 1500 lines of vbScript to manipulate the data and behavior of the work flow.

My form is a request for a new item in our content management system with a workflow that goes from the requestor to Admin and two more levels of approval. It can be rejected at any point in the workflow and go back to the requestor to be restarted.

I use a couple of SharePoint lists for setting some form behavioral parameters and names of approvers and also for some dropdown lists.

By way of the underlying vbScript, the form can be moved/republished at either of two SharePoint libraries (development or production) and the form will automatically know which site it comes from and perform the Save, Email and other such tasks in different ways.

I can open it from the development site or from locally saved exported files (manifest.xsf, template.xml, vbscript.vbs, etc.) for testing and then republish it to the production site when development is complete.

Thank you, again.

Regards, Jim

IP Form, Repeating Table populated with External Data - Trying to add sort /filter capabilities

csigler — Tue, 01 Apr 2014 14:43:21 GMT

Hi. I have created an InfoPath form that has a repeating table inside of a section. The data is pulled from an ETC. I inserted the form into a page and linked the page to an option in my left navigation. I added a button control to the rows of the repeating table so if a user wants to request a change to that record, they click the edit button, I grab the current() info and display on another form view which has matching SharePoint list fields where they can select what the External fields should be changed to. This launches workflow, emails folks, yadda yadda yadda...... Now this list is large but via a web service I have data returned in about 1 second. Not too shabby. My problem is that I have users at different locations that would only want to see the data pertaining to their specific location. I dont want to have to edit the web service and create a filter, then data connection for each location. I have tried to limit the results of the repeating table by adding a dropdown List to the form where a location can be selected. I added a Query rule to the field on change. Then I added a formatting rule to the repeating table so that if my location not = "00", hide the control. Works great.... but I have 12 locations. I then tried to change the formatting rule on the repeating table so that if my dropdown = "00" and by repeating data table not = "00" to hide the control. (I would need this for all 12 locations). As you can see, my rules will step all over each other. Sooooo originally I just wanted to add a button to several of the column headers that would re-sort the list on click but after much searching wasn't able to find anything. I feel like I am over thinking this. Any suggestions? Corrie

Rules, several values, section

Simon Völkert — Wed, 30 Oct 2013 09:25:19 GMT

Good morning,

since a few days, I sit in front of a problem, and although I want to read from a SharePoint table a column where multiple values are stored that are associated to a specific project. I've managed with a list box, but now want to appear sections that are displayed when the name of the sections appear in the list box, without which I should still be assisst the list box also.

Is there a way that I choice the values in a rule for each section, as well as project-based, and then accordingly the portions where the present value for the project is displayed?

Ask for quick response. Thank you

multiple selected list box

Diwash — Tue, 07 May 2013 10:09:21 GMT

how to write a code to deal with multiple selected listbox and update multiple data in database at once? OR, how to make functionality in infopath so that it can send a form multiple times through one submit button and update database? for example: if user checked on 3 checkbox of multiple selection list box then when user click submit then it can submit the form 3 times with 3 different values of checkbox (or, add 3 records in database with every times with 3 different values).

Switching Views without Code

aberya — Thu, 05 Jul 2012 21:21:57 GMT

Hi there

Just wondering if anyone knows if it is possible to write an expression or formula to detect the current view of an InfoPath form, without running code behind?

I have built an infopath form that has three views, Writable, Read Only and Print Views. In the form is a Read Only flag in the schema and we use this control if the form is Read Only or Writeable. We have added a Rule when the form is opened to switch the view to the ReadOnly view when ever the Read Only flag is set. However this has the side effect that when the Print Preview button is clicked in Form Services the Form Load rules execute and if the Read Only flag is set it displays the Read Only view, not the Print View.

The form load rule is basically "If ReadOnly = 1 then Switch View to ReadOnly" so I think I need to get rid of that rule or be able to detect that the form is trying to print.

Does anyone have any suggestions on how to resolve this issue?

Cheers

Alan

Possible to Conditionally Disable Checkbox Based on Current View - without Custom Code?

nkstrou — Wed, 29 Feb 2012 01:11:45 GMT

Hi InfoPathers:

I have 2 views in my InfoPath 2010 filler form, one called Configuration and one called Test Plan. The idea is that a developer fills in the configuration information for a team setup, that causes certain tests to appear on the test plan page, and a tester goes off and runs those tests.

In order to keep the tester from having to flip back and forth between the two views, I've put some repeating tables on the Test Plan view that are bound to the controls entered by the developer on the Configuration view, usually in a repeating table. The idea here is to give the tester the ability to view the configuration information, but not make changes to it.

The vast majority of the controls on the Configuration view are comboboxes, and when I create the corresponding controls on the Test Plan page, I make those textboxes, which I can then set to read-only. However, I have one set of three checkboxes I need to bring over from the Configuration view, and I'm struggling with how to make these read-only. I can set up a formatting rule that evaluates to true every time and then disable the checkbox, but then the checkbox is also disabled on the Configuration view. Not good!

Does anyone know is there's a way I can get the name of the current view without having to resort to custom coding? I do see there are some custom coding options using the CurrentView property, I'd just prefer not to have to deal with custom code if at all possible. Alternately, what about an option that would let me use a different control that I can set to read-only? I did come up with an option that let me use textboxes in lieu of option buttons in a different section of the Test Plan view, and that let me use the read-only property of the textbox. Because I need the possibility of multiple selections, checkboxes or a multi-select list box seem like the best options, but I don't see a way to make either of those read-only aside from using the current view.

Any help greatly appreciated!

nkstrou

Newbie help needed with INFOPATH RULES 2010

rmathaudhu — Thu, 28 Jul 2011 20:44:42 GMT

Hello,

i have 2 infopath forms(Content Type) published to a forms library in Sharepoint 2007.

I want to have it when I check a checkbox on one form that it will take that form and another form that has the same form number as the first and move it into a different "Archive" view.

Right now when I check the box manually on both forms it works. But is there a way for me to configure a rule on the form when I check the box on one it will also do it to the other related form. i tried to set some rules with no success.

if im missing any information please let me know what you need.

thanks again Ravi