Questions tagged as 'google-apps-script'

Tagged questions
0
answers

How to insert a row from php to google spreadsheet [closed]

Hello to the whole community, Well I'm working on a project in which I want to automate a series of things, what I need is to know how from php I can insert a row or rows in Google spreadsheet. I have read that it can be developed through the...
asked by 13.07.2016 / 09:49
3
answers

How to filter data from an array of objects using RegExp?

From the following array of objects How can I filter all emails containing the word director of the property POST, without distinguishing between uppercase or lowercase, only containing that word? var regs = [ {EMAIL:"directorgra...
asked by 30.11.2017 / 23:33
2
answers

Execute script without ending when there is an error in apps script

I have a code in apps script where I delete an event in calendar with the following instruction var calendar = CalendarApp.getCalendarById("[email protected]") .getEventSeriesById(IdParaBorrar).deleteEventSeries() It works well w...
asked by 09.02.2017 / 05:13
1
answer

Show / Hide a spreadsheet row when clicked

I am working with a spreadsheet to have a more web style and I need to show details of some fields only when the user requires it. I can show a hidden row with sheet.showRows(3) but I can not hide it using: var clic=0; function mostrarD...
asked by 27.08.2018 / 16:29
1
answer

Google Apps Script Forms Service from Android

I am working on research for the development of a web browser-type mobile app that opens a page, in order to work in the offline mode of Google Forms. I know I need to use this Google Apps Script Forms service to develop this application, b...
asked by 02.10.2016 / 04:32
1
answer

Results Other an Unspecified in the fields LopMostSpecificTargetId AoiMostSpecificTargetId

Using the variables LopMostSpecificTargetId AoiMostSpecificTargetId I have tried to include it in the script to get those fields and in the sheet I get the results Unspecified an Other. Do you know why I get this data and not the location or...
asked by 01.09.2016 / 16:01
1
answer

Script Google Sheets to get a link to modify sent answers

I'm trying to copy this code from another post to be able to create links in a Google Sheets column that edit the responses from the sending of Google Forms forms. The fact is that the script does not work for me and it gives me the followi...
asked by 16.12.2018 / 00:22
0
answers

Error creating a new object

I'm relatively new when it comes to programming in google apps script and JavaScript. The fact is that I need to create an object in the following way:    Fill in the information fields    Press the create button    Press the confi...
asked by 08.11.2018 / 16:55
1
answer

Menus in Google Sheets script

I'm starting in this world of Google Sheets scripts. I have seen how to create menus and submenus that appear on the sheet but, although it will be easy, I have not found a way to make active and inactive entries. What function allows me t...
asked by 21.10.2018 / 12:47
0
answers

Update data from a Spreadsheet - App Script

I am doing a data transfer of several spreadsheets to a single one, what I do is transfer the last data of certain columns to the master spreadsheet and also insert them in the last available row of certain columns, for now, I insert all the dat...
asked by 03.09.2018 / 19:28