+ Start a Discussion
Ryan WinnRyan Winn 

Auto populate a commission rate on a purchase order from a saved assignment table?

How can I auto populate a commission rate field in a Purchase Order custom Object from another custom object where we have saved specific rates for different customers? I would like to be able to enter the customer's name when creating a new Purchase Order record and then have the comm rate field in the Purchase Order object get pulled from the rates table.    
Nikhil_KhetanNikhil_Khetan
@Ryan. You can simply use process builder and flow to achieve this. Flow has capabilites to bring the data from the table with some point and click queries. and then you can update that in the PO object.

Please mark this as best answer if you find my answer's helpful.