-
So you want the time in your database?
You could possibly set a default in SQL that would enter a time when the row was created if that works.
In InfoPath, if you are going to set the field yourself you can use substring-after(now(), "T") this should get just the time portion for you.
-
Hey Eray.
A SharePoint list or library cannot be queried dynamically.
The data connection will load all data and then you must use a filter to only display what you need.
So I would put the data into a repeating table. Add three fields for name, sdate, edate.
Use conditional formatting on your repeating table which only displays the records ...
-
You could create a custom list with this data but then you have to admin it for changes.
There is a contact selector control in 2007 now.
Or you could use an Active Directory Web Service to ID the current user and lookup their manager from there.
-
I would update the old templat
Add a rule on Open which checks the contents. Select a field that would be blank a new form but not on an existing form. Set the rule field is blank, action display message "do not use this old form, blah blah, etc"
Then the next action is open a form and open up the new form for them, then ...
-
You should be able to setup a data connection via the wizard. Select SharePoint and navigate to your list. Make sure the default view has what you need but it will load the data from that list.
That should be what you need.
-
We store documents in SQL and just view them from SharePoint. This way you can have history and full text search. That may be an option for you.
-
Look into using filters.
When selecting the records to count use the filter button in the lower left to set a filter [customer = 1] you may need to look at the preceding sibling function to count unique customers, etc. It will be a bit complex but can be done.
Search here on preceding or sibling for more examples.
-
A couple different options:
Use two repeating tables back to back.
The first only shows you default rows and does not allow ins and del in the properties.
Place a second repeating table which allows insert and delete but only shows new rows.
Another option would be to turn off the user's ins and del and just use code and your own ...
-
If the email originates from the client there may be a way to set the from within Outlook for the particular emails, but that may be a challenge.
The only other option is to use server-side email. Then you can specify the reply address.
Server-side requires either IFS or webservices like in the Qdabra Database Accelerator Suite ...
-
The only other thing I can think of is that your web server is adding something.
Have you tried a publishing a sample form to the web site and see what happens with it? To see if it is related to the location or the specific form?