You ALSO need to use the metadata plugboard to insert the metadata into the
title , not the file name (This works with device 'sends', as it needs to detect the device unless ALL is usable for your collection of devices)
PS I do not recommend mangling the intended usage of Calibre columns.
Series [series_index] has a purpose
Messing with the {Title} can prevent fetching metadata