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?
Solved! Go to Solution.
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!
Hi @cshinneman,
Would it be possible to share a little more info and some screenshots on what you are trying to do? I assume you're using a model-driven form and out-of-the-box calculated column/field? You can lookup a parent column in the calculated field with this format: <LookupFieldName>.<FieldName> in your expression.
Cheers
Hi Eric,
Thanks for you interest.
Yes I am using out of the box "calculated column/field" in the Parent table with the concat() function to populate a calculated column with the string that I am using as the field for the connection between the Parent and Child tables. It is in the Child form when selecting the Parent value that the problem arises. For some reason it does not want to work where the Parent column is calculated.
There isn't much to look at. I have attached my schema to get some idea of what I am doing. The "Trainings" table population is the one that is giving me trouble.
You should be able to reference a calculated column in another calculated column (up to 5). Can you paste your calculated expression?
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,
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?
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.
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.
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!
User | Count |
---|---|
20 | |
11 | |
9 | |
5 | |
5 |
User | Count |
---|---|
34 | |
32 | |
19 | |
18 | |
7 |