Is is possible to create a calculated column? For example, in the database I have the phone number split into the area code (e.g. "212") and the number (e.g. "555-1212"), but in the grid I would like to display it as "212-555-1212". Is that possible, or will the grid accept a calculated column from my SQL query (SELECT CONCAT(area_code,"-",phone_number) as PHONE)?
Thank you, Alec
Yes it will work. For update/insert case, you need to have custom on_update / on_insert event callbacks (in package demos)
I am trying to do the same above but dont know what to do.
I have street, area, City, State and Zip Code in my table. When the same is displayed in the grid in one column I want it as Street, Area, City, State, Zip.
Appreciate your help.
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!