Getting Started Coding in Apps Script

Поделиться
HTML-код
  • Опубликовано: 24 ноя 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 6 месяцев назад

    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  13 дней назад

      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 2 месяца назад

      ​@@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

  • @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  13 дней назад

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

  • @crj930
    @crj930 2 месяца назад +1

    didn't work

  • @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.