- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2024 08:21 PM
Hello,
I am facing one issue on lookup select box type variable. I have created a customized field on Incident table , type is Choice and created the choices. Now I have a record producer where I have a variable with the same name and type is Lookup select box. When I am providing the correct name of the customized field in the lookup field value of the variable , no choices are getting populated.
Is there any issue with the type of field on Incident table as 'Choice', because if it is 'String' it will work.
Summarize the fields:
Table : Incident
Field : Product ( type : Choice)
Variable : Product ( on record producer)
Type : Lookup select box
Lookup value field : product (from incident)
Please help to understand the root cause and probable solution.
Regards
Souvick
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2024 03:00 AM
@Souvick6917 Lookup select box variable acts more like a reference field than a choice field. A select box would be more appropriate variable to have on your record producer than a Look up select box.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2024 02:30 AM
Understand that a Lookup Select Box type variable is going to show you only the choices (Products in this case) that exist as a value on one or more incident records. It is looking up all of the values of the custom field from the incident table.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2024 03:00 AM
@Souvick6917 Lookup select box variable acts more like a reference field than a choice field. A select box would be more appropriate variable to have on your record producer than a Look up select box.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-07-2024 03:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2024 05:21 AM
Thank you all, as I figured out the condition for lookup select box and used select box instead , it worked. But sincere appreciation for taking out your time and replying on my question.
Regards
Souvick