Telephone numbers and email addresses

The following generators produce values for telephone numbers and email addresses.

For more information about these generators and how to configure them in the application, go to Telephone numbers and email addresses in the generator reference.

Country Phone Code (Global)

Populates the column with a country telephone code from anywhere around the world.

Uses the General column configuration.

Country Phone Code (US)

Populates the column with the country telephone code for the United States.

Uses the General column configuration.

Email Address

Populates the column with an email address.

If the table includes first name and last name columns, then the email address is automatically derived from the those columns. For example, [e-mail].

Uses the General column configuration.

Phone Number (Global)

Populates the column with a telephone number from anywhere in the world.

{ 
  "name": string,
  "data_type": string,
  "generator": "Phone Number",
  // Generator-specific fields
  "phone_number_format": string, // The format to use for the telephone number
  // End generator-specific fields
  "conditions": [
    {
      "subset_field": string,
      "operator": "is_one_of"|"is_not_one_of"|"is_not_null",
      "subset_value": string
      "weight": integer
    }
  ],
  "default_weight": integer,
  "group_key": string,
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}

Phone Number (US)

Populates the column with a telephone number from the United States.

{ 
  "name": string,
  "data_type": string,
  "generator": "Phone Number (US)",
  // Generator-specific fields
  "phone_number_format": string, // The format to use for the telephone number
  // End generator-specific fields
  "conditions": [
    {
      "subset_field": string,
      "operator": "is_one_of"|"is_not_one_of"|"is_not_null",
      "subset_value": string
      "weight": integer
    }
  ],
  "default_weight": integer,
  "group_key": string,
  "percent_null": integer,
  "virtual": boolean,
  // Advanced options
  "primary_key": boolean,
  "index": boolean,
  "seed": string,
  "postprocessing_sql": string
}