Help Adding

[Glen Forister]

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.

• This topic was modified 2 years, 2 months ago by Glen Forister.

[Daniel Leu]

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 list and 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.

• This reply was modified 2 years, 2 months ago by Daniel Leu.

Attachments:

You must be logged in to view attached files.

[Glen Forister]

Thanks. That did make it work. I’m glad it was an easy fix for you to explain.

I started a new issue in the other section in an attempt not to bother you since I thought you might be busy and a volunteer (as I suspected). I appreciate all your efforts.

[Author]

Posts