This add-on allows the users to more easily substitute phone numbers with corresponding names in a Google Sheets document. Its main purpouse is to allow users to receive a readable form of a phone subpoena utilizing a pre-existent set of phone numbers and names.
The add-on is currently under review in the Google Marketplace and it will most likely be under review for the foreseeable future. Therefore, it is not possible to install it through the marketplace
- Open Google Sheets
- Open Google Apps Scripts (located in the
Extensionsmenu on the toolbar) - (Optional) Download
Phonebook.gsfrom one of the releases - Copy the entire contents of
Phonebook.gs - Replace the
function myFunction()inCode.gswith the contents ofPhonebook.gs - Reload Google Sheets (it might take more than one try)
- Done
Note: The script will only work for the one specific Google Sheet. You will have to repeat this process for different sheets.
The add-on is not a verified Google app. Google Sheets will ask for permissions to run the script on the attached Google Sheets document the first time you try to use the add-on. You will have to sign in with a Google account and give the add-on permissions to see, edit, create, delete Google Sheet documents. The add-on only sees (reads) and edits Google Sheet documents, but the permissions are grouped together.
- Attempt to use the add-on (e.g. try to select a phonebook)
- Authorization Required - Google Sheets will ask for permission to run the script
- Sign in with a Google account
- Click
Advanced - Click
Go to Untitled project (unsafe) - Click
Allow - Done
In order to use this add-on you need to create a separate sheet containing pairs of phone numbers and names that will act as a 'phonebook'. This sheet will be used by the add-on as a reference to know which phone numbers need to be replaced in a subpoena. The pairs of [Number, Name] must be located in the first two columns of this sheet without any empty rows.
To replace phone numbers in a subpoena you need to first read a phonebook by using the Select Phonebook button. After you have selected a phonebook you can use the Replace Phone Numbers button to select a sheet in which you want to replace phone numbers with corresponding names.
When selecting a sheets to be used as phonebook, type in the sheet name exactly as it appears in the tabs at the bottom.
Similarly, you need to input the sheet name correctly when choosing a target sheet where the phone numbers will be replaced.
Afterwards, each number that appears in the selected phonebook should be replaced with a corresponding name in the target sheet which containing the information from a subpoena.
