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?

We Adore Him needs only a single name field to display adorer names and with which they can log in.

However, each adorer has a "Sort name" field, automatically prepopulated to the adorer's last name, which you can customize. 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 (e.g., Microsoft Excel, Apple Numbers, 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?