Recent Posts

11

Defects / Cubbies Inventory Green Emblems

« Last post by MaureenCooper on December 27, 2022, 03:43:48 PM »

Green Emblem 11092 is discontinued, but when the patch is earned for completing Entrance Booklet, it comes up with that item and not 11093.  That item shows it is a Book Award and doesn't automatically show received.  Is that correct?

12

Q&A / Re: State Required Volunteer Training

« Last post by MaureenCooper on September 28, 2022, 03:14:15 PM »

Perfect.  Thank you so much.  I love this program

13

Q&A / Re: State Required Volunteer Training

« Last post by Annette on September 28, 2022, 09:34:10 AM »

You can track training for leaders in the Windows App under Leaders > Training History. You can also add your own custom training items. Go to Admin > System Settings > Generic Lookups and select the Category of Leadership Training on the left. On the right, add the item's Description (like "Mandatory Reporter Training"), the base club (use 'Awana' to apply to all leaders), and check that it is required.

These custom training items will then be available in the list of options when adding a training item to a leader's record.

To quickly add these records to all of your leaders, use multi-select in the Leader's grid along with the pop-up menu item of "Add Leadership training record".

14

Q&A / State Required Volunteer Training

« Last post by MaureenCooper on September 27, 2022, 09:15:17 PM »

California is now requiring a Volunteer Training Course to work with minors.  There are two types of Training -- Mandated Reporter Training and then Volunteer Training. Would you be able to add these trainings to Training Module?  I do record these trainings on a spread sheet, but I thought it would be good to put it into the database. What do you think?

15

Defects / Check-In and Progress Report Worksheet

« Last post by wdbaker54 on September 27, 2022, 03:24:46 PM »

In our club, the Cubbies do not participate in the nightly themes. The printed form for the Cubbies check-in report does include the nightly theme if they are printed with the other clubs and only if I print them separately does the theme not appear. This is not serious since there is a work-around. Just to let you know.

16

Q&A / Re: Name Tags

« Last post by Annette on September 19, 2022, 08:56:02 AM »

We will take a look and see if we can figure out what is causing that.

17

Q&A / Re: Name Tags

« Last post by MaureenCooper on September 13, 2022, 02:26:39 PM »

Here is another quirk.  When I go to print name tags, I preview it first and it is quirky in that it is not aligned correctly.  I close that screen and hit preview again. This time it shows correctly. If I do not do that 2nd preview, it prints incorrectly.

18

Q&A / Re: Name Tags

« Last post by Annette on September 06, 2022, 09:24:19 AM »

Student leaders should be included, but I see they aren't. We will look into getting this fixed. Thanks for bringing it to our attention.

19

Q&A / Name Tags

« Last post by MaureenCooper on September 01, 2022, 09:20:50 PM »

For leader name tags, it does not give me student leaders.  The only option is selecting Journey clubber.  Then it does not give me icon for the club they are working in.

20

SQL Workbench / Re: Missing awards query

« Last post by Rick Leffler on April 29, 2022, 09:26:05 AM »

The following query will list any persons with a completed book for which there is no corresponding book-level award. Note: This applies ONLY to the LEGACY desktop version (not the cloud version).  Depending on when you run this, you may need to adjust the dates of course.

select p.filing_name, b.book_name, b.completed_date
from person p, book b
where p.person_id = b.person_id
and b.completed = 'Yes' and completed_date > '2021-8-1'
and book_id not in (select book_id from award where award_source = 'Book' and date_earned > '2021-8-1')