Primary Phone Number Format in Template

Primary Phone Number Format in Template

The Primary telephone number needs to be entered in a specific format on the templates in order for the devices to dial that number correctly directly from the app.

This primary telephone number field is found in the following templates: Attendees, Speakers, Sponsors, Exhibitors, Members, Staff.

 

Below are the instructions on how to adjust the primary telephone number to fit the required format.

  1. Highlight cells with the incorrect format
  2. Ctrl + F to do a mass find and replace.
  3. You will receive this pop up. Click on Options:

4. Strip the phone field of any formatting by enter any additional characters you have in the Find What field (i.e. a dash, a period, parenthesis, etc.). In the Replace with field, do not but anything.

In the Search field, select By Columns from the drop down.

Click Replace All.


5. Right click and select “Format Cells”

6. In the Number tab, select the “Custom” Category

7. In the “Type” box, beneath Sample, enter: ### #######


8. Click Ok.

 


    • Related Articles

    • General Template Uploading

      When uploading the templates to the CMS modules you will get 2 options – Overwrite & Append. Overwrite: This will completely wipe out any data in the module and replace it with the data on the template you are uploading. Append: This will either add ...
    • Uploading Items Template

      When uploading the Items template you will get 2 options – Overwrite & Append. Overwrite: This will completely wipe out any data in the Items module and replace it with the data on the Items template you are uploading. Append: This will either add ...
    • Uploading Schedule Template

      When uploading the Schedule template you will get 2 options – Overwrite & Append. Overwrite: This will completely wipe out any data in the Schedule module and replace it with the data on the Schedule template you are uploading. Append: This will ...
    • Uploading Event Channels Template

      When uploading the Event Channels template you will get 2 options – Overwrite & Append. Overwrite: This will completely wipe out any data in the Event Channels module and replace it with the data on the Event Channels template you are uploading. ...
    • Uploading Attendee Photos

      After you have uploaded your attendees into the Attendee Module via our templates or via adding individual entries using the “Add Attendees” button, you then have the ability to upload a photo for each attendee. To do so click on the “+” symbol in ...