Thank you for making this video. But I wanna ask you something, sir. If I want to put one cell as a trigger to run the script, are the script will be the same?
Good trick. Thanks a lot. It solved my age old problem with mobile devices. Just a small suggestion. If possible, try to squeeze the videos. The main content of this video is very less.
Please post More videos google apps script on mobile most of us not have system, I tried as per your this video My script , but it works when other sheets tap Thank you for you video
Long Story short summary: - Buttons are useless on mobile because Googles Implementation is dumb - You need to trigger a function that runs every time when anywhere something is changing "Thanks" Google ...
Hi, is it possible to keep the button image on the cell and allow the mobile operation to happen as you have shown. Just so that the script can be used both on laptop and mobile?
Great video sir. I have made such script and it runs good on mobile until I share it to another user. They cannot run it, eventhough I have made it 'anyone can edit'. Please help! Thanks you
You mean only run the code if a certain cell is edited? By default onEdit runs when anything is edited, but you can include if statements to change what onEdit actually does when different cells are edited
Thank you for making this video. But I wanna ask you something, sir. If I want delete the particular group of cell with the help of one cell as trigger to run the script, what i need to write. Please help in this regard. Thanks in advance
if you want to do based on a specific cell I would do this: function onEdit (e){ var mySheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("name of the TAB were you want the script to act if the cell get changed"); if(e.range.getA1Notation() == "A1" ) { NameOfTheScriptYouWantToRUNwhenTheCELLChanges(); }} // A1 above is the cell that will triger the onEdit to work... You can even add a CheckBox just to have the ability to change it on your mobile app
Hey, thanks for the tutorial but when I tried onEdit function just to enter hello in cell it works fine but when I'm trying to get data from a rest API it's not working. I don't understand what is happening.
please can you do me a video, i created a delete button. it run on a computer but is not running on a phone. i used drawing shape to create the delete button. but is not functioning on the phone
@@apocalypticbean DUM DUM is A GENIUS ! .....These ... "curly baraces { } " .... saved my life, ....Thanks a Lot Dear, ................................ else(onEdit="fuckedme") ..........😀
@@AutomationMadeEasy hey, i tried this but theres this error notivication : TypeError: Cannot read property 'range' of undefined, can you help me please
Thank you! How can i create a cycle? For example, when a function is to write a certain sentence, then it must be erased for a while, and later rewrite the same sentence again, and all this in a finite cycle. Help me please.
Hello and thanks for the tutorial Is this still working? I tested onEdit function and it works on desktop, but not on mobile when editing or switching cells
Button can not be executed from mobile phone, but onEdit could. Hide Formula in Google Sheets - Part 4: Use More Than One onEdit(e) ruclips.net/video/_zWxWrrKT2Q/видео.html
Im want to navigate from a index menu: So I copied this code from macro to navigate: the "test" works on mobile, but the "get sheet by name" works on pc but not mobile. Am I doing something wrong? Here is the code: function onEdit(e) { //SpreadsheetApp.getActiveSheet().getRange("B2").setValue("") //SpreadsheetApp.getActiveSheet().getRange("B2").setValue("testing")
var spreadsheet = SpreadsheetApp.getActive(); spreadsheet.getRange('D11').activate(); spreadsheet.setActiveSheet(spreadsheet.getSheetByName('W_Jan'), true);
Thank you for making this video. But I wanna ask you something, sir. If I want to put one cell as a trigger to run the script, are the script will be the same?
Good trick. Thanks a lot. It solved my age old problem with mobile devices.
Just a small suggestion. If possible, try to squeeze the videos. The main content of this video is very less.
Thanks.noted
Please post More videos google apps script on mobile most of us not have system,
I tried as per your this video
My script , but it works when other sheets tap
Thank you for you video
Great straight forward solution! Thanks! But how do you have so many unread messages? 🥴 0:54
thank u
Thank you for providing such a nice solution to run a script in a Google Sheet on the mobile handset 👌👍
Glad you like it
Sir make a video on how to get table data from webpage using VBA
How would I use google scripts on Mobile to just go to a specific Sheet? I've tried a few ways and it only works online and not in the app/mobile.
Long Story short summary:
- Buttons are useless on mobile because Googles Implementation is dumb
- You need to trigger a function that runs every time when anywhere something is changing
"Thanks" Google ...
its helpful, but im wondering how can i call my custom function from onedit?
function onEdit(e){
customfunction()
}
Thank you very much!, This video was very useful :)
Glad to hear that!
Hi, is it possible to keep the button image on the cell and allow the mobile operation to happen as you have shown. Just so that the script can be used both on laptop and mobile?
Great video sir. I have made such script and it runs good on mobile until I share it to another user. They cannot run it, eventhough I have made it 'anyone can edit'. Please help! Thanks you
Let me check
Is it possible to assign the onEdit function to a specific cell?
You mean only run the code if a certain cell is edited? By default onEdit runs when anything is edited, but you can include if statements to change what onEdit actually does when different cells are edited
function onEdit(e) {
if (e.range.getA1Notation() == 'A2')
//remaining code
}
}
@@AutomationMadeEasy Thank you!
hi thanks i tried to add 2 buttons onEdit(e) and on onEdit (c) but it fail so how can i use more the one button for 2 actions
May I know how will I be able to use the button when I'm on mobile?
Thanks!
Button does not work on hand held devices becuse of which I have suggested the work around.
Thank you for making this video. But I wanna ask you something, sir. If I want delete the particular group of cell with the help of one cell as trigger to run the script, what i need to write. Please help in this regard.
Thanks in advance
if you want to do based on a specific cell I would do this:
function onEdit (e){
var mySheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("name of the TAB were you want the script to act if the cell get changed");
if(e.range.getA1Notation() == "A1" ) {
NameOfTheScriptYouWantToRUNwhenTheCELLChanges();
}}
// A1 above is the cell that will triger the onEdit to work... You can even add a CheckBox just to have the ability to change it on your mobile app
Hey, thanks for the tutorial but when I tried onEdit function just to enter hello in cell it works fine but when I'm trying to get data from a rest API it's not working. I don't understand what is happening.
Very very nice
Thanks a lot
please can you do me a video, i created a delete button. it run on a computer but is not running on a phone.
i used drawing shape to create the delete button. but is not functioning on the phone
button wont work on mobile or tab hence i have provided a woraround
💔🤦♀️🤦♀️🤦♀️
The company is asking me to develop a button that will work on the phone…..💔💔🤦♀️
Thank You. Could you tell me how to open a file using google apps script.
you mean read a file through google app script?
What If I want to use button on mobile device as well????
does not work
@@AutomationMadeEasy okay thanks
what's good in it?
we don't need to trigger button on every edit.. is there any way to trigger this only on A2 cell ?
function onEdit(e) {
if (e.range.getA1Notation() == 'A2')
//remaining code
}
}
@@AutomationMadeEasy yes thanks. I have found that.. ;)
@@AutomationMadeEasy Thank you this code is good for one function, but what if there are two functions that need to be run?
@@RA-zs1el enclose it in curly brackets { }
@@apocalypticbean DUM DUM is A GENIUS ! .....These ... "curly baraces { } " .... saved my life, ....Thanks a Lot Dear, ................................ else(onEdit="fuckedme") ..........😀
What if you don't want it running every time you edit anything?
we can restrict it execute only after you edit a specific cell.
@@AutomationMadeEasy perfect! What's the code for that?
Assuming A1 is the cell:
function onEdit(e) {
if (e.range.getA1Notation() == 'A1')
//remaining code
}
}
@@AutomationMadeEasy hey, i tried this but theres this error notivication : TypeError: Cannot read property 'range' of undefined, can you help me please
Thank you! How can i create a cycle? For example, when a function is to write a certain sentence, then it must be erased for a while, and later rewrite the same sentence again, and all this in a finite cycle. Help me please.
need to understand the entire scenario to suggest a solution.
Thank u very much bro.
Your welcome
Hello and thanks for the tutorial
Is this still working? I tested onEdit function and it works on desktop, but not on mobile when editing or switching cells
yes, I still have the same sheet which is working
@@AutomationMadeEasy Oh thanks! I had a code error retrieving my active sheet. Now it is working
great..
Procuro algo para navegação entre abas (Menu) ?.
how make it work in script that saves a pdf into specific folder (getfolderbyid? its says no permission
refer below tutorial:
ruclips.net/video/dknSPPg7LR0/видео.html
Can this script be running on iphone... I did and its runs good on android but not iphone
the demo i showed in the tutorial was on iphone
I only have my mobile. How can I write and execute scripts using mobile?
unfortunstely not feasible
so with image can not excute in android?
not on hand held devices
@@AutomationMadeEasy what about Android tablets?
why did you delete the button??
Button can not be executed from mobile phone, but onEdit could.
Hide Formula in Google Sheets - Part 4: Use More Than One onEdit(e)
ruclips.net/video/_zWxWrrKT2Q/видео.html
No need for it because the script executes when the sheet is edited
Value True is run script
What is 'e'?
event object provided by google app script
how to create geocode in mobile phone,
not possible
Im want to navigate from a index menu: So I copied this code from macro to navigate: the "test" works on mobile, but the "get sheet by name" works on pc but not mobile. Am I doing something wrong? Here is the code:
function onEdit(e) {
//SpreadsheetApp.getActiveSheet().getRange("B2").setValue("")
//SpreadsheetApp.getActiveSheet().getRange("B2").setValue("testing")
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('D11').activate();
spreadsheet.setActiveSheet(spreadsheet.getSheetByName('W_Jan'), true);
}