Skip to main content
Solved

Invoice going up

I

how can i make a field of invoices thats starts from 1000 and goes up?
like
1001
1002
1003?

im kinda stuck, much appriciated! :grinning_face_with_big_eyes:

Best answer by JonathanBowen

Hi @idan_bernard - have a field that is an autonumber:

Then make your primary field a formula and use:

1000 + AutoID

You can hide the AutoID field if you don’t want to see that.

Worth noting that if you delete a record, you also delete the autonumber associated with it, so that won’t then be available:

JB

View original
    Did this topic help you find an answer to your question?

    2 replies

    JonathanBowen
    • JonathanBowen
    • Inspiring
    • 1110 replies
    • Answer
    • May 19, 2019

    Hi @idan_bernard - have a field that is an autonumber:

    Then make your primary field a formula and use:

    1000 + AutoID

    You can hide the AutoID field if you don’t want to see that.

    Worth noting that if you delete a record, you also delete the autonumber associated with it, so that won’t then be available:

    JB

    I
    J
    2 people like this
    • I
      idan_bernard
    • J
      Justin_Barrett
    I
    • idan_bernard
    • Author
    • New Participant
    • 1 reply
    • May 19, 2019
    JonathanBowen wrote:

    Hi @idan_bernard - have a field that is an autonumber:

    Then make your primary field a formula and use:

    1000 + AutoID

    You can hide the AutoID field if you don’t want to see that.

    Worth noting that if you delete a record, you also delete the autonumber associated with it, so that won’t then be available:

    JB


    thank you so much jonathan, is there any chance i can ask you a couple Airtable questions in email or whatsapp?
    i really need to do a small task for a job application it will be so much appriciated.
    thank you so much.

    Reply


    Most helpful members this week

    Terms & Conditions