Learning JavaScript

Have a look at “Scripting in Tap Forms” on https://www.tapforms.com/support/. Sam Moffatt and T.L. Ford provide additional resources on using scripting with TapForms.

What kind of things are you envisioning doing?

There’s also a good JavaScript reference here:

https://en.wikipedia.org/wiki/JavaScript_syntax

Hi Glen,

Instead of JavaScript, you could also just use a Calculation field.

In your previous JavaScript question, the solution to get the difference between two dates in months is this formula:

MONTHS(Start Date; End Date)

and that’s it!

It’s not required to learn to program in JavaScript just to do simple things like that. That’s what the Calculation field is for. There’s lots of functions that’ll do all sorts of things for you without programming. You just have to know simple mathematical expressions.

Thanks,

Brendan

Ah, now I have another hidden doc.
I have to study that, but I didn’t see anywhere quickly, how do you reference the previous reord? IE:

MONTHS(recordDate. previous recordDate).
The number of months since the last record was entered looking at the date entered for each record?

Sorting is key to this operation, you are right.

I have several health situations I log into a database like pill taken, cortisone cream use and inches of rain fallen each day with a running total are a few. They have to used in Date sorted view so the next entry is the last. This keeps me from taking medicine before a certain amount of time since the last treatment and I stretch it as long as I can and I can run a report of min, max, and avg of times between treatments.

Do you know how that could be made to happen?
Thanks.

Thanks for the script, but it doesn’t do anything, I suppose be cause I have to define where to get the previous record and then add today’s total to it. I could probably spend the rest of the day working on this and not figure it out I’m sure.

I’ve attached my file and maybe if you fix it I can apply the example to other similar forms I have to import data for.
Thanks.

Hi Glen,

Thank you for sharing your form! The script Brendan posted is for a field of the type Script and not Calculation.

Here is the updated script that works for me:

function Season_to_date() {
	
	var records = form.getRecords();
    	var currentRecordIndex = records.indexOf(record);

    	if (currentRecordIndex > 0) {
        	var previousRecord = records[currentRecordIndex-1];
    	} else {
     		return 0;
    	}

	var today = record.getFieldValue('fld-61c03b767f2c497491d10a28db8abdb3');
	var previous_total = previousRecord.getFieldValue('fld-f6bc7e82da874579940fb8afc167dac4');
	var total = today + previous_total;
	
	console.log("Today: " + today)
	console.log("Previous: " + previous_total)
	console.log("Total: " + total)
	
	return total;
}

Season_to_date();

I’m recording daily rain fall (morning, noon and night)I want each record to show the total for that day (done) and add that to the previous season total to get the new season total.
each record has the total for the day and the season total

I added the Script to the list of Scripts, then noticed the change of field properties to Script instead of Calculated and put the script there, but nothing happened.

Am I supposed to change the script to enter the field somewhere?

That loop script doesn’t do anything either.

That didn’t quite work. Looping to get all every time? Here is the first 3 lines of the relult. This is one thing I like about programming, always a surprise.
Day tot. Sum
0.03 0
0.31 0.310
0.23 0.230.310
0.33 0.330.230.310

Brandon’s script results
0.03 0
0.31 0.310
0.23 0.230.310
0.33 0.330.230.310

• This reply was modified 1 year, 11 months ago by Glen Forister.

Well, that worked after deleting form and reinstalling with your archive.
Entered in the new data.
Wanted to see on my iPhone and after selecting “Table” so the date would be to the left of the data, not under the date (hard to read), the iPhone display now is completely black and I can’t find any way to display the data. The form list shows it has 17 records, but the iPhone is a blank screen.

BTW, did you produce that graph in TF, or export to another prg. My previous database could produce graphs of the data with a touch, but I don’t see it here. Still haven’t carefully read, or remember all I’ve read of what documents I could find or were given to me. I must be still missing a lot. I know it took a long time for me to learn all the tricks of the other DB, so I’m not surprised here.

I figured that out. thanks.
The file I used was for learning and had only this season. I thought it would be good to start with a small file.
I tried to import the whole 5 years into the file, but import created a new file Form with the same name instead of adding to the current form. So I tried to duplicate the format for the new form but failed. I think I have all the file properties correct, but the script just gives me “NaN” in the field (even after repeated refresh). You have a clue what I missed, or can I copy records from this form and add them to the working form?

BTW, somehow the Date col disappeared which produced bogus charts obviously. I added a new Field (DATE) and moved it to the top and after configuring the field the original data appeared out of nowhere. What happened here? I couldn’t find that data until it suddenly appeared, and how did it disappear in the first place?

I missed that import setting.
Thanks.
I imported all 5 years of data and now when I create a filter and just view this season, which is 38 records, the script sees all the records, not just this season.

Do I need to create another field to delete the total at the beginning of the season to find the total for the season, or is there a more elegant way?

This should to the trick to reset the season total at the beginning of the year:

function Season_to_date() {
	
	var records = form.getRecords();
    	var currentRecordIndex = records.indexOf(record);

    	if (currentRecordIndex > 0) {
        	var previousRecord = records[currentRecordIndex-1];
    	} else {
     		return 0;
    	}

	// Is this the beginning of the year?
	var date = record.getFieldValue('fld-0720a5baa6fc4980aee22798bd089714');
	if (date.getMonth() == 0 && date.getDate() == 1){
		return 0;
	}
	
	var today = record.getFieldValue('fld-61c03b767f2c497491d10a28db8abdb3');
	var previous_total = previousRecord.getFieldValue('fld-f6bc7e82da874579940fb8afc167dac4');
	var total = today + previous_total;
	
	console.log("Today: " + today)
	console.log("Previous: " + previous_total)
	console.log("Total: " + total)
	
	return total;
}

Season_to_date();

The script checks for January 1st and if there is match, the return value is set to 0.

Here is the update for checking for October 1st:

	var date = record.getFieldValue('fld-0720a5baa6fc4980aee22798bd089714');
	if (date.getMonth() == 9 && date.getDate() == 1){ // check for October 1st
		return 0;
	}
	

Guess I put it in the wrong place. That didn’t work. Luckily I’m working on a copy so I won’t screw up the original.

Sorry. That isn’t doing it. Look at my file and see what isn’t working.

I tried putting it in the “Scripts” tab, and in the Field/Season Total tab in Scripts.

Thanks for trying again.

My data shows (the first 3 lines) the first rain of the season.
On 11-1-22 had 0.31″ rain.
So, 11-01-22 total for that day should be 0.31, not 80.95.
date 6am. noon. 6pm. 10pm. day. season
11/01/22 0.00 0.00 0.00 0.31 0.31 80.95
11/01/22 0.00 0.03 0.00 0.00 0.03 80.98
11/07/22 0.28 0.00 0.33 0.00 0.33 81.31

I can’t make it change with a refresh ctl+opt+R or from the menu “View/Refresh”
The screen is only showing the Season records “2022-2023” from years going back to 11-21-20218.

Are you showing 11-01-22 starting at 0.31 for season total? If so, something is off here.

I guess it is a lost cause on my end, because no matter how many times I do all that, or delete the code and reinstall it and shut down and refresh I can’t get it to work.

Too bad too, because that is another strike against Tap Forms. If you sent me via email the archive that works, maybe it will work for me??? I don’t know what is missing. I have several other files of data that I want to get this to work on also.

I’ve had a crash course in TF for all day for the last 4 days transferring 70 files from HanDBase and configuring them so they do what they used to do. For the most part they do work, but there are a lot that require a form on the iPhone to make them work so I have to keep HanDBase running just for those. Maybe I can simplify them enough to get them to work but it is doubtful. I do all my database work on my iPhone, not on the computer so the form on the computer is useless almost.

Anyway, thanks for trying (I believe you are volunteering your expert help here) and if you think you can solve the problem using code, and want to keep trying I’m good to go.
Thanks.