Include non-stored calculated fields to show in Value Lists

Classic Servoy
1

I’d like to include non-stored calculated fields in value lists in order to display values from related records.

2

Maybe you don’t need an unstored calc. If the calc is doing something simple, like looking up a value from another table, you can already do this yourself if you know SQL.

  1. use getDataSetByQuery() to create a dataset containing the values for the valuelist, you can query any table you want using any criteria :slight_smile:
  2. The Application node in the script editor has a method for setting a value list using a dataset.

You can write a method to do this and trigger it onRecordSelect of your editing screen.

We use it a lot. It is fast.

3

Thanks, Christian. That’s a nice workaround. And it helped me to extend my SQL-experience ;-).