-
Yah date picker's cannot be hidden.
I would recomend using two sections, one to handle each of your scenarios. Then use conditional formatting to hide / unhide each section as you need. If they select the optional section and datepicker is blank then hide the 1st section and show the second which does not have the date but the ...
-
I do not believe Access has robust history like SQL Express does. You maybe could create something with SQL triggers.
As you probably know you cannot submit to a seperate table from Infopath with out Web services. With web services it would be pretty easy to keep a audit table up when it was submitted.
Another option is adding the ...
-
A drop down may be a better option. Autocomplete cannot really be controlled or managed.
Autocomplete would present the the textual options, if it is enabled, and after each of the entries had been entered once.
One issue is that Autocomplete is on for all IE and InfoPath fields so after time other entries would polute it and more than ...
-
So you have a web service which requires authentication? Is each user authenticating or you have a service account that is connecting tto the data? Is it an SA account or a domain account?
Or are you asking how to get the username of the User?
-
It shoudl probably be two seperate forms. Otherwise you are going to have trouble merging the online and offline back together, if that is the goal.
Have you looked at offline folders?
Map the network drive and then set it as off-line. When on the network it would use the network copy. When off-line it would still think it was using the ...
-
Hey there.
We typically extract the data to a SQL database with the Database Accelerator Qdabra Database Accelerator Suite Version 2.0 - Developer
Then you can use SQL reports, Excel, or whatever you want to view and report on the data aggregated from all forms.
Otherwise you can merge forms, or promote properties and use ...
-
The issue always comes down to syntax. If it is wrong there is no warning...it just does not work. I would check the xpath to your field. I have spent long hours laboring over the same thing.Sometimes it helps to create a sample form, which is simple, but you can play with the functionality.
I will try to look for a sample form I ...
-
Yes, this is doable, I have done this several times. One example with a HR planning form where managers were identified by their login and then only shown the data of their direct reports.
First you must identify the form user:
Method 1 use the username() function in InfoPath2007 to identify the user.
This leverages out of the box ...
-
Welcome to the forum.
You have primarily two ways of interacting with SQL data in your InfoPath form. Using SQL as the backend for your data and/or interaction with a database has alot of advantages.
1. InfoPath has some built-in database functionality
You can query and submit to one group of related tables in one ...
-
You can send the template.xsn to anyone and all they have to do is first open it in design mode, then they can publish it to their location. A message box opos up alerting them that it is published somewhere else but they just acknowledge this as it opens in design mode.