-
I have a scheduling form where the user will enter in 3 items. The first dropdown has around 140 items. The second around 1800 and the third, 650. The lists are located in SharePoint. At first I created data connections however the customer wanted to see a concatenation of the client code and client name. Since infopath can not read a calculated ...
-
Hi Clay,
Thanks for the answer.
My main reason for using the SharePoint fields is because I need the workflow to change the values so the form can use these values for it's logic (views, data validation, conditional formatting). My understanding is that promoted fields from the form are read-only in SharePoint and can't be ...
-
InfoPath can do a lot but you are right in some areas it is limited.
What I have described is possible. You are right, you cannot submit to multiple seperate tables in InfoPath, however, you can query and submit to related tables as long as they have a one to many relationship.
So you need a main table, and all of your other ...
-
Seems even some of the simplest of things cannot be done in Infopath and I always get redirected to the database accelerator product or a web service which I again have no clue about setting up. I have downloaded ithe accelerator many times and tried to get it working... No luck.
I do have the form connected to the database as ...
-
Ok, I looked up the issue I had remembered with the onload event, you can't switch views. However the work around is to change the default view. Greg explains it here. http://www.infopathdev.com/blogs/greg/archive/2005/06/27/Switch-Views-During-the-OnLoad-Event.aspx
For your second issue you might add this to your logic and look first if it ...
-
OK that helps.
First I would recommend the Database Accelerator product. It would make what you are trying to do, interact with a database, much easier.
Qdabra Database Accelerator Suite Version 2.0 - Developer
There are tutorials available in the files area.
To do this correctly with Access or SQL Express you would need to change ...
-
Hi Clay Fox. I will explain my problem exactly
I have an InfoPath Form that contain field (on main Data Source) named "UserLogin".
On it's OnLoad event I do this code:
function XDocument::OnLoad(eventObj)
{
var objNetwork = new ActiveXObject("WScript.network");
var login=objNetwork.UserName ; ...
-
The form is currently connected to an Access Database. I have a form they fill out then I want either another view or another form where they can query all projects with tools lost or a specific tool lost.
If I use a repeating table for the tools they enter I cannot capture that data to the database, it will only capture one item to the ...
-
I don't think the version upgrade would really affect this. This is a great, out-of-the-box solution, with Outlook.
You should be able to give Domain Users group access to the site or the form library and not have to worry about individual permissions or creating a SharePoint account. You may mean the setting up of alerts ...
-
So you are wanting a text field where users input a comma delimted list of tools that they lost. Correct?
Then in another view or another form they query this data? How is this done? Is the data being stored somewhere or are you merging forms or what? How are all project forms aggregated?
I would either provide a list of tools which ...