Skip to main content

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}


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?

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:


Reply


Terms & Conditions