[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”3.0.47″][et_pb_row admin_label=”row” _builder_version=”3.0.47″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.0.47″ parallax=”off” parallax_method=”on”][et_pb_text admin_label=”Text” _builder_version=”3.0.47″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_margin=”-100px|||” use_border_color=”off” border_color=”#ffffff” border_style=”solid”] In the my last post, we looked at the SpreadsheetApp class. Now, let’s look at the next group related to spreadsheets, which is the Spreadsheet class. This class allows us to: copy spreadsheets work… Continue reading Apps Script Basics (8) – Spreadsheet Class
Month: May 2017
Apps Script Basics (7) – SpreadsheetApp & for in loop
[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”3.0.47″][et_pb_row admin_label=”row” _builder_version=”3.0.47″ background_size=”initial” background_position=”top_left” background_repeat=”repeat”][et_pb_column type=”4_4″ _builder_version=”3.0.47″ parallax=”off” parallax_method=”on”][et_pb_text admin_label=”Text” _builder_version=”3.0.50″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” custom_margin=”-100px|||”] In this post, we’re going to look at the G Suite services, the Google documentation that’s available to help you, and then focus on one particular area, SpreadsheetApp to then create some spreadsheets. We’re also going to… Continue reading Apps Script Basics (7) – SpreadsheetApp & for in loop
Apps Script Basics – if, prompt, menu, & onOpen trigger
In this post, we’re going to look at how we can get the computer to react to data in a spreadsheet and to user input. We’re going to look at the following: If, else if, and else statements – to allow the program to make decisions Create your own menu in the spreadsheet to run… Continue reading Apps Script Basics – if, prompt, menu, & onOpen trigger