


Hi all im trying to get a script that depending on the value of field name (code) it
would ask me the percentage amount and then add that percentage amount to the total of another field
basically what i'm trying to get is
if code = abc then ask to input amount of percentage then add amount of percentage to total
so if percentage =10 and total = 1000 then the amount of total would be 1100
any help would be greatly appreciated
Thanks
Views
Replies
Total Likes
Hi there!
To quickly ask a question for a quick answer from the user, you can use the built-in function response.
It is the same thing as a messageBox but with a text field to insert a response / value
Hope this help!
Views
Replies
Total Likes
Thank you for your time i've inserted this code in my script and I do get it to
show the input percentage value in the percentage field with this code {Percentage.rawValue = rep}
but with this formula sum (hours*rate+sub+$*Percentage/100)
my Total field ignores the +$*percentage/100 and only calculate the hours * rate + sub
I tried different formula but could get it to work
Views
Replies
Total Likes
don't use the sum function, it should be used only if you specify a multiple instance of an object like : sum(Row1[*].Percentage)
you are only calculating 1 row in this case.. so forget about the sum function
Not quite sure why it isn't working if removing the sum function doesn't work but try this instead (if you are using ($) as the keyword in FormCalc for (this) in JavaScript):
Hope this help!
Views
Replies
Total Likes