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 …

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

Jeez, all the way back in 2015. Brutal. I wonder why it was never implemented?

[image] PhilFranjo: I wonder why it was never implemented? Me too… Such an important feature

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: [image] 8.32 Release Notes Release Notes 8.32.0.9198 (Thursday December 9, 2021) Improvement: tada Support for u…

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…

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 :frowning:

Linked Fields and Calculated Fields in Query Fields

Flow Production Tracking

shaynad January 27, 2022, 9:18pm 6

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:

Topic		Replies	Views
Using query fields with calculated fields Flow Production Tracking calculated-fields	2	1241	December 12, 2023
Calculated Fields Limitations Flow Production Tracking feature , calculated-fields	4	1321	September 2, 2022
Question : shotgrid calculated fields search Flow Production Tracking	2	129	February 20, 2024
Calc/Query Date Fields in Gantt View Flow Production Tracking fptr , gantt , fptr-webapp	0	37	December 5, 2024
How to compare version field with linked shot field? Flow Production Tracking calculated-fields , linked-fields , workaround	19	2979	October 18, 2020

Linked Fields and Calculated Fields in Query Fields

Related topics