Linked Fields and Calculated Fields in Query Fields

Hello!

At the moment, shotgun can’t use query fields in calculated fields.
You also can’t use linked fields in calculated fields, which is a massive obstacle for us in a lot of cases.

We can make duct-tape solutions using the API, but has anyone found a way to get around this with general use of the UI in shotgun?

Thanks,

-Phil F

6 Likes

Bump from me - I’m struggling with calculated fields too.
The worst part is, that it seems that they had a solution ready, but decided not to include it in shotgun - see here: https://support.shotgunsoftware.com/hc/en-us/community/posts/209477948/comments/212707798

1 Like

bump

Jeez, all the way back in 2015. Brutal.

I wonder why it was never implemented?

Me too… Such an important feature

1 Like

Hi all - I just came across this thread and have some good news to deliver! Linked fields are now supported in calculated fields - check it out:

2 Likes

This is great for the Linked Entity Fields!

But we are still missing the query fields in Calculated Fields.

For example: we have a currency field on Bookings (Crew Planning), so on the Project we created a Query Field that makes the Sum of all Bookings. But from there we cannot calculate anything else from that field…

1 Like

It would be great to have an update on this.

2 Likes