Generate automatic Serial number with Google Apps Script and Google SHEETS

Поділитися
Вставка
  • Опубліковано 30 лис 2024

КОМЕНТАРІ • 15

  • @zodiacmanan
    @zodiacmanan Місяць тому

    This is a fantastic tutorial. I am not a coder, but need to write some code to get simple stuff done in my job. This really helped.

  • @DinoRodriguez
    @DinoRodriguez 2 роки тому +1

    This is an incredible tutorial!!! Thank you! Looking forward to watching the next video with a more advanced code generator 👍🏼 keep up the excellent work, wow.

  • @hahaSaJu
    @hahaSaJu Рік тому

    Thank you! Very helpful

  • @juanguillen3586
    @juanguillen3586 2 роки тому +1

    Very cool stuff. When's the next video in this series?

    • @practicalsheets
      @practicalsheets  2 роки тому

      Hello! In 2 weeks you´ll have the next one. Regards!

  • @robh.1212
    @robh.1212 8 місяців тому +1

    I have a table with hundreds of stock trades. I would like exel to auto generate a new unique ID for each trade as I add it to the table. I would like that ID to stick with the row that contains the trade even when I sort the table by various columns (such as date or name of stock etc.). I can get excel to auto generate a number using concate but that makes the numbers long and awkward. Is there a way to get excel to auto generate a Unique ID for each trade so that I can re-sort by ID and get them back in chronological order?

    • @practicalsheets
      @practicalsheets  8 місяців тому

      Hello!
      I think you are describing exactly what I do in this video
      However I know how to do it in Sheets. Not on Excel
      Kind Regards

  • @lashnimunasinghe4970
    @lashnimunasinghe4970 2 роки тому +1

    hi i need to generate a code with a set of numbers that I need ex. when I type in a 1234 it want to to generate automatically to 20201234 on the same column. how could I do that?

    • @practicalsheets
      @practicalsheets  2 роки тому +1

      Hmmm
      Very interesting
      I´ll address it in a video
      Regards!

    • @lashnimunasinghe4970
      @lashnimunasinghe4970 2 роки тому +1

      @@practicalsheets thank you much appreciated.

    • @SriramaBoddapu
      @SriramaBoddapu 9 місяців тому +1

      Did you make this video?@@practicalsheets

    • @practicalsheets
      @practicalsheets  7 місяців тому

      @@SriramaBoddapu Yes. Here it is. Kind Regards