20

Resources Windows 7 OS, InfoPath Designer 2013, Character Map, Notepad Preparation In InfoPath Designer, we want to make sure we can see the panes for Fields and Rules on the left. To show the Fields task pane, click the Show Fields button at the very left of the DATA tab on the ribbon. To show the Rules task pane, click the Manage Rules button at the ...


4

You want to add a conditional formatting rule to the field that you want to hide. The condition should be something like "ComboBox | Contains | Value" and then hide this control. I've created a combo box called field 2 with values Value1 and Value2. I also created a simple text field called field3. Now I want to hide field 3 when "ComboBox | Contains | ...


4

You can created a hidden checkbox field Submitted and check it when the user submits the data. If the field is checked, that section should be read only.


4

Create a new field named "weekday" as type integer (whole number). Create a rule on your date field to set the value of weekday to the following formula: (number(substring(., 9, 2)) + number(number(substring(., 1, 4)) - (floor((14 - number(substring(., 6, 2))) / 12))) + floor(number(number(substring(., 1, 4)) - (floor((14 - number(substring(., 6, 2))) / 12))...


3

At first, you need to install Office Pro Plus 2013 which includes InfoPath Designer 2013 (and InfoPath Filler 2013). For system requirements you'll need at least a 1 GHz processor and 1 GB RAM (32 bit) or 2 GB RAM (64 bit). And of course 3 GB HDD available space. To start develop, there are numerous of guides available, but a good place to start is at ...


3

Assuming is infopath, you can create a new rule in your "RAM" Field. Select the "RAM" Field Go to properties tab > Manage rules On manage rules window, click "New" > "Formating/Format" Check the checkbox, hide this control. Create a new condition for this rule, something like: if "device" field equals to "Desktop" Or >> if "device" field equals to "...


3

You can use a Rule to accomplish what you need using Michael Kay's Double Translate Method. For your field add a Rule of type Action. Use the Set a field's value action Use the current field . as the Field For the value use the following formula: concat(translate(., translate(., "ABCDEFGHIJKLMNOPQRSTUVWXYZ", ""), ""), " ", translate(., translate(., "...


2

I've had this requirement before, and each time I stray away from InfoPath and tell my users the only reasonable way is to use customized SharePoint list forms, edit/display/new. But in InfoPath, you would have to write code-behind in the InfoPath form, making it administrative approved. In the code, you would, upon submission of a document attachment, use ...


2

You can do it with sections and conditional formatting. Add a section and inside the section add the fields that you want to show/hide. Go to Section properties -> Display tab -> Conditional formatting and enter the condition. In your case the condition will based on whether the user has selected Yes or No in the field that contains the answer for the ...


2

This can only be done with code. You'd either need to write it yourself or use a tool called qRules from Qdabra Software. It's like an add-on for InfoPath that provides functionality that is not available out of the box. It's not free, but it costs less than a day's developer time.


2

InfoPath Designer is part of the Office suite. Depending on your Office license it will be included. To install it, just run the Office installer and make sure to select it as a component to be installed on your PC. If you point your favorite search engine towards terms like "Infopath tutorial", you will find many, many materials on getting started.


2

You could replicate this functionality using a field within the form: Some field: SubmitBool. once the form has reached a state that a submission would be appropriate set the SubmitBool value to true, and have rules change behavior once the value has changed. You could also do something along the lines of having a form status field, ie: Status = Open/...


2

I got solution for my question. Open the form in InfoPath designer. Click on the textbox to add a validation rule. Set the condition as Field does not match pattern. Select the custom pattern and enter ([A-Za-z0-9])* in the custom pattern text box. Reference Click Here


2

Add Script Editor Web Part to the form with the following type of jQuery code. Note that you will need to get hold of the correct drop down, so the jQuery selector for the drop-down is just a sample: $("input[title='Computer Type']").on("change", function (e) { if ($(this).val() == "Laptop" || $(this).val() == "Desktop") { $("input[title='RAM']...


2

Create a rule in RAM field. FORMATTING RULE The rule condition should be if Drop Down is equal to scanners OR if Drop Down is Blank. Then check the "Hide this field" option. You may also need to put a clear rule. You will need this if a user, for example, selected laptop then selected a RAM value. Then changed his mind and selected scanners instead. You ...


2

You cannot run a validation rule on a people picker field, however this is what you can do to achieve the same effect: You can create a single line text field. Set the default value of the text box to be populated by the people picker field (Display Name, Username (AccountID), or Account Type). Place the text field into your form Put a formatting rule that ...


2

It's not a clean solution but you can try: Create rule for each drop down that will pass its value to a field. If NA is selected, value should be 0 (zero). So if you have 6 drop downs, you also have 6 fields that will hold these values.


2

What you have mentioned in your question is the right answer to view existing rule actions on form submit . by Going to Data Tab > From the above ribbon , Just click on the Form Submit > and the Rule page will open for only Form Submit But the strange behavior is when you said I get a prompt to create a new one ! where you should get Rule Details dialog ...


2

I too had this claims User Name issue with a people picker. Try adding another field and grab the value of your UserName() fields with a substring function. Here's an example: substring-after(AccountId, "0#.w|domain\") AccountID is a from the people picker. "0#.w|domain\" is the substring you want to remove.


2

What you describe is called "cascading dropdown" and can be done in Infopath by using data connections to the lists involved. If you google the keywords "sharepoint infopath cascading drop down list" you will find many results on how to do this with InfoPath. My concern is that even though SharePoint online currently still supports InfoPath, you can't ...


1

Following Custom Pattern Work for me..... Field Name | does not match pattern | [a-zA-Z]([ ]*[a-zA-Z])*


1

Have you tried this idea? 1) The first thing you need to do is disable the save/save as buttons, and instead of using those on your form, use a custom submit button (no code) by following my blog entry: Auto-Generating Filenames for InfoPath Forms. 2) Then, add a 2nd button that does the same thing, but make it so that this either uses a separate ...


1

Add a field to the main data source for the name - you don't have to display it on the form. Set the submit connection to use this field for the name on submit. In your form load rules, set a rule that sets the new field to the function of now() and add a condition to only set it if the field is blank. That way if the form is new, and the field is blank, ...


1

Use the following expression to get the format like (xxx)-xxx-xxxx concat("(", substring(translate(., "()- ", ""), 1, 3), ")-", substring(translate(., "()- ", ""), 4, 3), "-", substring(translate(., "()- ", ""), 7, 4)) Also watchout for the double quotes as often HTML double quotes are different from which is supported in InfoPath. To be in the safer side, ...


1

To populate the value of people picker field, the DisplayName, AccountId and AccountType should be set with the valid value. DisplayName should be equal to the PreferredName of the user in his user profile AccountId should be equal to domain\user. AccountType should be equal to User or Group. Reference: http://www.wonderlaura.com/Lists/Posts/Post.aspx?ID=...


1

You can use following expression contains(concat(my:field2, ","), concat(my:field1, ",")) I have tested following use cases Field2 = "1,12,123,1234" Field = "1" Field = "12" Field = "123" Field = "1234"


1

Neither SharePoint nor InfoPath support the notion of "business days". In fact, both SharePoint AND InfoPath are not very good at handling dates and differences between dates. Adding "business days" into the mix won't make things easier. You may want to explore a SharePoint Designer workflow to set the dependent dates, or maybe use a jQuery approach (but ...


1

Saddly, InfoPath doesn't allow for much in the way of coded solutions. Especially online. I was able to build a Form with 3 fields: DisableMe a text field to be disabled, DisabledFields a text field to store the disabled field's names and a drop down that triggers the disable process. Since you have many different fields, you can create one text field ...


1

As pointed out by spenvilgenius, the Calculated Value control is the solution to what I was trying to do, which was to reuse much of the original form in a different view but make most of the fields read-only because they will have already been filled out for the particular view. Example in Designer 2013: Example in Filler (Preview): For showing a ...


1

Yes, this is possible. You can add Last three field in section (Containers). After adding fields in section, add rules to this section to display only when login user is inside a SharePoint user group. You can add data connection having SharePoint user group there. And validate the same using rule applied in section. The blog http://blog.symprogress.com/...


Only top voted, non community-wiki answers of a minimum length are eligible