-
I have a secondary data source that retreives the 5 data fields. When I submit the form to the document library the data disappers and it's not saved.
-
I have a connection to a secondary data source and I need to be able to save the data that was retreived from the datasource. I have the output going to the Sharepoint Document Library.
-
Thanks for the advice, is it ok if you can give me a little more information
-
Thanks for the advice but the contact selector is a different animal.
-
Hi Hilary, I understand now. However i'm having a problem with the Create Procedure statement. I created a new test database for this with two columns, 1 is called ID (primary key - autonumber) and the 2nd called TransNumber. The table itself is named "Trans". In order to create the stored procedure, I created a ...
-
Hi Mark! Welcome to the forum!
Unfortunately, there's currently no way of saving a form template as a template part. What I would suggest you do is design a blank template part and copy that table from your form template. Create the same schema, then bind the fields from the table accordingly. That should save you time. At ...
-
I am using the Preview Form function to submit newly created forms as I am still in the process of designing the template. My form options were set to do nothing on version upgrade, could this be my problem?
thanks,
jerri
-
Hopefully your SharePoint list isn't huge -- also I think the data returned from ShP is going to depend on the number of items displayed in the default view. However, you certainly can do this the way you propose -- the drop down control can hold your list of vendors and be bound to the main data source. The repeating table can be bound ...
-
Basically, for the query part, I dont really understand what u mean when u say:
"If you are storing your Ids in SharePoint or SQL, you can always run a query to retrieve the Ids and use a formula like Max(Id field) +1"
Thanks again
Fred
-
Actually, the blog post uses SQL, not SharePoint.
So you created a new data connection to your database -- does it have an ID column? You should set the data connection to query when the form opens. Set a default value on the field in the main data source where you want your ID. The formula for that value should use the max function to get the ...