Handbook Assigning Version Default - Not being followed

[msandy]

Note: This post is applicable in the Cloud database's Windows App as well as in the Legacy database.

Hey Rick,

I am liking the new features on 5102.  However, the default handbook version in the Handbook Assignment Dialog is not always followed.  I have set the default version as NIV, but sometimes it comes up as NKJV.  I have attached an example below.

Thanks

[Rick Leffler]

On that same member... check the Preferred Bible Translation value on the Misc tab of the Member form, any value set for a specific person overrides the club's default value, which is primarily used when creating new member records.

[msandy]

You're right.  In a random survey of 10 out of 300+ kids some are set to NIV and some to NKJV, and one wasn't to set to anything. 

I don't see a way to view that field in the clubbers grid.  Is there an SQL formula I can use to get a list of kids that have NKJV as their preferred version?

Thanks,

[Note: the translation can be shown on the Clubbers grid by making the column visible under the Primary Handbook header band. There is also a sql statement that can be used to update incorrect translations. See this post: https://www.approvedworkman.com/forum/index.php?topic=1258.msg4578#msg4578. akj]