-
You just need to add some space. concat("SDLC Project Profile - ", field10, " ", now())
-
No you are following the proper practice.
Are you using a default, a setfield action in rules, or code?
Another test is to create an expression box which just displays now(). See what happens to that.
-
This is in a browser form? No you are using 2003. So I do not think that should make a difference.
Just because it is stored in in SP2003 it stillopens and is rendered locally.
If it is hidden how do you see the value? :)
-
This looks correct...
I am not sure about them being choice columns.
What exactly are the three columns?
WeekNum Start End
Week1 3/31 4/6
Week2 4/7 4/13
Then your filter looks correct ...
-
This type of form is possible. The architecture and method may be a bit different.
The best practice is to use web services to communicate between your InfoPath form and SQL. That was how it was designed. As you have seen, the default, basic database conectivity in InfoPath has some limitations.
If you want, send me an email ...
-
Are these issues present on a brand new form / project or trying to use an exisitng form?
-
Welcome to the forum.
There may be some code here but best practice is to use a web service rather than a stored procedure.
If you would like to see some examples of database interaction via web services send me an email and I could show you.
-
There are multiple ways to architect this kind of "template" functionality where you want to create a new document but use a stock version or a previous version as the template.
You can deffinitly put defaults into a blank form but I am not sure that would do what you wanted.
Often using a backend data source works the best since you ...
-
Hey Tim.
Why don't you attach you xsn to a post and then I can take a look at it.
I am guessing your tomorrow filed should be a date format but I can see if i can get it working.
-
The key is web services.
The basic database connectivity in InfoPath has limitations as you have encountered.
InfoPath was designed to use web services and they give you all of the functionality.
You can both query and submit to multiple tables.
Send me an email and I could show you some examples.