Hello,
I'm trying to create an InfoPath form, to be published to a SharePoint 2013 list, that will allow the ranking of items.
For example, I'm currently looking at opening a bid for different holidays so a user can rank in order of importance to them. I'd like the form to start out by ranking the holidays in numerical order, and then the rankings will auto update as the user changes... so something like this to start:
Rank - Holiday
1 - New Year's Day
2 - Martin Luther King Jr. Day
3 - Memorial Day
4 - July 4th
5 - Labor Day
6 - Thanksgiving
7 - Christmas
So if someone goes in and changes Christmas to rank 1, it'll auto update the others by +1. Or, if they change July 4th to rank 1 it'll update NYD, MLK Day, and Memorial Day, but change nothing with Labor Day, Thanksgiving, or Christmas. I've tried setting this up, but I just cant figure out a way to make it a unique number per holiday. Any help would be greatly appreciated... or anything to point me in the right direction. I'm not an expect with InfoPath, but I'm not entirely new to it either.