Пікірлер
@lyadh_khor_manus
@lyadh_khor_manus 2 сағат бұрын
hi sir what can i do in app sheet in order to recieve dada on the same dateee can u help me to figure out i can pay u for that some amount i neet it urgently
@shivshankarkumar7446
@shivshankarkumar7446 Күн бұрын
Very infotmative
@khushisharmadailyvlogs
@khushisharmadailyvlogs 8 күн бұрын
Hello sir meri ek query hai plz help me Mujhe mobile phone se live Vedio upload karni hai jo camera open ho bs only galley ka option open na ho or Vedio upload hojaye or jab b hum and entry check kre to Vedio play b ho sath sath plz help me sir
@TechGyanamit
@TechGyanamit 7 күн бұрын
Ye aap kisme kar Rahe ho?
@dineshbisht2291
@dineshbisht2291 14 күн бұрын
This type of video I'm searching for. Thanks sir.
@Pro-Tips-Tricks
@Pro-Tips-Tricks 23 күн бұрын
Yeh login format main agar level admin hai to puro data dekh paye, wo kaise set kare? agar is login format main data input ho raha hai , to logged name ke against pe dikhaye kaise karna hai
@spideraccessadmin
@spideraccessadmin 25 күн бұрын
can you write script for an entire column only
@TechGyanamit
@TechGyanamit 24 күн бұрын
Yes
@kamalbandhuverma756
@kamalbandhuverma756 28 күн бұрын
Not working
@sharifcomputers4201
@sharifcomputers4201 28 күн бұрын
bhai smple sa code bana den google sheet se 2 cells k between data pdf me convert kr k local pc me save krna hai bas
@TechGyanamit
@TechGyanamit 28 күн бұрын
Google sheet pdf ko direct pc me store nahi kar sakte ye drive me save hoga
@amardutta-z8i
@amardutta-z8i 28 күн бұрын
Sir please invoice save karnaykyliay invoice may range sell no, row no danay kay bad pdf banaiay
@TechGyanamit
@TechGyanamit 28 күн бұрын
U can create a menu and pass range there
@sbanerjee00170017
@sbanerjee00170017 28 күн бұрын
KUTTA TYPE ANCHORE MAHA MURKH LIKE PAKISTANI TERORIEST VIDEO TIME BHARANE KE LIYA FALTU BAT KIYA ESKO NOBEL PRIZE MILAGA
@gopinathroul3531
@gopinathroul3531 Ай бұрын
Very simple teaching method.
@datascientist6233
@datascientist6233 Ай бұрын
TypeError: value.indexOf is not a function Sir this is the error i got in this line
@TechGyanamit
@TechGyanamit Ай бұрын
Check value using logger log
@vishalprajapati-lk7zk
@vishalprajapati-lk7zk Ай бұрын
Hindi text extract karke bataiye 😅
@pawantewari8496
@pawantewari8496 Ай бұрын
repair k liye link ????
@CookOdia
@CookOdia Ай бұрын
Nice video Bro...
@sasjnur-prep
@sasjnur-prep Ай бұрын
function sheetProtection() { let sheet= SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1"); let row=sheet.getActiveCell().getRow(); let col=sheet.getActiveCell().getColumn(); let val=sheet.getRange (row, col).getValue(); if (val!=""){ let protection= sheet.getRange (row, col).protect(); protection.removeEditors (protection.getEditors()); if(protection.canDomainEdit()) { protection.setDomainEdit(false) } } }
@Vavgamefmindia
@Vavgamefmindia Ай бұрын
Very good but i will try then surprise
@MIS2-q3u
@MIS2-q3u 2 ай бұрын
Sir, I want to protect all edited Cells after 7 pm only on daily basis, how to do?
@TechGyanamit
@TechGyanamit 2 ай бұрын
Create a trigger which run on 7pm
@MIS2-q3u
@MIS2-q3u 2 ай бұрын
@@TechGyanamit Sir pls share the link if any. I want to lock data entry cells only and if need edit the employee can edit before 7 pm only. After 7pm all data entry cells want to permanent locked for employee and blank cells are automatically unlocked in next day after 9 am. please
@Fiazmalana9272
@Fiazmalana9272 2 ай бұрын
nice boss kamal information
@thinkwiselyjk
@thinkwiselyjk 2 ай бұрын
Thanks for the Video Sir! Keep giving us this kind of Informative videos 😊
@spideraccessadmin
@spideraccessadmin 2 ай бұрын
It worked for me, Thanks for sharing it!
@MrSandipcpatel
@MrSandipcpatel 2 ай бұрын
I SOW ALL VIDEO BUT NO ANY DATA START ROW NUMBER A7
@CookOdia
@CookOdia 2 ай бұрын
Nice video
@sudhirvishawkarma
@sudhirvishawkarma 2 ай бұрын
Wonderful amit sir ji.
@sudhirvishawkarma
@sudhirvishawkarma 2 ай бұрын
Thanks Amit sir ji
@amlan9322
@amlan9322 2 ай бұрын
This method is not updating the existing record but creating another record means time waste.
@macreations0528
@macreations0528 2 ай бұрын
Bro while calling api in my poject throwing CORS issue
@Abdulwaheed-ge8pr
@Abdulwaheed-ge8pr 2 ай бұрын
great u simply excellent
@neha-ip2xc
@neha-ip2xc 2 ай бұрын
Where the link..?
@dinukumar2772
@dinukumar2772 2 ай бұрын
Dear sir Mujhe timely limit ke sath protect karna hai uske liye script apps kya hai plz share kar do
@mustansirujjain
@mustansirujjain 2 ай бұрын
this scripts is working fine but not setting the protection on current editor
@MrSandipcpatel
@MrSandipcpatel 2 ай бұрын
sir can i use this same view in virtual column as a Section Header
@MrSandipcpatel
@MrSandipcpatel 2 ай бұрын
lekin aap ne data entry karke uki effect nahi batai specialy section heder ka colum ka data kahagaya
@MrSandipcpatel
@MrSandipcpatel 2 ай бұрын
_Rownumer _Rownumber1 two time how can one deleted
@MrSandipcpatel
@MrSandipcpatel 2 ай бұрын
I MY APPSHEET IN TWO TIME _RowNumber how can one deleted
@virendrajrao
@virendrajrao 2 ай бұрын
HTML error
@MrSandipcpatel
@MrSandipcpatel 2 ай бұрын
sir aap ka tutroal video bahut achha hai ek video banaye app sheet ki all indicator ka kya work kya kam hai like Home button data view aciton automation kese swicth to legacy button operate karna hai all off them one mage video thank you
@devenderkumarchaudhary3737
@devenderkumarchaudhary3737 2 ай бұрын
Easy to Understand & Detailed Video, well-done Amit Ji
@Baby.Videos..591
@Baby.Videos..591 3 ай бұрын
Gajab bhai
@thinkwiselyjk
@thinkwiselyjk 3 ай бұрын
Sir you are requested to make a video on apps script When a value change in a formula range or Array based formula how to trigger the apps script function
@thinkwiselyjk
@thinkwiselyjk 3 ай бұрын
Thanks for the Video Sir 😊
@UTPALBHAKAT-mu5nt
@UTPALBHAKAT-mu5nt 3 ай бұрын
Tell us how to protect remaining shared google sheet
@sbanerjee00170017
@sbanerjee00170017 3 ай бұрын
WORST CONTAIN WRITER MAHA MURKH
@dinukumar2772
@dinukumar2772 3 ай бұрын
Sir plz help meri sheet protect nhi ho rahi hai timing se
@dinukumar2772
@dinukumar2772 3 ай бұрын
Sir is me ham timing sat kar sakte hai kya ki protect ho 10 mint ke baad Agar galti se kisi staff ne wrong entry kar di tab to problem aa jaegi hame agar hamare pass 10 mint ka time hoga protect hone me to us wrong entry ko ham sahi kar sakte hai Easa kuch hai to sir plz bataye thanx
@TechGyanamit
@TechGyanamit 3 ай бұрын
Script work karta hai
@dinukumar2772
@dinukumar2772 3 ай бұрын
Sir plz share script code for timing Cell lock after 5 mint from entry
@dinukumar2772
@dinukumar2772 2 ай бұрын
Dear sir plz reply
@harshitbadal6205
@harshitbadal6205 3 ай бұрын
#code function makepdf() { //hide sheets let ws = SpreadsheetApp.getActiveSpreadsheet(); let sheets =ws.getSheets(); for(let i = 0;i<sheets.length;i++){ if (sheets[i].getSheetName()!=='Mail Format'){ sheets[i].hideSheet(); } } //convert pdf file // let folder = "drive.google.com/drive/folders/1vzD2gJ1w8Ra7DZFn6AUg3MEDFDNZp4P3" let drivefile = DriveApp.getFileById("1xbNvzh_Vrf0mZ7c1hk-eMcYM8yTk6IbDrabBebF83MY"); let pdfFile = drivefile.getAs('application/pdf').setName("Loans_QA"); let convertpdf = DriveApp.createFile(pdfFile); let fol = DriveApp.getFolderById('1vzD2gJ1w8Ra7DZFn6AUg3MEDFDNZp4P3'); convertpdf.moveTo(fol); //show sheet sheets.forEach(function(eachSheets){ eachSheets.showSheet(); }) }
@saikatmondal9945
@saikatmondal9945 3 ай бұрын
how to disable download & copy option for ( editors, viewers....)
@complexescolaireelando1702
@complexescolaireelando1702 3 ай бұрын
merci
@iamabhyankar
@iamabhyankar 3 ай бұрын
Thank you Sir no one is explained like you ❤
@jaquelineclaudiabarrionuev832
@jaquelineclaudiabarrionuev832 3 ай бұрын
Please subtitles in English