-
I would just use a substring function and take the last two characters of the date field.
02/06/2008 substring(date, 9, 2)
Or if the date is 2008-02-06 substring(date, 3, 2)
the syntax is for InfoPath rules but would be the same for code. Take the characters from the string starting at position and for x characters. SInce the ...
-
So the form is based on a database connection?
The first user it works fine but the second Outlook recipient it does not.
The second user would need to open the form from the attachment. The view in Outlook would not allow edit. You may need to change your Email submit to attach the form not send the view.
Do they have access to the ...
-
Hey Lee.
InfoPath is particular about it Outlook.
You have verified in Internet Explorer - Internet Options - Programs that Outlook 2003 is the default mail program.
Obviously there is an issue with the local PC, it may require a repair on Office to correct or a reinstall to get the relationship restored.
-
Welcome to the forum.
Give us a breif explanation of what you are trying to do and then we can give you some architecture / layout suggestions.
It sounds like you want to allow users to pick from a list and then display details for their choice.
-
Do you mean records in a repeating group?
Obviously a repeating section can have conditional display that might show a subset of the total records.
You should be able to get a row count or low tech is to add an additional fiels to your record set that you can use to sum.
Do you want to use code or rules?
-
Welcome to the forum.
If you have SharePoint 2003 then why are you concerned about browser compatibility? You need SharePoint 2007 to render a form in a browser anyway. Are you planning on an upgrade in the near future?
I have used the datediff() many times but I am sure there are similar functions in managed code.
Another method is to ...
-
Inorder for your form code to interact with anything outside of InfoPath the form must have full trust. This is a designation as well as the form must actually be installed on the computer. There is documentation on how to do this. The installation does not include the InfoPath application. So the recipient must have InfoPath to open ...
-
SQL Server or SQL Server Express, which is free and you can run on your workstation are similar to Access but are designed for multiple users and have some added features. I am sure you could transition pretty easily.
So you can see all of your fields in Access with 2 decimal places?
You modified your data connection and went through ...
-
HI Scott. Welcome to the wonderful world of InfoPath.
You need to get the template, the .xsn file that the sales man would use to create a new form.
Right click on it and open it in Design mode
Go to tools and data connections.
In the list should be the one that submits to email.
Select it and select modify. It is possible they had a seperate ...
-
Hey there!
Welcome to the forum.
InfoPath was built with a very tight integration with Outlook, since it is bundled with it. In fact you even have to use Outlook 2007 with InfoPath 2007.
You can either use code, but this requires full trust for your form, or a server based solution.
With the Database Accelerator you can have the server send ...