S
Scuff
Hello - I work for a private foundation and am trying to include a formula on
our contact form. I want it to do this:
Field 1: amount of most recent grant (i.e. $10,000)
Field 2: total amount of grant $ received (i.e. over multiple years)
so I want Field 2 to automatically update from Field 1. When I put in a new
amount in Field 1 (i.e. most recent grant of $50,000), I want this amount
added to the total in Field 2...so far I have tried lots of different ways of
approaching this, including having some 'hidden' fields, but no luck. Any
suggestions would be much appreciated!!
our contact form. I want it to do this:
Field 1: amount of most recent grant (i.e. $10,000)
Field 2: total amount of grant $ received (i.e. over multiple years)
so I want Field 2 to automatically update from Field 1. When I put in a new
amount in Field 1 (i.e. most recent grant of $50,000), I want this amount
added to the total in Field 2...so far I have tried lots of different ways of
approaching this, including having some 'hidden' fields, but no luck. Any
suggestions would be much appreciated!!