Getting Started Coding in Apps Script

แชร์
ฝัง
  • เผยแพร่เมื่อ 28 ธ.ค. 2024

ความคิดเห็น • 24

  • @ttone2330
    @ttone2330 5 หลายเดือนก่อน +3

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

  • @chrisder1814
    @chrisder1814 4 หลายเดือนก่อน

    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  3 หลายเดือนก่อน

      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.

  • @MataSurya-o6c
    @MataSurya-o6c 3 หลายเดือนก่อน

    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  3 หลายเดือนก่อน

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

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

  • @chrisder1814
    @chrisder1814 4 หลายเดือนก่อน

    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  4 หลายเดือนก่อน

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

    • @chrisder1814
      @chrisder1814 4 หลายเดือนก่อน

      @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 4 หลายเดือนก่อน

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

    • @BetterSheets
      @BetterSheets  4 หลายเดือนก่อน

      @@chrisder1814 bettersheets.co/snippets

    • @chrisder1814
      @chrisder1814 4 หลายเดือนก่อน

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

  • @EndroPora
    @EndroPora 5 หลายเดือนก่อน

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

    • @BetterSheets
      @BetterSheets  5 หลายเดือนก่อน

      Sorry what do you mean by reconnect?

  • @AnshulMarele-gbaa
    @AnshulMarele-gbaa 8 หลายเดือนก่อน

    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  หลายเดือนก่อน

      You need to create different workbooks.

  • @RONYAPARICIO-xk4dd
    @RONYAPARICIO-xk4dd 8 หลายเดือนก่อน

    mine doesnt find the formula

    • @BetterSheets
      @BetterSheets  หลายเดือนก่อน

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

  • @crj930
    @crj930 3 หลายเดือนก่อน +1

    didn't work

    • @BetterSheets
      @BetterSheets  3 หลายเดือนก่อน +1

      Did you get an error?

  • @igorsantos07
    @igorsantos07 3 หลายเดือนก่อน

    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  3 หลายเดือนก่อน +1

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