INFORMATION

We recently added a new feature to Apps Script: the ability to interact with your Google Docs List. With this new integration, scripts can create, rename, or move files and folders in your Google Docs. In addition, scripts can now create, modify, and clear plain-text files and search through your documents for a specified query string.

For instance, take a company whose website is hosted on Google Sites. They have a Specials page where they want to list seasonal sales depending on upcoming holidays. They store the details about the seasonal sales in plain-text files that are saved in their Google Docs List. By using the Google Docs List and and Sites services within Apps Script along with time-based triggers to run the script once per day, they can keep their Specials page updated automatically. Here’s a code snippet that demonstrates how to update the Specials page:

//The Mother’s Day sale runs from May 1 - May 7, 2011
var MOTHERS_DAY_START = new Date("May 1, 2011");
var MOTHERS_DAY_END = new Date("May 7, 2011");
//The Valentine’s Day sale runs from Feb 6 - Feb 13, 2011
var VALENTINES_DAY_START = new Date("February 6, 2011");
var VALENTINES_DAY_END = new Date("February 13, 2011");

function updateSpecials() {
  var today = new Date();
  var site = SitesApp.getSite("example.com", "giftshop");
  // Get all the web pages in the Site
  var pages = site.getWebPages();
  // Loop through the web pages to find the specials page
  for (var i = 0; i < pages.length; i++) {
    if (pages[i].getPageName() == "specials") {
      var page = pages[i]; 
    }  
  }
  // Set up the default wording for the specials page
  var pageText = "There are no specials at this time.";

  // If today’s date is within the Mother’s Day sale range
  if (today >= MOTHERS_DAY_START && today <= MOTHERS_DAY_END) {
    // Find the sale text that’s stored in the file mom.txt
    pageText = DocsList.find("mom.txt")[0].getContentAsString();
  }
  // If today’s date is within the Valentine’s Day sale range
  else if (today >= VALENTINES_START && today <= VALENTINES_END ) {
    // Find the sale text that’s stored in the file valentines.txt
    var pageText = DocsList.find("valentines.txt")[0].getContentAsString()   
  }
  // Set the content of the specials page
  page.setContent(pageText);  
}​

If this script is then set up to run using a trigger that calls it at the same time each day, then the Specials page will be kept automatically up-to-date.

To help you learn more, weve created a tutorial that demonstrates how to search and display information about files, create files, and read content from files.

Note that certain features of the DocsList service, such as creating files, are only available to Google Apps accounts. For complete information on interacting with your Google Docs List using Apps Script, see the DocsList Service documentation.

We look forward to seeing how you use this integration. If youd like to learn more about Apps Script and meet the Apps Script team in person, join us at the upcoming Apps Script hackathon in New York City on June 24.

Posted by Jan Kleinert, Google Developer Relations

I am just in love with the font options in PowerPoint!  I used to do so many of these things in Photoshop, but doing it in PowerPoint makes it so much easier!


This was a definite winner on the poll!


For those of you who saw my previous tutorial on placing a pattern over your text, you can add these options on top of the pattern to make your font extra special!  You can view that previous tutorial below:

Now... onto the tutorial!






As for next weeks poll, Im going to add a question that so many people often ask... how can I find "royalty-free" clipart, pictures, and textures for free?  Be sure to vote for your favorite choice on the poll!

An Alcatel Tablet came into my workplace. It is the Alcatel One Touch Tab 7 HD. A tutorial to hard reset your tablet is coming your way ;)





Hard resetting / factory resetting your phone will solve the following issues:
1. If you forgot your pattern lock
2. If you forgot your gmail account
3. If you forgot your password
4. Apps that automatically force closing
5. Stuck in Alcatel Logo (sometimes does not work if the firmware is totally damage)

NOTE: Performing hard reset will erase your data.

To hard reset:

1. Turn off your tablet.
2. Press and Hold VOLUME UP + VOLUME DOWN + Power button. Release the power Button only when the tablet power up. Just wait until the Android Robot appear.
3. To activate Android System Recovery, press VOLUME UP and POWER button simultaneously. Keep pressing until the Android System Recovery appear.
4. Select wipe / factory reset, press Volume rocker to navigate and press the Power Button to confirm your selection.
4. Reboot your tablet.

Note: If performing hard reset did not succeed, you need to wipe the cache first in the android system recovery before performing wipe / factory reset.

I hope this tutorial helps you.. If you have any question just drop a comment.

Alright another tutorial for  Torque, and this one is for Torque Droidz Avatar TV. This phone is like Galaxy S3.



Hard resetting / factory resetting your phone will solve the following issues:
1. If you forgot your pattern lock
2. If you forgot your gmail account
3. If you forgot your password
4. Apps that automatically force closing
5. Stuck in Torque Logo (sometimes does not work if the firmware is totally damage)

NOTE: Performing hard reset will erase your data.

To hard reset:

1. Turn off your phone
2. Press and Hold Volume UP +Power Button simultaneously
3. An Android with exclamation mark will appear, Press Power Button to activate recovery mode
4. Select wipe / factory reset, to navigate press the Volume DOWN, to select press VOLUME UP
5. Reboot your phone.


Note: If performing hard reset did not succeed, you need to wipe the cache first in the android system recovery before performing wipe / factory reset.

I hope this tutorial helps you.

Reset your gigantic Samsung Galaxy Note 3 N9000.



Hard resetting / factory resetting your phone will solve the following issues:
1. If you forgot your pattern lock
2. If you forgot your gmail account
3. If you forgot your password
4. Apps that automatically force closing
5. Stuck in Samsung Logo (sometimes does not work if the firmware is totally damage)

NOTE: Performing hard reset will erase your data.

To hard reset:

1. Turn off your phone
2. Press and Hold Volume UP + Home Button + Power Button simultaneously
3. Release the buttons when you see the Samsung Galaxy Logo
4. Android System Recovery should appear
5. Select wipe / factory reset, to navigate press the Volume Rocker, to select press the Power Button
6. Reboot your phone.

Note: If performing hard reset did not succeed, you need to wipe the cache first in the android system recovery before performing wipe / factory reset.

I hope this tutorial helps you Samsung Galaxy Note 3 users :)