How is the author shown in the spreadsheet view (normal Library? Fn Ln or Ln, Fn?
Templates can be basic:
{author
s} - {title} <<note the S is part of the name
or more complex: (I used this on my Astak that only used file names)
program:test(field('series'),strcat(
substr(field('series'), 0, 1),template("-series/{series:subitems(0,1)||/}{series:subitems(1,2)||/}{series_index:0>2s}-{title}_{authors}")
),template("00noseries/{author_sort[0]}_authors/{author_sort}/{title}-{authors}")
)
BUT
Kobo does not use filenames (other than they must be unique like any computer), so I just use the basic template for the
send to... configuration.
Kobo reads metadata from the book.
Kobo (utilities) supports Series (fill that out

)
The
Metadata Plugboard fudges additional stuff into standard metadata locations of the copy sent to the device, not supported by devices. (Since I just want Series, I do not use on my Kobo's) KISS
BTW Calibre needs distinct names (and son is not). You need to fix those that Calibre does not split properly on Add. (It handles a few:
With,
and <Full name>

there is a tweak that shows the ones the Calibre does handle) So I correct the authors as needed: Joe and Mary Jacobs -> Joe Jacobs & Mary Jacobs

What do you need to do with Joe Jacobs and Son??? Replace son with the real name???