Hi all,

I am building an InfoPath 2013 Form in SharePoint 2013. The first 1/3 of the Form is for end users to submit ideas and suggestions, but the remaining two sections of the Form will be for managers and approvers.

Is there a way I can design the Form so the person making the submission can only see that 1st section of the form and not the rest?

We have a small workflow application we need to develop.  Typically we would give this to our dev team to create a .Net application for.  We want to know if Sharepoint might be suitable instead.  

System

We are using the Sharepoint that comes with our business Office 365 account.  Some connection to our on-premises SQL Server 2012 DB required.

Spec

User 1 fills in New Customer form and submits request.  T

User 2 Can Approve or Deny request.

If request approved, email goes out to new customer with credit application form attached.   Entry is made into our Database with new customer details.

Guidance

Is Sharepoint a good fit for this?  If so, what features of Sharepoint should we being researching?

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.

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!

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

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.

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.

Hi,
I have some tools created using Infopath forms and SharePoint Designer workflows in SharePoint 2010 which I need to migrate to SharePoint Online. I want to know if my tools will retain the full functionality of both the forms and SharePoint Designer workflows after the migration.

I need to build a set of 1 or more InfoPath documents based upon some business criteria going against a related list of recipients of the document.

I have it working using the following function.  Part of the process of building the function is to copy a base (template) XML file down from the document library, turn it into a string with one or more parameters that I insert into that string, and then write the string to content object, upload to the library and then the XML file is available and loads in InfoPath within a browser.

The form has a repeating table which if I populate the form with, the function fails after I take that XML file and use it as the template in my function.

Code follows with abbreviated XML variable as it is too long:

	 function createFile(pParam1, pParam2) {
		var clientContext;
		var oWebsite;
		var oList;
		var fileCreateInfo;
		var fileContent;
		
		var sfileName = "FileNamePrefix_" + pParam1 + "_.xml";
						
		try{
			clientContext = new SP.ClientContext.get_current();
			oWebsite = clientContext.get_web();
			oList = oWebsite.get_lists().getByTitle("RecType SubType");   
			
			var FoundFile = CheckForDoc(sfileName, false);
			var newTemplate = 
			'\n<?xml version="1.0" encoding="utf-8"?><?mso-infoPathSolution name="urn:schemas-microsoft-com:office:infopath:RecType-Audits:-myXSD-2017-07-01T00-23-25" solutionVersion="1.0.0.502" productVersion="16.0.0.0" PIVersion="1.0.0.0" 

Select all Open in new window

…

I have an InfoPath form with a repeating table which has a dropdown.  I can add rows and set different values per row dropdown and save and reload the xml document and the rows and values are there.

I need to be able to do three things with the repeating table:
Read the rows and specifically the value of the dropdown
Add rows and set the value of the dropdown
Modify a row and set its value of the dropdown

I need to do all this within a Nintex Workflow.

Please advise.