In my application I use computed fields in two ways. Examples: Name is represented in record as separate fields, e.g., Title, First name, Last name, Suffix. Use a computed field to concatenate last+first +title+suffix and convert to lower case to make a field for use in sorting for display.
Use a computed boolean to maintain a record of good status, a test on date and on the value in a string (status description). The computed fields all work when a record is added (crud.create). When record is edited (crud.update) the boolean is recomputed but the string is not. Stranger even, I made a simple test app with the wizard, then added computed fields of string, integer, float, boolean to the table model. In this case, the controller uses SQLFORM.smartgrid. All the computed fields work when adding a new record but none of them work on editing a record??
