copy a string value to a reference field

[Snow Dev5]

Hi SNOW Dev,

Is it possible to assign a string value to a reference field? For example,assignment group is a reference field, and I'd like to assign "Team Acme" (String) to an assignment group field like the below.

assignment_group = "Team Acme"

I tried it but didn't work. Thank you in advance.

[Snow Dev5]

Hi, 

Could you advise me? It looks like this approach work to you. However, it didn't work to me. I checked logs table and confirmed str_value value appeared correctly. Thank you!!

[MrMuhammad]

Actually you are storing description in the str_value [first red box] and then setting that value to assignment group [second red box] thats why it not able to find any reference in the reference field and unable to set the field value. See below screenshot.

If you have assignment group name in the Description field then this would work. 

Please mark this helpful if it answered your question.

Thanks & Regards,
Sharjeel

[Dhananjay Pawar]

Hi,

As I already mention as note. You can only set value to reference if that value already present in table, otherwise not.

I can see you have entered "Unable to access" this value is not present in group table(means non of the group having name like that);

var str_value=gr.description; ?? this will copy value from description field
gs.print(str_value); // this will give info massage of description field value
gr.assignment_group.setDisplayValue(str_value); // this will set value to assignment group if description field value is name of one of the group in Group table.

Mark correct/helpful based on impact.

Thanks,

Dhananjay.

[Snow Dev5]

Thank you!