How to store unique ID when using Create a new thing

I am using a backend workflow to import records to my database via csv upload, in my final step I want to assign unique id that are of another record. Bubble will not allow me to select the imported unique ID to save it to the Brand field. How can I setup the field to accept the unique id value? I tried to use arbitrary text and that did not work. I would like to create the relationship for the Brand and Player fields to existing records. Thanks for any help!

Also these are unique IDs that already exist in the database so I cannot use “result of step x” to pull that info in.

You need to make the field ‘Brand’ the data type of what you are trying to save to it.

How can I do that in a csv file? Right now I just have the text unique ID value of a record of type Brand that I am trying to save.