I am trying to create a editable field {TestField1} on a skuid page that pulls a value from another filed on the object {Sales_Rep__r.Commission_Percentage__c}.
I assumed that you would just put in a action when a user searches for a product that pulls the value from the model like {{Sales_Rep__r.Commission_Percentage__c}} and saves it as the value for the testfield1. If I put in a absolute value like 1 it works but any reference to {{Sales_Rep__r.Commission_Percentage__c}} or {{Opps.Sales_Rep__r.Commission_Percentage__c}} comes up blank.
Any ideas?
CASE(MODEL_LOOKUP("Opps","Commission_Level__c"), "10%", 0.5 * {{Base_Price__c}}, "9%", 0.475 * {{Base_Price__c}}, "8%", 0.45 * {{Base_Price__c}}, "7%", 0.427 * {{Base_Price__c}}, "6%", 0.405 * {{Base_Price__c}}, "5%", 0.385 * {{Base_Price__c}}, "4%", 0.377 * {{Base_Price__c}}, "3%", 0.368 * {{Base_Price__c}}, "2%", 0.36 * {{Base_Price__c}}, 0 )