Support

Radio buttons, export to Excel

Last post 05-21-2008, 10:35 AM by Gordon. 2 replies.
Sort Posts: Previous Next
  •  05-19-2008, 10:39 PM 7027

    Radio buttons, export to Excel

    It seems that all checked radio button entries get dumped into a single Excel field. This is bad for tracking. We wnat to ask if people want
    a) their kid to sleep in the same room with other kids
    b) whether people attend for the first time and therefore need assistance

    These should be dumped into separate columns in the Excel sheet so that we can tally the counts.

    Generally it would be nice to have fields with yes/no answer
  •  05-20-2008, 11:38 AM 7033 in reply to 7027

    Re: Radio buttons, export to Excel

    If you want them to be dumped in a separate column then you have to add this column as a Database field. See: http://help.wildapricot.com/display/DOC/Customizing+your+member+database

    Create one field with Yes and another with No. 



    Denys Zlobin
    Helpful Apricot
    http://www.wildapricot.com

  •  05-21-2008, 10:35 AM 7072 in reply to 7033

    Re: Radio buttons, export to Excel

    I had the same problem and solved it with the Excel Pivot Table tool.

    A Pivot Table is a bit of a challenge to figure out but it will provide a count of the number of occurrences of each unique item in any column.  I had about six different options for each question so a different column for each answer was not a workable solution for me.

View as RSS news feed in XML
Copyright © 2008. Wild Apricot (TM) by BonaSource Inc.
Terms of Use   Privacy Policy   Billing and Refund policy

Contact us: 144 Front Street West, Suite 725, Toronto, Ontario M5J 2L7, Toll-free phone: 1-877-270-4268, support@wildapricot.com