GAS, Bootstrap Web form Searches and Shows Data in a table, BUT it does NOT show links or hyperlinks to click on them (from spreadsheet)

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 …

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 …

Extract variables from text string Javascript

I created a Google Slides that contains a lot of variables. I want to be able to pull all variables I have in there at once to Google Sheets. I’m using apps script to get all of the texts as strings …

javascript filter elements not found in second array

solved: requires explicit return statement for each filter. I thought the single boolean in each filter would be clear enough. by @adiga I want to find the elements in one array (dcm) that are not …

How to send/archive a row of data from one sheet to another through trigger?

function onEdit() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var s = ss.getActiveSheet(); var r = ss.getActiveRange(); var rows = r.getRow(); var cell = s.getRange(rows, r.getColumn())…

Google script – use every time the newest sheet

I want to create a script which should use everytime the newest sheet. The sheet gets updates from another group and I want to create an email alert, if I have something to do. Everytime this …

JS sort array by two columns of Dates

I am trying to sort an multidimensional array by dates in two columns. Each element of the array looks like that [Thu Feb 25 10:00:00 GMT-05:00 2021, Tue Mar 09 10:00:00 GMT-05:00 2021, 1326M98301, …

How to update data validation for a certain range within a specific column with a master list with Google Apps Script?

I have two sheets, both have a column that use data validation in Column G/#7, starting from row #8 and all the way down. I have to edit the data validation every once in a while and match the lists …

BigQuery can’t find job when using pagination

I’ve been using this AppScript function that I took from here with slight modifications and it seemed to work fine, it just takes in a query and returns a 2D array. However, if the query is big and …

How do I change my formula syntax to use variables

I’m trying to use set formula but it keeps saying I’m having an issue with my syntax but I’m not exactly sure how to fix it. I’m trying to use declared variables as the inputs to the formula. The bold …