Learn how to use Office Script to build a basic data entry form in Excel online using JavaScript. #excel #office #form
Пікірлер: 9
@omnagar6706 Жыл бұрын
Will it work in Google sheet too ?
@aa2lo060 Жыл бұрын
First thank you for your all videos my bottom is not work is there alternative solution for my issue
@maxwellkadzashie4149 Жыл бұрын
Can do one for start time and end time for task . when the start bottom is pressed it’s deactivated and the end bottom is active to click when task is complete. It will also capture their email and name and task and at the calculate how long it took to complete the task
@guillermosepulvedaf11 ай бұрын
Thanks!
@srishtimishra6649 Жыл бұрын
can you tell which function to use for relative numbering in google sheets. for example- I have ranks of 400 cities from which I selected 45 cities with population more than million, but their rank is as per the 400 ranking list: a=2, b=65, c=289, d=17, ...) But now I want to rank them in ascending order with ranks between 1-45. Please help
@ExcelGoogleSheets Жыл бұрын
SORTN or QUERY
@shinrafahell Жыл бұрын
These web scripts are quite low I would say.
@emperorzuna9931 Жыл бұрын
Why are office scripts so much slower then VBA? If you create similar code for VBA its gonna execute this entry without any delay when you press that button. Office script are only acceptable if you execute them directly...This is so simple code but still so slow.
@jstephen2 ай бұрын
Office Scripts are not stored in the document so when you go to run them they have to be pulled from the cloud location they are stored then once they get loaded they can run. If you run one and then run it again you will notice the second run is much faster, unfortunately if you run a different one then go back to it again has to be loaded. Yes this is quite painful, and MS should do something about this.