-
Hi Patrick,
I need a way to track which approver has approved the form on what date. I think part of the answer is above which is why I am replying to this post.
I have two approver fields, but one is hidden unless you check the box labeled "Choose additional approver". There are two values for ...
-
I would not grab the MAX(ID) until submit. Mainly because I can open a request, and I may decide it is not needed. so the user doesn't need the ID until the item is submitted. On submit, grab MAX(ID), set your field values, then submit form.
Another possibility is to do a double submit. I had a similar issue, On form load I ...
-
-
Okay, we have figured it out. Add this to the list of how SharePoint shortens my life expectancy every day I come to work.
SharePoint lists/libraries use 0/1 for yes/no field values.
InfoPath can use False/True -OR- 0/1 for values in boolean data source items and checkbox controls. By default is uses False/True but False is not the ...
-
Hello all,
I have discovered that an extra space is being added in front of a choice when Infopath pushes my concatenated field to sharepoint.
I'm using an IP 2010 filler form published to a MOSS 2007 site.
I have repeating dropdown fields and multi-selection fields setting specific text fields using a concat formula. The text ...
-
First part sounds right, I'm guessing if 2 people open instances of the form but don't submit , when you grab the MAX Row ID it would be the same. Could cause some issues. Making the same number depending on your rules or filenames? That would be on Form Load but OnSubmit maybe grabbing the Max(ID) on submission would minimize the ...
-
I'm currently running on MS Office 2007 and i need to attach the infopath form into the powerpoint.
The issue is when i go Insert Object>Create from file and try to open the infopath form it will show an error " Infopath cannot open the selected form".
Does that means that infopath application is not a application that we can ...
-
There is a checkbox control in my form tied to a boolean field in the main data source that is promoted as an editable yes/no column in the form library.
Scenario:I submit the form to the library with the checkbox not checked (0)I browse to the form library and confirm the column value displays No.
I edit properties of the item, change value to ...
-
Thanks jnava121,
Let me see if I am understanding what you suggested.
On submit, run a rule that compares the number to be set in RqstID field in the new form to see if matches any numbers already in that field in the the list. If it doesn't, submit; if it does match, add another 1 to the ID.
Does that sound about right?
My only ...
-
The Service account is also a domain account, not a local account on the SQL box, does this affect the configuration?