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
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
bump
Jeez, all the way back in 2015. Brutal.
I wonder why it was never implemented?
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:
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…
It would be great to have an update on this.
Any update on this?
Having support of Query Fields in Calculated field would be VERY helpful.
This is one of the last feature we would need to completely drop the SG Daemon for Budget calculation
Officially a decade since that 2015 forum post. Really hoping they implement this eventually 