- This topic has 2 replies, 2 voices, and was last updated 2 years, 2 months ago by
.
-
A while ago I believe Daniel wrote a script for me to grab a number from a previous record and add it to a number in the current record to provide a running total. I have several forms that use this technique (in another DB program now defunct) for various purposes including medication days between treatments and rain totals. In that program no computer language programming was necessary.
I could not get the script to work and finally 2.5 weeks ago I submitted my Form with data and the script included (“Previous Field calc”)for rain totals in the Script subdivision of the forum, but apparently nobody is interested in looking at it.
I would really like to get this working – I’m used to depending on those forms.
Hope somebody will look at my problem.
Thanks.Sorry, was (and still am) busy with my real work.
My function resets the year-to-date value as of October 1st. If there is no October 1st entry, the reset fails. The easiest is to add a simple entry with 0 if there is none. After this change, I clicked on
Refresh records listand all looks good now.Attached is the waveform that shows the reset of year-to-date as of 10/1/22.
This uses your test data from https://www.tapforms.com/forums/topic/previous-field-calc/
BTW, it is better to continue to post in the same thread than opening a new one with the same issue.
You must be logged in to reply to this topic.