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.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?