Tip | |||||
---|---|---|---|---|---|
| |||||
|
Tip | ||
---|---|---|
| ||
Direct Google Form link: https://goo.gl/forms/UvdkhUggBTInGuHi1 |
Info |
---|
Instructions for making corrections to numbers in the PhoneTool ReportPlease give the linked Google Sheet a close review, and let us know if you think the green standardized/normalized numbers are OK to be loaded into the NationBuilder Membership database.
INSTRUCTIONS: Any changes should be entered in the blue phone_number or mobile_number columns. There are 5 reporting columns for each phone type in the database: Phone (landline), Mobile, Work, Fax:
(Note: many members do actively use US-based +1 phone numbers as their valid phone number, so don’t always assume that a +1 number is wrong.)
*Making phone number corrections in Google Sheets: There are 2 columns where you can make corrections in the spreadsheet.
Each of these columns is highlighted in BLUE. If you find numbers where you can identify what needs to be corrected to possibly make a Valid number, please make those corrections DIRECTLY in the spreadsheet, in the appropriate blue column (once again, don’t enter the same number in multiple fields).
Only Use Country Code Prefix, not "+" (plus) symbol When you manually type a corrected number, please use this format:
{country code} [SP] {destination code} [SP] {remaining digits} Google sheets (like other spreadsheets) will give an "Error" message if you type in the "+" sign into a cell. Please highlight any changes you make in RED for us. What will happen when you inform us that you have finished your review:
|
...