Version history

First release; followed by a few minor bug releases:

• V1.0.1

  • solved length property error.

  • improved sheet creation (validate values in Status column and email address column).

  • improved error logging.

• V1.0.2

  • improved sheet layout (alternate row coloring),

  • status column gray,

  • removed spaces from Spreadsheet data during Contact creation in the Google Directory,

  • fixed prefix value retrieval (it was previously not retrieving the prefix value, but full name by accident)

  • fixed 'length error' message during the list action, in case that no contacts are available.

• V1.0.3

  • fixed the text string display for contact field "Notes"

  • Replace help guide document with a help page on this website.

• V1.0.4

  • solved issue for ' (apostrophe) character in name (conflict with email address display name),

  • solved issue for missing ID for update/delete, by showing the error Code in the status column

• V1.0.5

  • Fixed issue for trim is not a function for the postalcode column. In case the postal code is numeric value.

• V1.0.6

  • Improved the creation of the Contact Sheet: adding more Cell Notes with help text).

  • Improvement on the creation of the Insight sheet (layout and formulas improvement). Should also be faster.

  • Solved a bug when retrieving the contact data from Google and saving the data in the sheet. Previously values of the previous contact could be inherited to the new data row. Fixed by setting the contact data every time to empty.

• V1.0.7

  • Solved (list function) issue , contact phone is now placed in the correct spreadsheet column (Mobile or Work).

  • Updated column help text for email 1, email 2 and mobile phone on Contact sheet.

• V1.0.8

  • Solved issue during list, retrieving Organization Title and Job in a correct way.

  • Note, there might be an issue with the Update function. Not sure why,when, how. Feedback appreciated. Does the update work for you?