Approved Workman Database

Community Contributions => Q&A => Topic started by: roscom on August 16, 2016, 08:32:09 AM

Title: Sparks Wings - not triggering without completion of Bring a Friend section
Post by: roscom on August 16, 2016, 08:32:09 AM
Note: This post is applicable in the Cloud database's Windows App as well as in the Legacy database.

This is our first year using AWdb.  We noticed that the Sparks wings for each of the Sparks handbooks only trigger at the completion of all Red Jewel 1 sections.  According to the Leader guides for the Sparks handbooks, the wings can be given with the completion of Red Jewel 1.2, 1.3 & 1.4 since the Red Jewel 1.1 Bring a friend section can be done at any time in the year.  It is rare that kids bring a friend by the time they complete the rest of the Red Jewel sections, so it is important to have the wings triggering if the other 3 sections are complete, but not RJ1.1.

Title: Re: Sparks Wings - not triggering without completion of Bring a Friend section
Post by: FBCEL_JDG on August 17, 2016, 11:00:59 AM
You can go in to the curriculum tab under the admin tab go into each book and mark that particular section of not required... that is what I did and this is my 4th or 5th year using the database.
Title: Re: Sparks Wings - not triggering without completion of Bring a Friend section
Post by: roscom on August 18, 2016, 11:23:47 AM
You can go in to the curriculum tab under the admin tab go into each book and mark that particular section of not required... that is what I did and this is my 4th or 5th year using the database.

Thanks so much for the tip; I'll do that.  Does marking it as "not required" affect anything negatively?
Title: Re: Sparks Wings - not triggering without completion of Bring a Friend section
Post by: roscom on August 19, 2016, 10:56:13 PM
Ok, I just figured out the negative outcome to making the Bring a Friend section not required.  It moves the section to the extra credit tab and prints out on the Current Handbook Report in the extra credit area as well.  Not good!!

Perhaps there needs to be a fix to AWdb instead of this type of work around.  Wings should trigger either at the completion of Red jewel 1 (4 sections) or at the completion of sections 2,3 & 4 of Red Jewel 1.
Title: Re: Sparks Wings - not triggering without completion of Bring a Friend section
Post by: Eric Berry on August 20, 2016, 11:13:05 AM
Try this:

1. Go to Inventory tab and create a new inventory item: Item #-BAF, Description-Bring-a-friend complete. On the Club Usage tab, select "Use this item as a choice in any AWARD related drop-down list".

2. Then go to Admin tab>Generic Lookups>Section Group Names.  Add a new Group Name: Bring-a-friend
(Note: In the Windows app, go to Admin > System Settings > Generic Lookups.)

3. Then go to the Curriculum tab, Open Sparks, then double click HangGlider, and open the Section Groups and Awards.
Create a new Section Group: Awards Set - Jewels, Section Group Name-Bring-a-friend, Award completed-Bring-a-friend complete.

4. Then click on Units and Sections, find Red Jewel 1:1 and change the Group Name to Bring-a-friend.

Then repeat steps 3 & 4 for the WingRunner and SkyStormer books.
Title: Re: Sparks Wings - not triggering without completion of Bring a Friend section
Post by: roscom on August 21, 2016, 12:49:51 AM
I tried your suggestion Eric.  The wings triggered after I checked off Red jewel 1.2,1.3,& 1.4 sections (skipping red jewel 1.1), however, red jewel 1 also triggered along with the wings.  Just the wings alone need to trigger.  Red jewel 1 waits to be awarded at whatever point the "bring a friend" section is completed later in the year.

Any further modifications that might improve the result?

I really appreciate your help.

Title: Re: Sparks Wings - not triggering without completion of Bring a Friend section
Post by: Eric Berry on August 21, 2016, 11:07:32 AM
I missed that part of your request.  I can't think of any way to do that.

We usually just just out the jewel even if the BAF section is not done.
Title: Re: Sparks Wings - not triggering without completion of Bring a Friend section
Post by: roscom on August 23, 2016, 10:11:39 AM
Eric, I've thinking about how to make your fix work for us as it seems to be the best option for now, until I can talk Rick into an enhancement.

What if:  when the wings and RJ1 trigger (without completion of RJ1.1 bring a friend), we selected "not received" for the jewel.

Would the "bring a friend" complete show up on the awards report?

Maureen

Title: Re: Sparks Wings - not triggering without completion of Bring a Friend section
Post by: Eric Berry on August 23, 2016, 11:16:15 AM
Yes, that would be the best work around solution.
Title: Re: Sparks Wings - not triggering without completion of Bring a Friend section
Post by: roscom on August 23, 2016, 11:31:14 AM
Thanks again for all your help, Eric.  We'll try that.  I just sent an enhancement request as well.