I would like to set the value of a data field, using conditional rules, to be calculated from an equation utilizing record values as well as connected record values. Is this possible? I hope.
Should be possible, using a conditional equation. Check out this resource to learn more: Equations - Knack Knowledge Base