InfoPath Help

Hi experts,

My first question in a very long time. It's good to be back - hope you can help me out.

I'm building forms and workflows using SharePoint 2013 and Infopath 2013. The problem we have is creating repeating sections on Infopath.

Scenario:
•      We record Budget requests so we have a SharePoint list for these requests.
•      The list captures fields like request title, estimated expenditure, scope etc. For example: Title = “Furniture Upgrade”, Expenditure = “$120k”, Scope = “Head Office Block A”.
•      Our Infopath form for these basic fields work.
•      But the form also needs a repeating section for multiple Suppliers related to this budget request, for example: Supplier Name, Item Desc, Quantity, Cost.

Problem:
•      We can’t find the usual option to insert a repeatable section.

I understand that this might work if a forms library is used but for reporting reasons, we can't go the forms library route.

Been over this and re-created multiple times but just can't seem to get the option that was always there.

Advice will be appreciated.

Thanks a million

0 Comments

Introduction to Web Design

LVL 12

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

Question by

mounty95

3d agoSolved

InfoPath Form Not Returning Records

I have an InfoPath form connected to a SQL database. I have two fields in the Query window for the user to choose from in retrieving records. Previously I had three fields, but it was decided that the user did not ever query on the third field. When I try and query with the new form on just the two fields, I get an error stating that there are no records. I know that there is a record based on those 2 fields. When I go back and use an older version of the InfoPath form and enter just the two fields, the record is returned.

What have I not done properly in modifying the form to only have the two fields to query on?

Any and all help would be greatly appreciated.

3 Comments

SharePoint column, type=calculation, formula to assign values based on a column with check boxes.
While in the formula box, I do not see the column name to be inserted. Is that because the column has checkboxes? So I can add the column name manually, but how do I add the column name & checkbox name.
All I am trying to do is get a sum based on how many checkboxes are checked. one of the check boxes is worth 9 points, the others are worth 3 points. The column name is Risk. I was trying to have it max out at 9 points. so the first if was going to sum just the first checkbox if true, or sum the other 3 for a total of 0-9.

=if(checkbox1=true,9,sum(if(checkbox2=true,3,0),if(checkbox3=true,3,0),if(checkbox4=true,3,0)))
or 
=if([checkbox1],9,if([checkbox2,3,if(checkbox3,3,0)),0)
or
=sumif([checkbox1],9,sumif([checkbox2],3,....

Open in new window

Using info-path with a SharePoint list. It does not allow you to set a name to each checkbox. Looks like it defaults to "value"?
So i tried using the title of the check box, and tried using checkbox1 ....

Thanks in advance,
Jim

2 Comments

Hi,

How can I automatically retrieve the Manager email address in an text field in InfoPath 2013?

I tried to return the Manager properties in my InfoPath list form using the UserProfileService.
I get an i:0#.f|membership|.........@iteenv.com in the Manager email address text field.
I only want to display the email address. How can I fix this?

2 Comments

Question by

Taras

2018-10-17Solved

Infopath option button check if is selected

On Microsoft InfoPath 2010 form I have option button optButSelectColour
Option have two colors Black and White.
On save button I want to check if user selected any option and warn user to select one if not, it means one option has to be selected.

Option button has value 1 for Black and 2 for White I assume that unselected value is 0.
Boxes : this button is selected by default is empty on property for this option button and box Validation Cannot be blank Is empty too.
I assume that I have to add new rule not sure where and what it should say.

InfoPath

2 Comments

Question by

Sam Ben

2018-10-05

InfoPath Status Update Rule

I created a form in InfoPath which has a status dropdown field. The dropdown options are: Cancelled, Draft, Submitted, Pending. The default value for this field is Draft. I wanted to create a rule so that when a user clicks on the submit button, the status is updated from "Draft" to "Submitted". Is this possible?

5 Comments

Question by

iteenv

2018-09-21Private

Infopath 2013/ Sharepoint online

Hi,

Can you please assist me.

I have designed a Leave Request form in InfoPath 2013.
I want to disable dates (holiday dates) in the Datepicker control.
I also have 2 time fields (Start and End time).
How can I calculate the time difference between these 2 fields?

4 Comments

I have a multi view InfoPath form associated with a SharePoint custom list. The form basically has four tabs at the top where clicking each one switches the form view. The first tab is set as the default view in InfoPath. The problem comes when you're on let's say the forth tab and click on the SharePoint Edit icon the page refreshes to put you in edit mode but the InfoPath form defaults back to the first view. I have to click back on the tab I was on to make the change.

Is there a way to have the InfoPath form not lose its current view when going into Edit mode?

Thanks for the help!

3 Comments

InfoPath 2010 form submission is not saving to sharepoint 2010 site, and end user has no errors upon submission. The .xml file does not get saved to sharepoint, how do you troubleshoot this? I figured it was something like incorrect permissions to a site/library for the end user to save their files. But I check an Identical user permission with someone that is able to submit and view their documents. The user that does not work has identical permissions. Its very strange, and there are no reported errors from the user...

6 Comments

Infopath Forms need to change the form's approval status in bulk (Multiple forms, on Sharepoint 2010 site.

4 Comments

Exploring SQL Server 2016: Fundamentals

LVL 12

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

Question by

Edna Dlg

2018-06-26

Condition for drop down

I have an InfoPath form that I need to validate that when they enter authorize amount in two different text boxes a dropdown will change base on the criteria sample dropwow = Level1 Authorization amount < or = USD 25MM or Authorization box 2 < or = USD 15MM
Level 2 Authorization amount < or = USD 100MM or Authorization box 2 < or = USD 50MM
Level 3 Authorization Amount < or = USD 200MM or Authorization box 2 < or = USD 100MM

Can someone help me

InfoPath

0 Comments

Hello I am in search of a solution in SharePoint 2013 using javascript or a 2010 workflow,

that calculates total time to resolve a help desk ticket during business hours 9 - 5, minus weekends and holidays and minus anytime clock was stopped, for example time that would not be counted against a technician because customer was unreachable.

Additional details: If a technician places a ticket in hold status, time should not be counted against time to resolve.

thanks,

Dee

1 Comment

Need to pull a user environment variable from the system the form is opened on, specifically username and use it as a value for a field.
It's a stand alone form opened with InfoPath on the local machine, no SharePoint or other solutions involved.

So far all my searches have come up empty.
I'm thinking I may need to add some VB code?

I know InfoPath has a username function however I need to stop using domain level authentication on the form.
And from what I've discovered that only works with domain level authentication

2 Comments

I originally built an InfoPath form with repeating tables for Employee Expenses, which works great, but this doesn't work on mobile. (We want to be able to use on mobile and take pictures of receipts). So I started over and I've built a Powerapp for employee expenses, and the data goes back to two SharePoint lists. One list is Expenses, which is the employee name, dates, status, etc. The other list is LineItems, which is each expense detail, which is then a Related Items web part on the default display form for the Expenses list.

I have searched everywhere for a solution that will allow me to have a field in the Parent list (Expenses) that will show a grand total of all of the related expense items (Line Items list). I need this to be a field to trigger an email (using Microsoft Flow) in the event the Expense total is more than $1,000.

0 Comments

I have a personal MS Access 2010 database that contains a user table (approx 900 people) that I populate by pulling user data from AD. It also contains asset data (mainly IT equipment ~ 7500 assets +/-).
I would like to be able to provide users with a form that they can review the assets that are currently assigned to them, or located in their current office / workspace. (Standard office equipment such as dock, monitor, printer & scanners is assigned to the workspace & does not move with users, user usually has a laptop & cell phone assigned to them)

I would like to initiate the review, by an email or other trigger. The user would view the assets and either confirm or correct the asset ID for each item. Perhaps by scanning the items asset tag barcode or checking a checkbox on the form by each barcode. Any user corrections would be accumuilated in a temp table so they could be validated and pushed to the source tables as updates.

I am not sure what the best method is: Infopath form, Outlook Form, etc.
I am looking for suggestions and an outline of the implementation steps.
Thanks for any suggestions.

Mike

10 Comments

Hi All,

I am trying to add Javascript or JQuery in my Infopath form. I am looking for a workaround without any custom code. How can we refer a javascript file to an Infopath form.

I want to extend the tool tip duration in my form and I tried doing with XML as a secondary data source but it doesn't read my script or css file.

Any suggestions would be appreciable. Hoping for a reply soon.

3 Comments

We have a form set up with Sharepoint 2013 and InfoPath 2010. We also have Oracle 12..
What is the best way to automatically get the information into an Oracle table on a periodic basis (nightly) or to have the ability of Oracle to link to it?

The catch is we are in a corporate environment and do not have access to the Sharepoint server, SHarepoint Designer or Internet Information Services.

Jerry

2 Comments

Question by

Mary Jane Watson

2018-03-22Solved

How to configure Infopath on SP 2016

How to configure Infopath on SP 2016. I used a guide for SP 2013 but it guides me to do the following:

To activate the SharePoint Server Enterprise Site Collection feature, go to Site Setting --> under Site Collection Administration, select Site Collection Feature --> Active SharePoint Server Enterprise Site Collection features (DONE)
Then,
Make sure States Service is started. Go to Central Administration --> click Application Management --> under Service Application section --> click Manage Service Application and If you don’t see State Service in the list, go to Central Admin --> click Configuration Wizard --> click Launch the Farm Configuration Wizard--> click Start the Wizard --> Select State Service and click OK
But this SP has not such a thing as Central Administration.

4 Comments

Question by

Jen T

2018-03-06Solved

Modify form in SharePoint

hi all,

I hope someone can help / show me where to look.
We have a list (let's say a To-Do list for example), and when someone clicks "New" a form pops up and people enter details, hit save and it gets added to the log.
The person who made the form is away at the moment and we want to modify the form. I'm not sure if it was built on InfoPath, Excel (is that possible), etc.

My question is: how can I find where this form resides and edit it? We need to add some more fields but I've looked around the site (even doing a search for .xsn extensions) and googled away but no luck. I've looked in each document and list library but can't find it. There has to be a way? The drop downs in the form I can modify / add things as they're just in the list, but the form itself - I'm at a loss. I hope someone can point me in the right direction.

Thank you in advance.

3 Comments

Become a CompTIA Certified Healthcare IT Tech

LVL 12

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

I have an InfoPath form implemented on a SharePoint List in SHarePoint Online. How do I print out the InfoPath form.

1 Comment

We've been tasked with a project. The idea is to create some forms, ideally web based, where users can input data that is then stored in our sql server and the form sent on to someone else for approval. (In simple terms).

My idea is to use sql server, SharePoint and InfoPath. Does that seem like a viable solution and does anyone have any prior experience or good material they could share?

1 Comment

Question by

Candice Grayton

2018-02-12

Infopath Error

Hello, I'm getting an error message from Sharepoint that states "Sorry, you don't have a license to use InfoPath Services". We were under the impression that External users inherit the use rights of the SharePoint Online customer who is inviting them to collaborate. Does anyone know why I would receive this message if the external user inherits rights?

2 Comments

LVL 3

Question by

Christopher Gore

2018-02-12Solved

Copying and Passing Values in SharePoint 2013 Workflow - Javascript?

I had this question after viewing Extracting text from a lookup field in a SharePoint 2013 workflow.

My issue is that I have three lookups. They are creating a cascading drop down. The problem is, to make the Cascading Drop Down work, I have to add the ID of the first list. So even though the Display on my form does show the Titles the value that is passed is an integer. Any thoughts on how to capture the text values rather than the underlying ID values? I am also using an InfoPath form for my form.

-- No responses so I will clarify for simplicity.
- Lookup 1 (ID and Title)
- Lookup 2 (ID, Title, Title from Lookup 1)
- Lookup 3 (ID, Title and Title from Lookup 2)

This works find for three drop downs on my form. The issue is when the record is saved, the value (ID Integer) of each lookup is saved rather than the DisplayName. I'm trying to capture the DisplayName so I can pass it to another list. I know how to pass the field values, but again, I'm not looking for the ID value, I want to DisplayName value. I have seen it done with standard forms in SharePoint Designer using Javascript, but I am using Infopath Custom forms. You will see from the image that where EIS Part is the selector. The field I want to fill is EIS Part A. Instead of getting the longer text in EIS Part to display in EIS Part A, it shows the ID which is 2.

2 Comments

I am trying to have outside users be able to view, and fill out (edit) a form / list made in infopath, and submit / save to the site list columns.I am using Office 365 (SharePoint Online), and have an InfoPath browser enabled form made from an edited custom SharePoint list on our site. When users 'outside of the organization' try to use it, they receive an error message: "Sorry, you do not have a License to use InfoPath form services, Please contact your help desk" - this is even logging in with Enterprise 3 accounts that have a license included. It seems only users within the organization are able to view it, even though my understanding is browser enabled forms should allow other invited users to fill out and submit. I have activated the SharePoint Server Enterprise Site Collection feature, and believe the permissions are set correctly.

Thanks for your time.

2 Comments

Hello!

When I am querying the soap service in infopath, I have a crash error. Can someone explain what is happening?

System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.1.10.70:8080 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception) --- End of inner exception stack trace --- at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context) at System.Net.HttpWebRequest.GetRequestStream() at Micr...
...osoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.CreateSoapRequestSyncInternal(XmlDocument soapRequestXml, String soapRequestString, Uri serviceUrl, String soapActionOriginalString, Int64 timeOutMillisec, DataAdapterCredentials credentials) at Microsoft.Office.InfoPath.Server.SolutionLifetime.WebServiceHelper.CreateSoapRequestSync(XmlDocument soapRequest, Uri serviceUrl, Uri soapAction, Int64 timeOutMillisec, DataAdapterCredentials credentials) at …

0 Comments

InfoPath

Related Topics

InfoPath

Related Topics