I spent hours and hours trying to find this out, but I am not succeeding. Here is my problem:
I have an option set (quality_info) consisting of a number and a textvalue.
- Good item
- Bad item
I have a product database with productinfo, which contains a number, which is a reference to the number in the option set.
I want to list the products in a repeating group, but in stead of the quality number I need to show the corresponding textvalue (good item/bad item).
Can somebody please explain how to do a lookup in the option set, based on the number(qualityvalue) in the producttable, so that i can retrieve the Textvalue?
Desc:Product1, QualityValue: 2
Desc: Product2, QualityValue: 2
Desc: Product3, QualityValue: 1
Which should result in the repeating group list
Product1 Bad item
Product2 Bad item
Product3 Good item
Can anyone help me with this?
You have number + text in 1 field (display) of your Option Set or you have two different fields to store number and text of an option separately?
Thank you for your reply.
I stored the values in 2 different fields in an option set.
The first field is of type number. The second field is the ‘Display’ field of type Text.
I want to do a lookup of the number-field and display the corresponding ‘Display’ field
I’m not sure this applies to your current database structure but to search through an option set you have to “flip it”.
get option Quality
this option’s display is YOUR CRITERIA
Hey @rico.trevisan ,
It took me some fiddling, but your solution worked. Thanks!
I selected the option set. Then ‘all options’.
Then I :filtered, the right option by selecting the option number field, then ‘is’ and then the parents…'number (the one in the repeating group). And finally I selected the Option sets’Display to show on the screen.
Thanks again! You made me happy
This topic was automatically closed after 70 days. New replies are no longer allowed.