Here is the web app https://script.google.com/macros/s/AKfycbyEHj5qtIeCZh4rR6FutBLQ3N9NihreaTv7BFj4_saOfNWJUG0Tn2OtvzQs4zASYHnNiA/exec Any idea on how could I make it show up the links or hyperlinks some cells have? I have made this web form mainly following a tutorial so I’m somewhat new, I try to unde…
Tag: google-apps-script
Google Sheets Script Array Length Returning Null
See code below and log. I am working on a google sheets script that updates a google sheet when a linked google form is submitted. To do this I am using the array “event.namedValues”, which is generated automatically when a form is submitted. However while debugging some issues (and learning how t…
Hide a sheet when I am active on another sheet
I am trying to automatically hide a sheet called “Add expense” when I am not active on it. For example. I have the sheet “BD Expenses”, the sheet “BD Tokens”, the sheet “BD Income”, the sheet “Add expense”, the sheet “Add income”. What I …
How do i make the headings of table align to the content?
I am a beginner to appscript. I am developing a payment system where user can see their payment history and can pay their payment. But for now after I have made some changes to my code, after that the content and headings wont get aligned together, so Im now seeking for some help from you guys. I have include…
How to Highlight row based on particular value in the table?
I’m working on a YouTube tutorial that works on Google App Script and Google Sheets I want to highlight the row if it contains the value “ABSENT”, I tried many ways to but ended in failures, Need some assistance to modify this code to do the job NOTE: Updated the code for better understandin…
Filter the tables in html part of Google App Script
I am beginner to appscript. I am developing a payment system where user can see their payment history and can pay their payment. But for now after I have made some changes to my code, after I select a year and filter it (for example if I select 2020) it says that the records are not available. I have included
How can I solve this in Google Apps Script?
I am trying to extract which option has been selected from the code below in Apps Script. The idea is to change the value of the global variable column depending on which element is selected, but it is not working. html java Thanks a lot! Answer …should be: See it working:
Problems downloading base64 as pdf JavaScript
I’m writing a Google Apps Script Web App, I’m facing a problem. From server side I return the base64 encoded html code of a page: And that works well. Now, from client side, I want to download the base64 (is an html RAW content) as a pdf file (or .html if it is possible), but If I try to do
How can I convert each google slide into a PDF and JPG?
Google Apps Script I want to create PDF files per each slide of a Google slide file (a normal slide with words and graphs). I reviewed past questions and I found a solution that generates PDF files but taking the slides as images (I need to be able to search for words in those pdf). Another solution was appli…
Getting specific charts from array in google script
I’m having trouble getting specific charts from a spreadsheet using an array. The code below is an extract of a function that sends an email which includes charts: The only values of chartBlobs in the final line of this extract that sends an image of a chart in the email are chartBlobs[i] and chartBlobs…