Hi Max,

Please help import approved users (filter column K = Y) for users registered in July 2024.

Due to the registration page causing issues, I had to create a temporary Google form to collect registrations.

There's 2 tables used for user registrations, I think one is the default WP one and the other is from BuddyPress.

Default WP table: wp6y_signups

-user_login

-user_email

-registered

wp6y_bp_xprofile_data - is the BuddyPress table

I'm pulling the following fields:

-last_updated

-display_name

-Credential

-FaveJdrama

This is the Google sheet, tab--Google Responses:

We need to import from the Google sheet only APPROVED accounts (check column K, Approve? Where cells are Y):

-Timestamp

-Email Address

-Username

-Password

-Name

-Credential

-What's your favorite Jdrama