How can I get a list of the first and last names of all adorers?

How can I get a list of the first and last names of all adorers?

For the purposes of We Adore Him, we only need a single name field to display adorer names and with which they can login.

However, we also have a "Sort name" field (that you can override) which is automatically calculated to the adorer's last name. This field affects the sort position of adorer names in lists.

Image
Sort Name field
Sort Name field

If you need to generate a list of first and last names, you can easily do this with a spreadsheet program. Here's how.

  1. Export your adorer list at Admin » Adorers.

  2. Open the CSV file in a spreadsheet program such as Microsoft Excel, Apple Numbers, or Google Sheets.

  3. Add a new column between "Name" and "Sort Name" called "First Name".

  4. In this column, use the following formula: =SUBSTITUTE(A2, C2, "")

  5. Finally, rename "Sort Name" to "Last Name".

Now you should have columns containing the full name, first name, and last name of each of your adorers.

Image
Adorer first and last names
Adorer first and last names
Still stuck? How can we help?