RESET RECORD ID BASED ON ROAD

[LorenzTaylor]

Hello -

I wanted to see if there was a way to reset the record ID based on a group of records.

For example, I have 6 records of data which are separated by facility. Please see attached.

My goal is to have a record ID for each line reset if the facility is changed.

[BrandonB · Accepted solution]

Use a Multi Row formula with the create new field and do the following:

Make sure that you check the box to group by the facility field. This is what groups them together

[binuacs · Accepted solution]

@LorenzTaylor another option with tile tool

[LorenzTaylor]

Thanks! both solutions were very helpful.