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Күн бұрын
Very infotmative
@khushisharmadailyvlogs8 күн бұрын
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
@TechGyanamit7 күн бұрын
Ye aap kisme kar Rahe ho?
@dineshbisht229114 күн бұрын
This type of video I'm searching for. Thanks sir.
@Pro-Tips-Tricks23 күн бұрын
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
@spideraccessadmin25 күн бұрын
can you write script for an entire column only
@TechGyanamit24 күн бұрын
Yes
@kamalbandhuverma75628 күн бұрын
Not working
@sharifcomputers420128 күн бұрын
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
@TechGyanamit28 күн бұрын
Google sheet pdf ko direct pc me store nahi kar sakte ye drive me save hoga
@amardutta-z8i28 күн бұрын
Sir please invoice save karnaykyliay invoice may range sell no, row no danay kay bad pdf banaiay
@TechGyanamit28 күн бұрын
U can create a menu and pass range there
@sbanerjee0017001728 күн бұрын
KUTTA TYPE ANCHORE MAHA MURKH LIKE PAKISTANI TERORIEST VIDEO TIME BHARANE KE LIYA FALTU BAT KIYA ESKO NOBEL PRIZE MILAGA
@gopinathroul3531Ай бұрын
Very simple teaching method.
@datascientist6233Ай бұрын
TypeError: value.indexOf is not a function Sir this is the error i got in this line
@TechGyanamitАй бұрын
Check value using logger log
@vishalprajapati-lk7zkАй бұрын
Hindi text extract karke bataiye 😅
@pawantewari8496Ай бұрын
repair k liye link ????
@CookOdiaАй бұрын
Nice video Bro...
@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Ай бұрын
Very good but i will try then surprise
@MIS2-q3u2 ай бұрын
Sir, I want to protect all edited Cells after 7 pm only on daily basis, how to do?
@TechGyanamit2 ай бұрын
Create a trigger which run on 7pm
@MIS2-q3u2 ай бұрын
@@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
@Fiazmalana92722 ай бұрын
nice boss kamal information
@thinkwiselyjk2 ай бұрын
Thanks for the Video Sir! Keep giving us this kind of Informative videos 😊
@spideraccessadmin2 ай бұрын
It worked for me, Thanks for sharing it!
@MrSandipcpatel2 ай бұрын
I SOW ALL VIDEO BUT NO ANY DATA START ROW NUMBER A7
@CookOdia2 ай бұрын
Nice video
@sudhirvishawkarma2 ай бұрын
Wonderful amit sir ji.
@sudhirvishawkarma2 ай бұрын
Thanks Amit sir ji
@amlan93222 ай бұрын
This method is not updating the existing record but creating another record means time waste.
@macreations05282 ай бұрын
Bro while calling api in my poject throwing CORS issue
@Abdulwaheed-ge8pr2 ай бұрын
great u simply excellent
@neha-ip2xc2 ай бұрын
Where the link..?
@dinukumar27722 ай бұрын
Dear sir Mujhe timely limit ke sath protect karna hai uske liye script apps kya hai plz share kar do
@mustansirujjain2 ай бұрын
this scripts is working fine but not setting the protection on current editor
@MrSandipcpatel2 ай бұрын
sir can i use this same view in virtual column as a Section Header
@MrSandipcpatel2 ай бұрын
lekin aap ne data entry karke uki effect nahi batai specialy section heder ka colum ka data kahagaya
@MrSandipcpatel2 ай бұрын
_Rownumer _Rownumber1 two time how can one deleted
@MrSandipcpatel2 ай бұрын
I MY APPSHEET IN TWO TIME _RowNumber how can one deleted
@virendrajrao2 ай бұрын
HTML error
@MrSandipcpatel2 ай бұрын
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
@devenderkumarchaudhary37372 ай бұрын
Easy to Understand & Detailed Video, well-done Amit Ji
@Baby.Videos..5913 ай бұрын
Gajab bhai
@thinkwiselyjk3 ай бұрын
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
@thinkwiselyjk3 ай бұрын
Thanks for the Video Sir 😊
@UTPALBHAKAT-mu5nt3 ай бұрын
Tell us how to protect remaining shared google sheet
@sbanerjee001700173 ай бұрын
WORST CONTAIN WRITER MAHA MURKH
@dinukumar27723 ай бұрын
Sir plz help meri sheet protect nhi ho rahi hai timing se
@dinukumar27723 ай бұрын
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
@TechGyanamit3 ай бұрын
Script work karta hai
@dinukumar27723 ай бұрын
Sir plz share script code for timing Cell lock after 5 mint from entry
@dinukumar27722 ай бұрын
Dear sir plz reply
@harshitbadal62053 ай бұрын
#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(); }) }
@saikatmondal99453 ай бұрын
how to disable download & copy option for ( editors, viewers....)