very informative and well explained,thanks,, but when i tried it in mobile using a onEdit function as a trigger,it has an error in the lines of "getfolderbyid" it says no permission,,any way posible to execute this script in mobile or tab? bcoz clickable image is not working on mobile and onEdit has error in getfolderbyid, thanks in advance
@@AutomationMadeEasy its works with no errors in desktop also your video about automatic salary slips,,i tried also the onEdit function in there too,same error ,"getfolderbyid no permission,i think onEdit function cant be use as a trigger when having a getfolderid in script,is there's any other function that can be used in mobile as a trigger?
@@AutomationMadeEasy sorry for having so many questions :( , i just need a script that can save a copy of specific sheet form into a pdf file whenever its finish to fill up,that can use into desktop and also in mobile phones
I did everything that you said but when I click on the PDF all the values say #REF! like the PDF is not pulling the cell values from the Data sheet. Please advise.
If I only want some cells and columns to be in my invoice as I am creating buttons next to my active sheet. what do I put in the 1st varient so it doesn't print the buttons on invoice pdf
I completed all the steps successfully and the PDF file was extracted, but all the existing data was deleted because it was equations. Is there a solution to this problem?
I explained to you that the paper to be converted to PDF contains data linked to another worksheet. When the process is completed, as I mentioned, the paper is converted, but without the data. I want a solution to this problem.
Thank you. This video is very useful. But I could not generate PDF in A4 Landscape. Please advice
Hi, can I know how to get the name of the file to be named as certain cell in the spreadsheet
?
very informative and well explained,thanks,, but when i tried it in mobile using a onEdit function as a trigger,it has an error in the lines of "getfolderbyid" it says no permission,,any way posible to execute this script in mobile or tab? bcoz clickable image is not working on mobile and onEdit has error in getfolderbyid, thanks in advance
does this work from desktop? or you are having same issue when you execute from desktop too
@@AutomationMadeEasy its works with no errors in desktop also your video about automatic salary slips,,i tried also the onEdit function in there too,same error ,"getfolderbyid no permission,i think onEdit function cant be use as a trigger when having a getfolderid in script,is there's any other function that can be used in mobile as a trigger?
@@AutomationMadeEasy sorry for having so many questions :( , i just need a script that can save a copy of specific sheet form into a pdf file whenever its finish to fill up,that can use into desktop and also in mobile phones
I did everything that you said but when I click on the PDF all the values say #REF! like the PDF is not pulling the cell values from the Data sheet. Please advise.
If I only want some cells and columns to be in my invoice as I am creating buttons next to my active sheet. what do I put in the 1st varient so it doesn't print the buttons on invoice pdf
For your requirement I would recommend you to follow below approach:
ruclips.net/video/Aajg5eoY5TA/видео.html
I completed all the steps successfully and the PDF file was extracted, but all the existing data was deleted because it was equations. Is there a solution to this problem?
Please Help
data in spreadsheet?
I explained to you that the paper to be converted to PDF contains data linked to another worksheet. When the process is completed, as I mentioned, the paper is converted, but without the data. I want a solution to this problem.
How to create individual PDFs of all the worksheets?
well same solution in customized manner like looping through all the sheets and generating pdf's of the sheets
@@AutomationMadeEasy Follow up on this question
Do filter in data then export pdf one by one
Failed gan. teamwbk ('application/pdf') how?...
I did not understand your question