How can I automate the display of a hyperlink

I am managing many projects, all with sub-items. I would like to Automate the following tasks, and I need some help.

  1. Find a way to automatically display the Manufacture in the DropDown Colum based on the first word in the Subitem name.
  2. Automatically fill the Hyperlink column with a specific link based on the first word in the sub item name.

I currently fill in the sub item name, then manually select the Manufacture (which is a Linked Board) and I have a Mirrored column that shows the correct link. I am trying to get rid of the manual process of selecting the Manufacture. Any help would be greatly appreciated. I am new to Monday, so be kind if I am missing something obvious.