Is there a way to ensure that, if both the Title and First Name fields are included in the schema, the gender will match up, for a dataset using names from both genders? I’m seeing records in the results such as ‘Mr. Teresa’, ‘Ms. Donald’, and so on.
The title field doesn’t sync up with the gender field, but you can do this using a formula:
if field('my gender field') == 'Male' then 'Mr.' else ['Ms.', 'Mrs.'].sample end
Awesome, this worked like a charm. Thanks!