max(@ID) based on field

esiege — Fri, 09 Jul 2010 20:53:37 GMT

Hello all,

I'm trying to do something that seems fairly simple, but have been hitting a dead end.

I'm using a data connection to retrieve a field that increments based on a sharepoint list called ID, and this works fine up to this point with the usual max(@ID)+1 for the value.

Now the tricky part I'm running into is I have a dropdown field to select some text called Area, when "Area A" is selected, the ID should only count "Area A" forms on the list.

So far I've set up a rule with conditions "AreaDrowndown(infopath field) = Area(from data connection)", with the action of set field value "IDBox = max(@ID)+1".

This obviously triggers the event at the right time, but then does a full count of all items with any Area.

I was thinking of adding a view as a data connection to filter the data to count, but can't find a way to get this setup. I was also hoping for something like an if statement for the max(@ID) function, but I can't figure out the syntax for that either, it seems to revolve only around conditions.

Thanks for hearing me out! :)

SharePoint Integration

max(@ID) based on field