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
3 Answers
Hi,
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.
Your Answer