Recent Posts

Pages: 1 [2] 3 4 ... 10
11
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.
12
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.
13
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.
14
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.
15
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.
16
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')
17
SQL Workbench / Missing awards query
« Last post by Donzo on April 28, 2022, 11:57:10 AM »
I'm looking for a query to identify awards that were not generated.

-Don
18
Videos / Other Cloud Database Videos
« Last post by Annette on March 25, 2022, 09:23:14 AM »
Our Cloud Database includes a Web App and a Windows App.

Because of its similarity to the Legacy database, videos and information about the Windows App can be found here on the forum.

Videos and information about the Web App can be found at our AWdb Cloud Database Support site: https://approvedworkman.freshdesk.com/support/home
19
Announcements / Forum Layout Changes
« Last post by Annette on March 24, 2022, 10:26:04 AM »
The AWdb Forum was originally created for the Legacy database - to ask and answer questions, report bugs, suggest enhancements, and share ideas. It's been a valuable resource for our Approved Workman user community for many years. Thank you to everyone who has contributed!

With the addition of the AW Cloud database, we added new boards for those same topics to be handled for the Cloud Database. What we found is that many of the posts on the forum relate to BOTH the Legacy database and the Cloud database's Windows App and we needed a better way to organize the information.

With that in mind, we will be consolidating the postings into a single set of Boards (FAQs, Tips, Q&A, etc.) instead of splitting them between Legacy and Cloud. Posts will have a notice indicating the product/s to which the topic applies. To quickly tell which product a post discusses, we will be updating the icons to indicate the post is for:

  The Cloud Database only

  The Legacy Database only

  Both Databases

We hope that these changes help you better navigate the resources of the forum!

Best regards,
The AWdb Support Team
Rick, Sherri, Annette
20
FAQs / Why isn't a clubber/leader showing up for Check-in?
« Last post by Annette on February 15, 2022, 11:59:23 AM »
This post only applies to the Legacy database!

Questions: I have 3 kids who were not coming back to club this year (moving away, etc); but now they are back. I changed their status from inactive to active and assigned them a team; but, when I click the Check-in tab to record attendance, they are not listed.  Any ideas?

I have a problem getting 3 leaders that were archived, reassigned to a club, and made active to show up on the Check-In worksheet. I have this problem for one other new leader also. I have made sure that the "primary" box is checked. Why aren't they showing up?

Answer:

When clubbers or leaders do not show up on the Check-in List grid or in the Check-in and Progress Report Worksheet, it is because they have no Session records (weekly attendance records). To fix this:

Open their individual Member record and be sure there is a valid Club Name. Then click the Attendance tab. If you do not see records, click SAVE and they will be created. If you see wrong records (i.e., the wrong Club Name), then right-click and select the popup menu item to delete all session records for the selected club. Then click SAVE and the correct set of session records will be created based on a valid club name on the main tab.

If the Session records are still not showing, go to Admin > Database Utilities and run the Optimize procedure. This will create any missing session records as long as there is a Club Name assigned.
Pages: 1 [2] 3 4 ... 10