Approved Workman Database

Info and Training => FAQs => Topic started by: Rick Leffler on February 07, 2013, 06:10:42 PM

Title: Can I use AWdb to track VBS (or Camp) attendance?
Post by: Rick Leffler on February 07, 2013, 06:10:42 PM

 This post is applicable for the Cloud database, but requires use of the Web App. It is primarily applicable in the Legacy database. Details are noted below.

Yes, AWdb may be used to track VBS or Camp attendance.

For 2023 VBS:

Finish the current Awana Club Year. DO NOT proceed setting up VBS until you're done with the 2022-2023 club sessions.

Legacy only:

• Make sure you have the latest version of AWdb.
• Go to Admin > Database Utilities and run the Backup utility.
• Go to Admin > Generic Lookups and select Club Years. Add a new record to represent the specific VBS year. For example, type "VBS 2023" as the Club Year value and then type a Logical Order value that is one greater than what is shown for the current 2022-2023 club year. Select "1" as the meeting interval. Click the checkmark at the bottom of the grid to post the new record.

In the Legacy database, go to Database Utilities and click the New Year Setup button.

For a Cloud database, the New Year Setup is run in the Web App. See this post for details: https://approvedworkman.freshdesk.com/support/solutions/articles/16000187846-setup-the-database-for-vbs (https://approvedworkman.freshdesk.com/support/solutions/articles/16000187846-setup-the-database-for-vbs).

Complete the steps in the New Year Setup dialog:

• Session Dates/Club Names - select "VBS 2023" as the Club Year. Enter the VBS starting and ending dates. Review/add/edit the specific "Club Name" records for VBS. Note: All records should have a Base Club value of "VBS". Like Awana, a specific Grade and Gender may only be assigned to a single Club Name.
• (Legacy only) - Promotions - be careful about whether or not to Promote each clubber's School Grade to the next level. It's ok to do it for VBS, but if you do, then DO NOT PROMOTE AGAIN when you run the New Year Setup for the next Awana club year. [In the Cloud Database, clubbers will not be promoted during VBS setup, but will be promoted for the new Awana club year.]
• Club Assignments - set a Club Name value for each Grade and Gender record.
• (Legacy only) - Resets & Defaults - review each field to decide how to handle resets.
• Run the Procedure - click the Begin Processing button to generate the VBS attendance records.

After running the New Year Setup procedure, VBS participants' attendance may be tracked under the Check-in module. The "Registration Form" report may be customized by changing the Report Heading in the "Options" section. Other reports may also be helpful, like the Clubber List, Mailing labels, Name Tags, etc.

Note: To track Camp attendance, follow the same instructions but substitute "Camp" for "VBS".