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 understand most of the code but truly it’s quite hard for me so if this is something that’s too hard
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 to do this), I wanted to check the length
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 want is that when I am active in any of the sheets that is not called
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 included the
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 understanding. CODE.JS INDEX.HMLT Answer
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 applied to
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[0] even though there are 4 charts