Checkbox values have changed format attribute

  • Profile Image
    Asked on May 22, 2014 at 04:04 AM

    Another problem/change which has happened since the 'glitch' on 21 May

    The values selected from a checkbox display on a new line for each value in teh Submissions report and in Google spreadsheet, but when I export this to Excel - all values were on one line concatenated.

    Now after 21 May all values in Excel have a line break inserted.

    This may not seem like a critical problem, however my Excel script can no longer work as there is now a mix of data formats.

    I am identifying this as it is another one of several data attributes that have changed since the recent system crash. Can you please reset all attributes as they were.

    Example here of days selected from a checkbox and exported to Excel. The entries in RED are from 21 May.

    different checkbox formats

  • Profile Image
    Answered on May 22, 2014 at 06:35 AM

    I fixed this for existing data by un-integrating Google sheet, deleteing it and re-integrating it. However until I get more submisisons in I wont know if its fixed for new entries.

    Will update Thanks

  • Profile Image
    Answered on May 22, 2014 at 10:50 AM

    Okay, thanks for this and be sure to keep us updated. Our apologies for the inconvenience which the glitch caused.