Kevin W

For those who have been wanting ranks for the totals, I have been trying like crazy to find a way make it happen. Today, I found a way, but at the moment, it only works behind the scenes, not on the front end. I have contacted the vendor for the plugin I use for these tables and I'm waiting for a reply. Based on what I can tell, it doesn't look too promising, unless they can do some sort of magic for me.

You must mean 12/06. I didn't see that posted anywhere, but I'll get that in there.

Unless we're missing something, I've got you at 22.1"

If there are any SQL wizards here, the following is the query that gets the result for the home page table: SELECT user_names.user_name,city.city,state.state,SUM(events_full.amount) AS total FROM user_names,city,state,events_full WHERE user_names.user_id=events_full.user_id AND city.city_id=events_full.city_id AND state.state_id=events_full.state_id AND events_full.season_id=13 AND amount > 0 Group By user_names.user_name

I thought of that, and I'm sure it can be done, but it's not something I know how to do off the top of my head. I would love to know how, so I'm going to look into it.

You can now add events or totals from 2006-07 onward. I will add the season pages for those years, and add my data, when I get to work. (I have events from 2007-08 until present) Also, I know there are some with event data that goes way back. If you want it added, but don't want to enter all the records, if you send me a spreadsheet in the following format, I can get it in quickly:

All set. See PM

Not a problem at all. I have data going back to 2007-08. I'll work on this a little later today and let you know when I'm done.

Understood. It's not a big deal, really. The storm page was just something I thought I would add to give a quick, and neat indication of storm totals. Like you said, your season total is correct, and every entry in the All Records page remains as well. You're not confusing anything.

On the Latest Storm page, because it was a 3 day event, I decided to combine multiple entries from the same people during this time period (Dec 1-3) to show totals from the entire event. I think it's cleaner this way. If you entered Dec 4 for an amount, as I have seen in some cases, when it may need to be Dec 3, these entries will not be part of the total.

That would help! Sorry, I've been busy and forgot about that. I will send it to you shortly.

Done

You're all set. I put a dummy record in there. You can edit that, and add, edit and delete records now, unless you want me to do it. Let me know.

Will do within the hour. I'm mobile at the moment.

Gotcha

Is this a season total? EDIT:(That's how I entered it)

I added a page: Latest Storm

I just cleaned the cars and we got at least 3" before the rain.

It's never too late. I can even take events from prior seasons if you know them. I'll get to adding you both in shortly. I'm tied up at the moment.

I don't know what I would do without you Was playing around with a lot of stuff there today. I should have checked that. Thanks a bunch! It's all set now.

You can now see a running total on the Your Records page. If you filter your records by season, it will give you the total for that season. I also added the ability to print these records. Unfortunately, the total does not appear for printing. I'm going to contact the vendor of the plugin I use for these tables and see what can be done about that. Also, in order to make the running total work, I had to change the data input type to float, for your Amount entries. As a result, it may be little tricky entering them, but it's easy to figure it out. If the Amount field comes up as 0.00 for you, don't try to enter a decimal. It will cooperate with you. If you want to enter 1.5", you simply type 150. The decimal is set to 2 places automatically. 12", you would enter 1200. A quarter inch, you enter 25. You'll see what I mean. (if you even see it at all. I just tested this on my phone and tablet, and seem to be getting different behavior with the amount entry.) I'll work on this as well.

I don't know if I ever sent you your login info, so I just tried to send it via PM. That didn't work.

Thank you sir. It should be ok now.

You can now do some serious filtering on the Events Entries page. (narrow down events by member/season, for example) I have been fine tuning a bunch of stuff there this morning. If anybody has any problems, or questions, feel free to let me know.

There is no reason to sign in, unless you are entering your own records. To do that, a member would need to go to the "Your Records" link, where they would see their records, and can add/edit/delete records. I add members manually. There is no way to register. If you want to be part of it, I need to know.