Friday, March 19, 2010

March Madness Challenge - Day 19

Ok Google, why does your Google Apps Script not have any decent search features. Let's look at the API for contacts. If your grep for search nope nothing, nada. There is findByEmailAddress, but I have to know what I'm looking for not a substring. This goes with events, I can search the calendar application and search for words related to my events, but the API doesn't contain a search feature. You have to select an event by date. Not so useful. Anyway onto tonight's March madness.

Non working code, sorry.


function getAllContacts() {
var contacts = ContactsApp.getAllContacts();
for (var i = 0; i < contacts.lengh; i++)
{
var contact = [];
contact.push(contacts[i].getFullName());
contact.push(contacts[i].getPrimaryEmail());
contact.push(contacts[i].getEmailAddresses());
contact.push(contacts[i].getHomeAddress());
contact.push(contacts[i].getWorkAddress());
contact.push(contacts[i].getPager());
contact.push(contacts[i].getHomeFax());
contact.push(contacts[i].getWorkFax());
contact.push(contacts[i].getHomePhone());
contact.push(contacts[i].getWorkPhone());
contact.push(contacts[i].getMobilePhone());
contact.push(contacts[i].getNotes());
contact.push(contacts[i].getUserDefinedField());
contact.push(contacts[i].getUserDefinedFields());
range = SpreadsheetApp.getActiveSheet().getRange((3+i),1,1,contact.length);
range.setValues([contact]);
}
}

No comments: