Announcements
No record found.
Hi all,
What is Computed columns in data entity? What is the use of computed columns? When we exactly used computed columns?
Please give me more shed on this
Thsnks!
Hi..all the information you are looking for is in standard documentation. Take a look at below in this case:
docs.microsoft.com/.../data-entity-computed-columns-virtual-fields
Thanks Satish,
I have read the docs. I have one doubt.
Could you please let me know why we need computed columns?
Is there any specific data type which can use for computed column only.
Thanks!
It's an unbounded data field. Mostly used for reads. You read combined data or send /write combined data and then handle that.
Thanks Satish
Here unbounded data fields means is it picture or static text fields?
Unbound fields means not connected to any underlying data source . The data type can be anything out of the available options for example string , integer etc.
Thanks Sukrut
Based on the above , could please give me one example
The standard documentation has one example...
We want the output to be in specifoc format...that's achieved by computed column. Check method formatNameAndAddress(). Then see how it's used in last section.
Hi @rp@n,
Another example would be handling some reference fields. E.g. I have had a scenario where a table has two reference fields to a table ID and a field ID. As these can be different per environment, the computed column was able to export the table and field name. During the import, it looked up the table and field ID for that environment.
Thanks Andre,
Could you please give me example based on above. I understand but still doubt
It is mainly used for unmapped fields.
For example, you can query or calculate the value of some fields through SQL, such as sum or avg. At this time, you can add calculated fields to the entity to calculate and display it.Assuming your table has an annual salary column, you can return through the view, and you can get your monthly salary through salary / 12.
You can add the computed column to the select list of columns only.
Regarding examples, it is used in many entities, such as PSAActualEntity.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 586 Super User 2026 Season 1
Giorgio Bonacorsi 551
CP04-islander 408
