-
Well the one issue is the 4000 records. You should probably look at switching to web services so you can just use a data connection of 4000 for the first drop down field. then query the specific record in the drop down so that you are not sorting through 4000 records in the form.
So you are building another table in your form to collect the ...
-
When selecting a field in Formula Builder there will be a button in the lower left of the window.
-
How are you submitting to the database and why does it reset after you submit? typically on a submit the values would not be changed.
Is this formula a default? You may have better luck using a rule on the drop down field to set the values.
Where do you pick the second crew values? A screen shot might help or if you want to ...
-
Hey Kon.
What is ID_1 is it a unique for each form or a unique for records within the form?
Can you give an example?
If it is just a numeric then you should be able to increment it but the issue is always maintaining uniqueness with multiple form users.
-
We have a couple people with IFS experience if you need help right away.
You can purchase a support credit here. http://www.qdabra.com/products_all.asp?cat=12
-
That looks right, from your screen shot.
You would check hide control. It is hard to see your comparisons, you may need to reverse them to hide everything but what matches your criteria.
Hide just hides the row where your conditions are true, not all rows or the whole control. You can also try adding a shading rather than hide to test, ...
-
Hi Mike and welcome to the forum.
Once you have your data source with all of the particular attributes setup, which I would recommend a Database table probably, since your inventory will change.
Type Model Motor Suspension Trim Rims Stereo etc...
Truck F150 ...
-
Hi There and Welcome.
What version of InfoPath are you using.
Your form should have a submit data connection to save to a file location and to email the form. These should both occur within the same submit process to keep consistentcy. Do you have a network location you are publishing this to?
The submit to file would also name each copy ...
-
I have not tried using search or versioning with a browser based form.
I am not sure why it would work any differently. I had assumed you had already verified this issue.
-
In IFS this would be in the email setup for SharePoint. With browser forms the email is generated by the server. However it may not be able to be modified from there either. There may be some way to use a redirection and a forward which would have the logic to change the from address.