D
dawn_at_work
In InfoPath 2003, I am using the count() function on my InfoPath form
(publishes to a SharePoint form Library) that will count how many forms are
in the list and adding one [it looks like this: count(@ID)+1].
The problem is that I want to format the filename with the first letter of
the office chosen in the form (a field in the form--assuming I can use a rule
that if Office=Edmonton the value is ET, etc.) +001. There is a starts-with
function, but I can't get it to work in conjunction with the count function.
Is there a way to make them work...or an easier way to apply the filename so
that it only counts the IDs that start with ET (or which ever applies
depending on the Office field) and then adds 001 when submitting.
Help!
(publishes to a SharePoint form Library) that will count how many forms are
in the list and adding one [it looks like this: count(@ID)+1].
The problem is that I want to format the filename with the first letter of
the office chosen in the form (a field in the form--assuming I can use a rule
that if Office=Edmonton the value is ET, etc.) +001. There is a starts-with
function, but I can't get it to work in conjunction with the count function.
Is there a way to make them work...or an easier way to apply the filename so
that it only counts the IDs that start with ET (or which ever applies
depending on the Office field) and then adds 001 when submitting.
Help!