Re: Add sequential loop numbers that trigger another row in separate column to increase in number by +1
I would like to do what was accomplished on this thread except to add the additional steps of updating another row in another column once the loop reaches a specified number.
Please see the picture for reference on what I would like to accomplish:
Welcome to the Airtable community!
It’s hard to tell the relationship between the two columns, and how grouping should affect the numbers.
Note that the auto-numbering method in the thread you referenced creates a repeating series of numbers based on when the records are created. It is independent of the grouping of records.
That said, if you want a series of numbers to repeat from 1 to 25, you can use the following formula, which is the same as the one you referenced, except it goes to 25.
IF( MOD({Autonumber}, 25 ) = 0,
25,
MOD({Autonumber}, 25 )
)
You can also have a different formula based on the same Autonumber that increases how many multiples of 25 the Autonumber has reached.
IF(MOD({Autonumber}, 5) = 0,
({Autonumber} / 5) - 1,
INT({Autonumber} / 5)
)
Here is a screen shot where the repeat is at 5 instead of 25 so that you can see the change.
Again, this system is based on the creation order of the records (after the autonumber field is created), not record group.
This also might not be quite what you want. If not, could you try posting again with a bit more details and a different screen shot?
So we’re almost there…I need to be able to apply this formula to a specific group of records that share a common link that I apply to a group field. Meaning, that the function starts from 0 with each group field.
Is this possible?
