- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2018 09:16 AM
I have a variable I am trying to map to a field within the Record Producer. I have been able to map all of the fields except for one. I have been able to successfully map Caller, Requested by Date, and Short Description with no issues. I do not understand why the location filed will not work?
When setting up the variable I have made sure that the Name matches the field I am trying to map to, just like the others I have mapped. When testing this, if I change the name to department, the variable maps to the department field with no issues. When I change the name back to location, the variable will not map to the location field.
Does anyone have any suggestions on how to resolve this issue?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2018 11:27 AM
trishlipe,
At this point name or question of the variable doesn't matter, please change change the type of variable to reference and reference tabel as cmn_location for the variable that should fix the issue. Please refer to below screen shot.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2018 09:27 AM
Hi trishlipe,
I think field type of variable "Location of Request" should be the same as field type of field (Location) you're trying to map.Can you please check the field type of location in table you're trying to map?
Thanks,
Vik.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2018 10:46 AM
Here is the field I am trying to map to. I have tried changing the Question to 'Location' and I have tried changing the name to 'cmn_location'.
I have the location variable set up the same as the others that are working.
Below is the Requested due by date. This is mapping correctly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2018 11:27 AM
trishlipe,
At this point name or question of the variable doesn't matter, please change change the type of variable to reference and reference tabel as cmn_location for the variable that should fix the issue. Please refer to below screen shot.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2018 12:17 PM
You are wonderful and the screenshot was very helpful. This did resolve the issue.
Thank you very much. :0)
