Map string field to reference field - transform map

[Anwesha3]

Hi all, 

I have a requirement to map string field value to a reference field. That means source field will contain string value ( eg : Name of business area) but the target Field is a reference field. 

Is it possible to map string field to reference field without using source script and glide record?? 

I tried giving reference field name, but it's not working.

[Ethan Davies]

Using the Reference Field Name is the correct way to do it, double check your incoming value and your target value. There may be spaces or extra characters in your incoming data, it is looking for an exact match. Also, double check your field name is entered exactly as it appears on the target table, its the field name, not the label.

[Tai Vu]

Hi @Anwesha3 

Yes you can use Source Script and GlideRecord to do your query with specific criteria. Then return the sys_id of the record.

Sample below for query to User table by user_name.

Or you can also leverage the Referenced value field name field to specific the referenced table field to match with the reference value.

Cheers,

Tai Vu