use exponential functions in uionly field to the power of
Jack Sanford
San Antonio, TX ๐๐
I'd like to be able to use "to the power of" exponential functions in a UIonly field. Use case is estimating a payment amount on the front end of a public site. We have a formula field to do this, but the formula is blank until the record is saved, I'd like to show the calculation before saving. But it requires, in particular, this formula: "(1+ MonthlyInterest__c ) ^ NoofPayments2__c", where the ^ symbol represents "to the power of".
Would be great to see that as an option in the UIonly dropdown list of Operators.
In the mean time, any way to hack this?
Would be great to see that as an option in the UIonly dropdown list of Operators.
In the mean time, any way to hack this?
Tagged:
3
Comments

You could build a quick custom field renderer in javascript and use Math.pow().1

@jacksanford Hi, not sure if you ever succeeded in accomplishing this above. As i have now a very similar requirement and need to use EXP excel function. if you did and could share the way you did it, or JS you used (if any) that would be amazing!
Let me know
Thx
0 
Hi @Dave, no I never did figure that out. Matt's suggestion above is where I would start, create a snippet that fires whenever a given field is changed that updates the value using math.pow()
0 
Ok perfect thank you for quick answer :)
0 
You can define a custom function and use that function in UI formula:
https://docs.skuid.com/latest/en/skuid/api/skuid_formula.html
1
Howdy, Stranger!
Categories
 9.2K All Categories
 8K Questions
 928 Ideas
 243 Discussion Categories
 185 General
 9 Community Feedback
 6 Community Info
 26 Knowledge Base