How to define the range of values in the dropdown selection field

Get Help
1

image
image1889×517 26.8 KB

Dropdown values can be limited in range, just like custom SQL.

2

Hi there,

Are you trying to customize the choices of that dropdown list? There are a bunch of ways to do it here, but I'm not sure if that's what you meant. If you have more context on the issue, let me know!

3

Yes, I'm trying to configure the options for a custom dropdown. However, the platform currently only allows selecting tables and fields to populate the dropdown options. Based on this, I want the values under this field not to be all displayed in the dropdown box—just like the SQL in my screenshot where certain values are filtered out.

4

I think I understand; you are trying to limit the choices of a Field Filter with Filter widget type "ID", however, this is not supported for that particular widget type.
There is a possible workaround, by using a variable of type Text or Number (and not a Field Filter) and doing WHERE id_column = {{variable}}. Then you would be able to customize the dropdown list.

image
image670×770 30.2 KB

5

Thank you very much for your answer. The issue has been resolved, but I need to upgrade the version. What would be the impact if I upgrade directly from v0.38.4 to v0.54.6?

6

That is a very impactful upgrade (about 4 years of development), make sure to backup your DB before upgrading! But you should be able to do it.

EDIT: watch out for this section that talks about v38 up to v40