Increment number by 1

[adam bob]

Hi friends,

I have a problem with getting this InfoPath form to work. Here is the
story behind what I need.

I have a project number and an issue number. A project number is
unique to a project. An issue number is a unique value for an issue of
the project. (1 project can have many issues). So a project number
would look like this; 100. Then an issue number for that project would
look like this; 100.1, or 100.2 for example.

What I need is the issue number to increment every time someone
selects a project number from a form. So if a user selects project
number 100, and the current issue is 100.1, it needs to increment it
by one to 100.2.

This information is read in from a form library within SharePoint. The
structure of the form library looks something like this;

Form - title - project number - more attributes here - issue number

I currently have a data source that points to the Project number using
a dropdown box. Then the issue number is a textbox, which needs to
update automatically once the project number has been selected.

My current formula looks like this; max(@Project_Number[. =
project_no])

This basically gets the project number from the form library as oppose
to getting the incremented issue number.

Please advise, many thanks in advance!!

 

[Clay Fox]

You should be able to use the concatenation function to create the number you
would need. get the project number then concatenate the decimal point and
then 100 + 1 or whatever you need. Although I am not sure a numeric with a
decimal point seperator is best practice.

Have you thought about using a database to store your projects and issues?
I think this would give me more flexibility and could have these numbers
autoassigned and the relationships can be maintained easier.

I would recommend the Database Accelerator. http://www.qdabra.com
There is also a sample solution called project tracker which already has
much of what you are discussing or could provide an example or ideas.

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com