Record Producer to set value in table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-20-2023 10:44 AM
I am trying to set a value in the destination table of where a record producer is sent.
I tried within the script part of the record producer and also catalog client script but neither seem to work. I am not sure which option is better. I have tried in the script producer and current. It works for other things I am mapping this way in the script but not sure why it's not working for these?
if (producer.x_location_type == 'Facility') {
current.x_on_premises_selection = "Building";
}
if (producer.x_location_type == 'Non-Site Facility') {
current.x_off_premises_selection = "Site";
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2023 11:54 AM
It sounds like you have set the value on the fields. When you see a value in the XML but nothing is displayed on the form there is no display value for the value you set....make sure you have choices with the same values.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-20-2023 01:52 PM
Check the dictionary entries of that table. Like @ricker said, what field type are they? Are they String?
If I helped you with your case, please click the Thumb Icon and mark as Correct.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2023 08:43 AM
They are choice fields
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-21-2023 08:46 PM
You can try the .setDisplayValue() command like:
current.x_on_premises_selection.setDisplayValue("Building");
If I helped you with your case, please click the Thumb Icon and mark as Correct.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2023 08:39 AM
I tried this and it's still empty.