I have a subform in a module for payment history with the following fields:
- Transaction Type (pick list)
- SaleID (number)
- Package Price (currency)
- Total Hours (decimal)
- Hourly Rate (formula - decimal)
- Date
It'd be great to add a currency field for max hourly pay rate based on the hourly rate the client paid divided by our goal max payout percentage. This isn't possible with a new formula field since there's a limitation and a custom formula field can't be used in the expression.
Is there a simple workaround I'm missing to make this possible for the desired currency field in this subform?
And if there's not a simple workaround I'm missing and the solution is a function, like I assume, I'd appreciate any help with that because while I'm slowly learning more about functions, I am not a developer and am 99.9% hopeless with writing them.
P.S. An even deeper question...is it wishing for too much for there to be a way for this max hourly pay rate to be populated in a completely different module based on the sale ID? Example of how this would work: Payment history is in the client record (Accounts module) and a new placement record (Deals module) is created from the client record. When the new placement record is created, verifying which sale ID to use (automatically uses the sale ID based on the most recent purchase date) for the new placement record, and then the max hourly pay rate result for that sale ID is automatically added in the matching field type in the placement record.