The instruction was brief, clear and accurate. Thank You!
@saperis Жыл бұрын
Glad it was helpful! 😀
@alexshvetz586 күн бұрын
Very well!
@ribierahmadalkeni84535 ай бұрын
Thanks to all apps and services provided by Google but actually I'm still not believe that Google doesn't have the PDF editor app and This is the one of the big problems when I want to add any PDF or ask for a signature or add some information or marked inside the Google drive please add this features because it will keep anyone can use it inside the Google drive easily Thank you for reconsider
@saperis4 ай бұрын
This is my personal KZfaq channel and I'm not Google. 😃
@aakash92172 жыл бұрын
This videos solve my problem thanks you so much 🤩🤩
@dawid_dahl Жыл бұрын
Thank you kindly!
@saperis Жыл бұрын
You're very welcome!
@kb749410 ай бұрын
I enjoyed your clear and concise video - thank you. It got me thinking about manipulating formulas using app scripts. Instead of adding a new formula to a cell, what would I do if a formula already existed in a particular cell and I wanted to update it? For example, if cell B15 contained =masterSheet1!A1 and I wanted to update it using a script to reference the same cell in another sheet, maybe =anotherSheet!A1. How do I search and replace part of the existing formula?
@saperis10 ай бұрын
You can use the getDataSourceFormular method to get a formula from a specific cell. See here: developers.google.com/apps-script/reference/spreadsheet/range#getDataSourceFormula()
@MrChrisgapo2 жыл бұрын
Well explained! thanks a lot!
@saperis2 жыл бұрын
Glad it was helpful! 👍
@MonaAhmednafea8 ай бұрын
Hi thank you for the videos! I have a questions here can I copy data from a spreadsheet to another one with the formulas the data have on the original one?
@saperis8 ай бұрын
You probably would have to do this in two steps: 1. get the data (getDataRange.getValues()) or something similar 2. get the formulas (probably getDataSourceFormulas) developers.google.com/apps-script/reference/spreadsheet/range#getdatasourceformulas
@abdouhk16832 жыл бұрын
شكرا
@hhbbhvvbjhbbyjjАй бұрын
how about if the row changes everytime how can we use it with getlast row
@Leover3782 жыл бұрын
Buen script en pocas líneas y muy funcional 👍
@saperis2 жыл бұрын
Gracias! 😀
@segunlawal7835 Жыл бұрын
Thumbs up for the great job you are doing Saperis. Please is it possible to create multiple menu on google sheet if you want to automate more than one task / command. Also I would like to ask how do you do screen updating a feature in VBA code on Google App Script.
@saperis Жыл бұрын
Check the guides to see how you can have multiple menu items: developers.google.com/apps-script/guides/menus I don't understand your question screen updating a feature in VBA code on Google Apps Script.
@user-df7kn1wt5o5 ай бұрын
hello thank you for this video! Do you have any recommendations if I put a reference from other sheet in the formula? For example =IF(A2>Reference!$B$2,”Yes”,”No”). I keep getting an error results
@saperis5 ай бұрын
I've never tried that so I don't know if it works. But for sure, you would have to use the sheet name in the formula.
@mahendrapal60102 жыл бұрын
Like this video and you help me then you one video make that save functions on multiple row and another sheet with script
@saperis2 жыл бұрын
Thank you for watching the videos.
@haohuynh1808 Жыл бұрын
Hi! Do you know how to set sum of range have formula SUM() in apps script? Thank u so much.
@saperis Жыл бұрын
You should be able to set the SUM formula just like I show in the video.
@user-hg6rv8ij3f9 ай бұрын
It would be helpful if you link the code template in the description that way you can get leads and get paid for your work
@saperis9 ай бұрын
Thanks, but that wasn't my goal with these videos.
@RajaGiri_tvpm2 жыл бұрын
Thank you , How To Execute Google Apps Scripts on Mobiles or Tabs (Android)
@saperis2 жыл бұрын
You can't execute Google Apps Script on a mobile device. You could have a button in a Google Sheets that triggers a script, though. Click on that button and the script should work. See the details here: stackoverflow.com/questions/50894212/getting-google-apps-scripts-to-run-on-mobile
@RajaGiri_tvpm2 жыл бұрын
@@saperis Thank you very much for your kind reply
@somayaahmadi4155 Жыл бұрын
how we are able to make an alert that you have done something with an audio? for example if the quantity and produced boxes be equal make an alert with an audio? can you let me know please?
@saperis Жыл бұрын
There is no way to have a notification that alerts you with sound.
@somayaahmadi4155 Жыл бұрын
thanks for replying back
@jorgepelatos2696 Жыл бұрын
hi, do you know how to calculate the power of a number? in apps script? only with code?
@saperis Жыл бұрын
No, I don't. ☹
@bloodyping9644 Жыл бұрын
to calculate the power of a number in apps script, use Math.pow(number,power), where number is your number to calculate, and power is, obviously the power to be applied to that 1st number. Or... you can also create your own power function, this is one of the many ways to make it works: function calPow(num,pow) { let result = num; if(pow >= 0) for (let i=0; ipow; i--) result = result / num; return result/num; }
@rajdeepsaini2977 Жыл бұрын
Wht u have write that is not clear
@saperis Жыл бұрын
Why is it not clear?
@crouchingchicken00711 ай бұрын
Hi thank you for the videos. I was wondering if you could help me with an apps script formula that can minus end time of a date from start time of that day? I have data logging a Google sheet with date and time columns.
@saperis11 ай бұрын
I don't offer any coding or consulting services. Check this directory of Apps Script freelancers: workspacedevs.com/
@crouchingchicken00711 ай бұрын
@@saperis thank you very much. I appreciate it. Was able to adapt this to my needs with a working Google sheet and pdf exports now. Thank you.
@boredomindex33532 жыл бұрын
It's probably the least practical use of setFormula(). =SUM(B2:B14) will do the job much better, hassle free
@saperis2 жыл бұрын
Thanks for sharing your thoughts.
@newyorkchickenwing Жыл бұрын
@@saperis I understand that the video's not so much about the Sheets formula (which is why you threw any old one in there) as it is about learning how to set ANY Sheets formula with Google Apps Script. This is actually exactly what I needed. Thanks!