Include non-stored calculated fields to show in Value Lists

[Willem]

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

[swingman]

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 :-)
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.

[Willem]

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