Recent Posts

Pages: 1 ... 5 6 [7] 8 9 10
61
Q&A / Projected awards on report
« Last post by MaureenCooper on April 24, 2020, 12:44:48 PM »
Note: This post only applies to the Cloud database's Windows App!

There are multiple projected completed book awards on the clubber status report. For instance, they show the 5th book award, Milestone 3 times. 
 
62
Videos / Working with Grids
« Last post by Annette on April 10, 2020, 12:19:27 PM »
All information regarding working with grids is applicable in the Cloud database's Windows App as well as in the Legacy database.

Grids are used throughout the AW database. Understanding how to customize a grid and manipulate the data in the grid will increase efficiency in data entry and provide helpful information about the data. This video will cover:

Customizing the Grid: Showing / Hiding header bands and columns
Manipulating Data: Sorting; Grouping; Filtering
Finding Records: Incremental searches; Search boxes

http://www.approvedworkman.com/videos/Working_with_Grids.mp4

Note: the video does not cover selecting multiple records in the grid.  For that information, please see this post: https://www.approvedworkman.com/forum/index.php?topic=389.0.
63
Videos / Inventory - Beyond the Basics
« Last post by Annette on April 10, 2020, 12:17:40 PM »
While this video applies specifically to the Legacy database, much of the process also applies to the Cloud database's Windows App.

The Getting Started Series of videos included basic information about the Inventory.  This video provides additional information for those planning to track inventory in the database. It covers the initial setup and a quick look at Orders.

http://www.approvedworkman.com/videos/Inv_BeyondBasics.mp4
64
Videos / How to Create Ad-hoc Reports
« Last post by Annette on March 26, 2020, 11:00:41 AM »
All information regarding ad-hoc reporting is applicable in the Cloud database's Windows App as well as in the Legacy database.

Sometimes you need information that is not readily available with the formal reports.  In that case, you can often get the information you need through an ad-hoc report.  Ad-hoc reports are created by customizing a grid and then printing or exporting the data.  This video uses an example of getting a list of clubbers who have attended at least once during the club year.

http://www.approvedworkman.com/videos/Ad-HocReporting.mp4
65
Q&A / Re: during Covid . . . kids passing sections at home
« Last post by DebLiveOak on March 25, 2020, 10:49:03 AM »
Thanks!!   ;D
66
Q&A / Re: during Covid . . . kids passing sections at home
« Last post by Annette on March 25, 2020, 10:45:46 AM »
[Note: I believe you are a Cloud database customer, so I am answering based on that. For Legacy database customers, there is an option under Admin > Options > Check-in to turn off the auto-check Club Attendance.]

As with many other new situations we are all navigating, we never anticipated clubbers saying verses remotely!

We do already have a request to make this an optional setting (like it was in the Legacy database).  We will see what we can do.

In the meantime, the best work-around is to clear the attendance for days you know you didn't meet. There is a quick and easy way to do this in the Windows App. On the main Check-in grid, set the club date at the top to a week you did not meet (like 3/24).  Filter the Attend Club column to show any that are true. With focus in the grid, press Ctrl+A to select all records. Then, right click to get the pop-up menu. There is an option to Set Attendance > Not Present.  When you select that, there will be a confirmation.  Click Yes and all of the attendance will be cleared.

[Note: there is also an option in the pop-up to Excuse attendance if any clubs want to go that route. A caution on this option: if you excuse all of the attendance, then mark a section on that date, it will override the excused absence and mark the attendance.]
67
Q&A / during Covid . . . kids passing sections at home
« Last post by DebLiveOak on March 24, 2020, 02:52:28 PM »
Note: This post generally applies to the Cloud database's Windows App. See note below regarding the Legacy database.

We are continuing to let kids pass sections while in isolation. We're using Facebook private group for parents to submit pics or video and they can also call their listener to say a verse over the phone. So I need to record the sections but not the attendance. Is there a way to turn off the attendance automatically being checked? I never thought I'd ask that because I really, really love that feature on a normal basis. But for the time being, I would love to be able to turn it off instead of logging sections and then unchecking attendance.
68
Q&A / Re: How to find a clubber with non-Primay E-mail?
« Last post by ckim551 on March 04, 2020, 06:05:45 PM »
That worked perfectly. Thank you for quick reply.
69
Q&A / Re: How to find a clubber with non-Primay E-mail?
« Last post by Rick Leffler on March 04, 2020, 05:21:18 PM »
You can use the SQL workbench under the Tools menu to find which household the email address in question belongs to.  Type (or copy/paste) the following statement into the SQL Workbench and replace "email@gmail.com" with the actual email address you're looking for:

select h.filing_name as Household, c.display_as, c.contact_person  from household h, communication c
where c.household_id = h.id and display_as = 'email@gmail.com'
70
Q&A / How to find a clubber with non-Primay E-mail?
« Last post by ckim551 on March 04, 2020, 03:03:13 PM »
Note: This post is applicable in the Legacy database as well as in the Cloud database's Windows App.

I've sent out an email to parents and got some returned email due to wrong email address.
I've got the email list using Gather Email Addresses.

Apparently the wrong email address is not a Primary Email.
How do I find out which clubber that wrong email address belong to?

Thanks,
Charles
Pages: 1 ... 5 6 [7] 8 9 10