Copy projects to board on Monday.com - with sub items

Question

I'm using monday.com and I've got a board called "Projects" which lists main projects by clients.

The fields are:

Project Name, Client Name, Job No, Designer, Date, Hours, Sub Hours

The Sub items are:

Project Name, Job No, Designer, Date, Hours

I want to use an automation so that when the Designer is set to "John" it shows the job or sub job on a board called "John's Workflow"

On "John's Workflow" I want to see

Project Name, Client Name, Job Number (or sub job number), Date, Hours

What automation would I need to use? I'm using, "When 'subitem Designer' changes from 'Anything' to 'John' create am 'item' in 'John Workflow'

The item is set to 'Project Name' = project name, 'Job no' = job no, Client = [blank], Hours = [blank].

I dont know why its not showing client or hours tho.

Any ideas?