I created a form that when linked with SharePoint should increase the name value by 1 each time. Here is everything I have setup.
1. Autonumber field
a. Rule 1
i. No Condition
ii. Rule Type – Action
iii. Run these actions
1. Query using a data connection
a. Data connection = Received ID
2. Set a fields value
a. Field = Autonumber
b. Value = max(@ID) + 1
3. Submit using a data connection
a. Data connection = SharePoint Library Submit
2. Data Connections
a. ReceivedID
i. Location of SharePoint site is correct
ii. The library is correct
iii. SharePoint list field selection = ID
b. SharePoint Library Submit
i. Document Library is correct
ii. File name:
1. concat(max(@ID) + 1, Consumer_Last_Name, "_", Specialist_Name, "_", "Sensitive")
That is everything I have setup on my form. Here is an example of what I’m getting.
| ID |
Name |
| 59 |
59-… |
| 60 |
59-… |
| 61 |
60-… |
| 62 |
60-… |
| 63 |
60-… |
| 64 |
60-… |
| 65 |
60-… |
| 66 |
60-… |
| 67 |
60-… |
| 68 |
68-… |
| 69 |
69-… |
| 70 |
70-… |
| 71 |
70-… |
| 72 |
70-… |
And now, I made a change to the form published it back out there and the form name reset to 140.
| ID |
Name |
| 2002 |
140-… |
| 2001 |
140-… |
| 2000 |
140-… |
| 1999 |
140-… |
| 1998 |
140-… |
| 1997 |
140-… |
| 1996 |
140-… |
| 1995 |
140-… |
Can anyone help me figure out what I’m missing. I need to get the name field where it is submitting correctly. I need it to be the ID + 1 at the beginning of the name.
Thanks