Getting Started Coding in Apps Script

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

КОМЕНТАРІ • 24

  • @ttone2330
    @ttone2330 4 місяці тому +3

    Thank you for the Basics it really helped me to get started.

  • @chrisder1814
    @chrisder1814 2 місяці тому

    hello and thank you very much for giving me templates
    I still have a few questions, is it impossible to add several APIs to my Google sheets
    this is what I would like to do
    hello would this API allow me to do image processing? do you also use software like our automation codes like make? and finally I wanted to ask you another question regarding APIs and Google sheet, do you use this method?
    could I write to you

    • @BetterSheets
      @BetterSheets  2 місяці тому

      image processing is not that useful in sheets. because images are not in sheets, and so you'd just be using URLs of images online somewhere. and google drive makes it hard to find the actual url of an image saved in a drive folder/file.
      It's not impossible but it's hard.
      and yes you can add several apis to a google sheet.

  • @AnshulMarele-gbaa
    @AnshulMarele-gbaa 7 місяців тому

    How to give Individual Worksheet View, Edit & download Access to Specific Email in one Google Sheet Workbook?
    For example: Sheet1 can be viewed, edited & downloaded by Mr. A email only,
    Sheet2 can be viewed, edited & downloaded by Mr. B email only, likewise

    • @BetterSheets
      @BetterSheets  16 днів тому

      You need to create different workbooks.

  • @MataSurya-o6c
    @MataSurya-o6c 2 місяці тому

    hello brother, is it possible that automatically when a member fills in their date of birth data on the Google form, it will be filled in automatically on the calendar, and there will be a birthday notification every year on the calendar?

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

      you can have any automation run "every day" and check for the birthday. so yes this, what you describe, is possible.

  • @chrisder1814
    @chrisder1814 3 місяці тому

    hello I had an idea of ​​using an API to do automatic image editing
    my first idea is to make a robot that could remove the background from my images and put a white background instead
    a robot that could scan all the images on my site and remove all the backgrounds and change them to white backgrounds
    I thought it would be possible with the canva kind of api
    but first I wanted to know if it is possible to do more advanced stuff with the figma API for my background idea

    • @BetterSheets
      @BetterSheets  3 місяці тому

      Depends on the figma api. If you can do curl commands to figma api you can use apps script.

    • @chrisder1814
      @chrisder1814 3 місяці тому

      @BetterSheets I have a lot of difficulty understanding because I don't know anything about code
      do you use artificial intelligence to code? for app script code?

    • @chrisder1814
      @chrisder1814 3 місяці тому

      ​@@BetterSheets hello, do you know api connector?
      do you use AI for coding?
      can I find "templates" ?

    • @BetterSheets
      @BetterSheets  3 місяці тому

      @@chrisder1814 bettersheets.co/snippets

    • @chrisder1814
      @chrisder1814 3 місяці тому

      ​@@BetterSheetsHello and thank you very much, I visited your property but the problem is that I speak bad English and I am a total beginner, do you have videos in which you show how use your scripts and could I send you an email

  • @maheshshinde8304
    @maheshshinde8304 Рік тому +1

    Hi sir, how to record and run micro sheet 1 and sheet 2 on same time

    • @BetterSheets
      @BetterSheets  Рік тому +1

      Wtite the macro so it does both then run it. Maybe learning Apps Script helps

  • @crj930
    @crj930 2 місяці тому +1

    didn't work

  • @EndroPora
    @EndroPora 4 місяці тому

    how does the script reconnect the google form with the spreadsheet on the original sheet

    • @BetterSheets
      @BetterSheets  4 місяці тому

      Sorry what do you mean by reconnect?

  • @RONYAPARICIO-xk4dd
    @RONYAPARICIO-xk4dd 7 місяців тому

    mine doesnt find the formula

    • @BetterSheets
      @BetterSheets  16 днів тому

      I wish I could help you out more. Do you get any errors?

  • @igorsantos07
    @igorsantos07 2 місяці тому

    Why start the very first example with a chain of 4 methods, when functions most of the time work with arguments instead of grabbing data from fixed sheet cells? You sure you don't want to scare people as the JS bible did? haha

    • @BetterSheets
      @BetterSheets  2 місяці тому +1

      Will keep trying to make it simpler. I got a few ideas for very simple apps script videos in the near future.