Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Restart sequence from autonumber based on another field

Topic Labels: Formulas
Solved
Jump to Solution
1824 1
cancel
Showing results for 
Search instead for 
Did you mean: 
achamess
6 - Interface Innovator
6 - Interface Innovator

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
ScottWorld
18 - Pluto
18 - Pluto

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
ScottWorld
18 - Pluto
18 - Pluto

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: