I have a form that has an 'Amount to add' field as text.
I want that field to add what is typed in to the column 'Total'
If 'Total' for the currently selected article is '15' and the user inputs '5' in the 'Amount to add' field. I want the 'Total' column to now show '20'.
This way I can manipulate those tables later the way I need to. This is really one of the biggest things holding me back from building this into what I need.
omg thank you. Not sure how I missed that, but this helps so much!
However.. this doesn't actually seem to solve everything im trying to do.
I can SHOW a computation. but i cannot submit a computation.
Here's what I want to do.
I want ColumnA to be entered at article creation, which is simply a number.
I want to Use a field LATER to ADD to ColumnA
So later, when I goto the form, I can see ColumnA is filled out with a number of 10. Type a '6' in the field to ADD to ColumnA, and when all is said and done. ColumnA is now a '16'
Computations change values of the fields so if if you have field with storage as a target computed value should be saved after form is submited.
pretty sure i got it working, thanks for the help!