Hello! I am wondering if it would be terribly complex to add and subtract numbers inputted into a table much like you can do in Excel? I would like to build a transaction register for a sample bank account.
It's not too difficult. Use Number-Entry fields to collect the numbers you want to work with. The entered numbers become the values of the associated variables.
Then use triggers to add, subtract, multiply, or divide those variables as appropriate.
FYI: The user has to click away from the entry field (i.e., the field "loses focus") for its variable value to change. So I think it'd be best to put the calculation trigger on a "Calculate" button. That'll make it obvious what the user needs to do.
Here's more info about data-entry fields and variables:
1 Reply
Hi, Angela,
It's not too difficult. Use Number-Entry fields to collect the numbers you want to work with. The entered numbers become the values of the associated variables.
Then use triggers to add, subtract, multiply, or divide those variables as appropriate.
FYI: The user has to click away from the entry field (i.e., the field "loses focus") for its variable value to change. So I think it'd be best to put the calculation trigger on a "Calculate" button. That'll make it obvious what the user needs to do.
Here's more info about data-entry fields and variables: