You’re offline. This is a read only version of the page.
I am attempting to Lookup on a Parent calculated column. It works in a very odd way. In one instance it brings in the locally defined field (of the calculated column) in the parent table but not on the looked-up field in the parent. In another case the parent table shows as a popup table but when a record is selected no data is copied into the child field. In another case where the parent calculated field is composed of two lookup fields no popup table shows at all.
Is it possible to lookup to a parent calculated field?
Eric, This did the job. Thank you... I had been going round and round with this for over a week!
Ah... I am sure you are onto something here... I will do some testing... Thanks Eric!
I didn't think so. I have a regular text field that contains a calculated field from a parent 1 entity. Or does any field that "points to" a calculated field considered a calculated field? Now that calculated entity is pointing to a parent 2 entity but it it not a calculated field. So in the string of connected tables there is only one "calculation" per se.
Assuming what I am doing cannot be done, how do I get around this limitation? Is there any way I can get access to the alternate keys? I have to imagine projects routinely need cascading far deeper than I am trying to go.
Thanks Fubar
Thanks for the video, that really helped. So you're issue is actually not with the calculated fields/columns, but with the tables/entities data. I've summarize them with a solution below:
Hope this all makes sense!
If I a understanding what you are attempting to do correctly, I think you are trying to break one of the limitations:
A calculated field can’t contain a calculated field from another entity that also contains another field from a different entity (spanning three entities): (Current Entity)Calculated Field <- (Parent Record) Calculated Field 1 <- (Parent Record) Calculated Field 2.
Was just testing the table view and it is connected to the parent record, it just doesn't display it, shows a "(No Name)" but if clicked on to show the Parent it displays the correct parent record.
I am attaching a little video that shows how it is working.
If we could use alternate keys it would be soo much easier.
That’s weird. Just to try to isolate the issue, crd24_employee and crd24_skillspeciality are both text columns that contain values? Also, doesn’t work on a model-driven form but can you see the data in an entity/table view or via Advanced Find?
this is the expression:
Concat(crd24_employeefullname.crd24_employee, "-", crd24_skill.crd24_skillspecialty)
this expression works fine. It is the Form that references this column this is not working properly.
Thanks,
You should be able to reference a calculated column in another calculated column (up to 5). Can you paste your calculated expression?
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
Super User 2025 Season 2
#3
mmbr1606
275
Super User 2025 Season 2
Share
Report
All responses (
Answers (
