Repeated entries - Dynamic choices

Need help
1

Hi all,

I want to use dynamic choices in a drop-down menu but there are repeated entries. Is there a way to avoid that?

06
06860Ă—549 64.8 KB

Thanks,

Alfredo

1 Like
2

Yes. Add the “:unique” parameter to the end of your query.

3

Thank you!

Where exactly? Option Caption? I don’t see that parameter as an option.

33

4

I think you’d do it at the “Search for Rubrics” level, under Choices Source.

1 Like
5

Currently the dropdown is selecting from individual items of the table Rubric, so :unique won’t change anything, because there are no duplicates.

From the screenshot of the page, it looks like you really want the user to select from different values of Assessment, to be used to constrain a search on Rubric in the repeating group.

To do this, change the dropdown:
Type of choices: to the same type as Assessment, which is probably type “text”,
Choices source: Search for Rubrics’s Assessment:unique
Option caption: Current option

Then alter the repeating group to constrain Assessment by dropdown’s value.

1 Like
6

Problem solved. Thank you!

7

This topic was automatically closed after 70 days. New replies are no longer allowed.