I’m getting HTML from a forum url, and parsing the post count of the user from their profile page. I don’t know how to write the parsed number into the Google spreadsheet. It should go account by account in column B till last row and update the column A with count. The script doesn’t give me any errors, but it
Tag: google-apps-script
Choosing most liked post from facebook group
Well, here is the json file http://herbalista.hol.es/group.json i am working with JSON.parse(); on Google apps script. I temporarily solve with this code by Choosing the post which have more than 15 likes, but i want to choose the one with more likes independently if have or not more than 15 likes. Answer For this you can Choose a default value
Content Service for Google Apps Script returning HTML instead of JSON
Trying out the Content Service API and the example is returning HTML when it should be returning JSON, what am I doing wrong? https://developers.google.com/apps-script/guides/content GAS from another file trying to make the request: Answer Your usage of ContentService is correct, the code works exactly as is. Here is a link to my copy of your code published as a web
Avoid formatDate error in Google Apps Script
ive got a function to storage in an array and loop data from a document. Inside this one, there are cells with dates in format dd/mm/yyyy…but when I send it by email, appears like Wed Jan 01 2014 00:00:00 GMT-0300 (ART) I used inside this function, a formatDate method but through me an error Cannot find method formatDate(string,string,string). How I
Google Form on Submit get values and format the time
I am using Google Apps Script with a Google form. When the user submits the Google Form I get a value from a question. I then take that value and make it a date object, from what I saw on this post about daylight savings I use that to determine the timezone. I run the date object through Utilities.formatDate and
Google Apps Script with Immediate Time-Driven Trigger
I’m attempting to test a script that I’m working on. The script is fine, it executes successfully when I trigger it manually. I’m just doing a “sanity check” on a time-driven trigger and it’s definitely pushing the bounds of my sanity. I’ve set it up for a one-time “Specific time / date” execution to test that it will run after
Google Apps Script validation issue in Google UiApp
I have been trying to figure out Google Apps Script validation in Google Sites and have yet to make the validation part work correctly. I need to validate 2 things: That there is at least 5 characters in the “location” textbox (up to 100) That a date has been selected from the dropdown If both conditions are not met, then
Google Script to copy the values of a column and insert a new column in spreadsheet
I have started creating a spreadsheet to monitor some results from facebook, youtube etc… A lot of things I did I was able to learn from previous answers on this site. Now I am stuck with trying to find a script which can help me do the following: Column A contains the description of the metric Column B contains the
Checking if an email is valid in Google Apps Script
I’m using the built-in api for scripting against Google Spreadsheets to send some booking confirmations, and currently my script breaks if someone has filled in an invalid email. I’d like it to just save some data to a list of guests that haven’t been notified, and then proceed with looping through the bookings. This is my current code (simplified): According