Grouped RecordID

Question

Hi all,

I see a lot of people have been requesting this so I thought I'd post this here.

I built a grouped RecordID tool that allows you to create a record ID that uses one or more fields as grouping:

Say you have data like this:

and you want to create a RecordID field, but rather than just counting from 1 to 5, you want to group it by the District field, and reset the count at each change in this field, then you can now use this tool to do exactly that:

Nice and simple but a useful bit of functionality methinks.

Thanks to the handsome and talented @joshuaburkhow for making it look pretty and helping out with some of the testing.

Enjoy.

M.

Grouped Record ID.yxzp

srea541 · Answer

This solution is fantastic - Thank you for sharing!

Qiu · Answer

@mceleavey 
Thank you for this help handy one.
ACE ideas digest of @SeanAdams guided me here. 😁

atcodedog05 · Answer

Hi @Luke_C

Tile tool has a drawback it will always sort the data ascending by unique column 😶 i usually get stuck because of this and end up using multi-row formula to generate group id.