Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Restart sequence from autonumber based on another field

Topic Labels: Formulas
Solved
Jump to Solution
698 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m trying to automatically name experiments based on the user that performs them. The numbering is sequential. However, I want the numbering to relative to the user.

Here is the formula I’m currently using:

{Initials (from Owner)}&"_"&"EXP"&REPT(
    '0',
    4-LEN(
        {Autonumber}&''
        )
    )&
{Autonumber}

Screen Shot 2020-11-20 at 8.09.23 AM

The issue is, I want that next experiment (MP_EXP0005) to start at MP_EXP0001, rather than 5. Is there a way to do that with a formula?

1 Solution

Accepted Solutions

That’s a little tricky.

You’d probably want to create an automation that automatically triggers a custom JavaScript script, or you could use Integromat for a no-code way of handling that.

However, there is also a workaround that @Justin_Barrett created — it has a few limitations due to Airtable’s built-in limitations, but it should work, too.

All of these options are discussed in this thread:

See Solution in Thread

1 Reply 1

That’s a little tricky.

You’d probably want to create an automation that automatically triggers a custom JavaScript script, or you could use Integromat for a no-code way of handling that.

However, there is also a workaround that @Justin_Barrett created — it has a few limitations due to Airtable’s built-in limitations, but it should work, too.

All of these options are discussed in this thread: