Calculated fields in value lists

Classic Servoy
1

I’m having a little trouble with value lists. I have a type-ahead field with a data provider of person_id. I am returning person_id, and want to show person_id, name**_full**, and postcode.

Name_full is a calculated field with the following simple code

function name_full()
{
 	return name_first + ' ' + name_last;
}

Whether or not I store name_full, I can’t get it to work properly. I want to be able to type John Smith and get “234 John Smith AB1 2BC” come up in list.

Screenshot shows how I’ve got my value list setup, any help appreciated

value list setup.jpg
value list setup.jpg978×520 102 KB

2

I’ve fixed it. It turns out it was because my stored values were blank since I was playing with the list.

While experimenting with table view tab all my name_full fields re-calulated and populated, and now it works just fine. I guess the answer to my own question is the field I use must be stored?

(It raises another question about how to programatically recalculate a field, but that’s for another day / post / life)