Req Nested Repeating Table:
View Complete Post
View Complete Post
I'm not sure this is the right forum for this, but here goes:
I'm creating a workflow that kicks off when a user submits an InfoPath form to a form library on a Sharepoint 2007 platform. The workflow should find the manager of the user that submitted the form from SQL and email that person for approval before
the next step is run. Is this possible in Sharepoint 2007 or is using SQL in a workflow only a feature of Sharepoint 2010?
Thanks in advance
I am having an interesting problem with browser based InfoPath forms in SharePoint 2007. For some reason the file attachment control is not working any more. It was working fine in July, but now it will not allow file attachments over a few kb.
I tried a 34KB file and I get the error below, a 2KB file works fine.
Unable to connect to SQL Server session database. The connection string (server='SPDB', database='SharedServices1_DB') was returned by an instance of the IPartitionResolver type 'Microsoft.Office.Server.Administration.SqlSessionStateResolver,
Microsoft.Office.Server, Version=18.104.22.168, Culture=neutral, PublicKeyToken=71e9bce111e9429c'. at System.Web.SessionState.SqlSessionStateStore.ThrowSqlConnectionException(SqlConnection conn, Exception e)
at System.Web.SessionState.SqlSessionStateStore.HandleInsertException(SqlConnection conn, Exception e, Boolean newItem, String id)
at System.Web.SessionState.SqlSessionStateStore.SetAndReleaseItemExclusive(HttpContext context, String id, SessionStateStoreData item, Object lockId, Boolean newItem)
at System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs)
I have created infopath form using Visual Studio 2008
Form have 3 dropdowns and one repeating table which is bound by Datasource ( List from sharepoint ).
whenever i select appropritae values from drop down, Repeating table gets bound as datasource for dropdown and repeating table are same.
I have done conditional formating for repeating table using repeating table properties.
Now i included one submit button and i want when i click submit button it will check DropDown Values and if appropriate record matching these values found it will fill repeating table
How i achive this ? as i dont find how to bind repeating table on submit button.
Please help if anyone have answer.
Thanks and Regards,
I am having a requirement where I need to create an Expense Report Entry form using Infopath 2010.
1) The form would have pre-defined columns/Controls like Exp.Type(drop-down) , Details , Location, Amount , Curruncy, Date etc..
2) User can enter/update as many line items as possible by clicking Add/Update/Delete for the each line items. So basically its like adding the same row dynamically.
3) When User Submits, I need to capture this data and post it to SAP where I am using SAP web Services.
Can you please suggest if this is possible in InfoPath form ?
If Yes, how can I achieve this dynamic line items functionality in InfoPath
And how can I read the data using the code so that I can Post it to the WebService?
My requirement is something like this:
In a Task Approval form, I want to have a view which shows all the rows in a particular SQL table (in a infopath repeating table?). Along with each row, there should also be a button, on clicking which the row should disappear
from the infopath view table. Do you think InfoPath can handle all this? :)
1. How do I add rows to a table dynamically?
2. Per row, how do I create a button dynamically?
3. How do I remove the row from the view when the button is clicked?
What I am trying to do is launch a repeating table based on what the user selects from a drop down box. This is a form I am using for Users to test new applications. If this is the first log in attempt there is no need for a 2nd section but if the user chooses
2 or more I would like the form to automatically launch the next section just like if the user clicked the button to add another repeating section.
Any help is greatly appreciated, thanks in advance.
We are developing a browser-based application with Infopath 2010 forms. We would like to provide buttons that pop up a separate browser window containing an HTML help page, which would be stored in a SharePoint Wiki. I understand it is not possible
What other approaches are there for providing custom help in Infopath?
is it possible to enable a button control based on another button control. so when a user click on a button it enable another button. only if the first button is clicked the second button can be click aswell
I am trying to create infopath 2007 form with the repeating / non repeating fields with in the same table. Basically i have to get the few column values from the sharepoint List and remaining will be free text.
A B C D E F
x x x e a y
x x x s s g
x x x h t w
x x x j h t
X - Values getting from the sharepoint list by using repeating table
remaing values should be not repeating fields and should be text fields.
anyideas on this. please let me know.
I am facing this problem which has become a real pain. Whenever I try to assign permissions or try to perform any operation on an infopath web based form (item). I get the following
"Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.."
Now thanks to this bottleneck, I cant perform any action on the forms thats facing the
mentioned error. My aim is to assign unique permissions on a form item with this error, if I follow the conventional
way (at UI Level) of assigning form permissions i get this error screen and cant move forward.