Answers.Body: <p>If the iPads are connected to the internet, then you can create a profile form (or Webform if your site uses Drupal) and they can submit it directly.</p>
  
  <p>I'm not aware of an offline app but others may know of one.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-14T20:56:07.747Z
Answers.LastActivityDate: 2017-02-14T20:56:07.747Z
Answers.UserDisplayName: Coleman
Answers.Body: <p>I was looking at a similar solution for one of my clients a while back, where they were very likely to be offline. A quick Google search (I think I searched for 'offline forms iOS' or somesuch) revealed that there are plenty of relatively low cost solutions out there that will let you create forms on an iPad and save all the data submissions into a CSV or similar that can then be sucked in to your Civi DB.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-21T18:29:59.250Z
Answers.LastActivityDate: 2017-02-21T18:29:59.250Z
Answers.UserDisplayName: Graham
Body: <p>I am trying to help my co-operative optimze their workflow. </p>
  
  <p>At the moment:</p>
  
  <p>Surveys are conducted during home visits straight into (a very fiddly) excel spreadsheet.
  Then when back in the office the employee enters some of the data from the spreadsheet into CiviCRM and the rest is retained in the spreadsheet (mainly because it takes too long to transfer all the data). </p>
  
  <p>Two routes come to mind:</p>
  
  <ol>
  <li><p>Use the Survey functionality to create a form that can be viewed on the ipad - would this then be viewed through a webpage or is there an app available for this?</p></li>
  <li><p>I create my own form or app which can output a CSV file. This could then be uploaded to Civi relatively easy and also easily transferred to Excel/reports. </p></li>
  </ol>
  
  <p>If anyone can point me in the right direction for how to use CiviCRM more effectively that would be fantastic!</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-02-15T01:10:58.813Z
Comments.Text: If you are collecting data in a spreadsheet then you might want to import as Activities, shouldn't take any longer to do for one field than for 20 once you have the field mapping set up. if the contacts don't yet exists in civi, then you need to import the contacts (give them an external id as you do this) and then use that same external id to match the Activity to the contact.
Comments.UserDisplayName: petednz - fuzion
Tags: <ui><civisurvey>
Title: What is the best way forward to conduct surveys on an iPad?
ThreadText: # What is the best way forward to conduct surveys on an iPad?
  
  (Asked by: username_0 on 2017-02-14)
  
  I am trying to help my co-operative optimze their workflow.
  
  At the moment:
  
  Surveys are conducted during home visits straight into (a very fiddly) excel spreadsheet.
  Then when back in the office the employee enters some of the data from the spreadsheet into CiviCRM and the rest is retained in the spreadsheet (mainly because it takes too long to transfer all the data).
  
  Two routes come to mind:
  
  1. Use the Survey functionality to create a form that can be viewed on the ipad - would this then be viewed through a webpage or is there an app available for this?
  2. I create my own form or app which can output a CSV file. This could then be uploaded to Civi relatively easy and also easily transferred to Excel/reports.
  
  If anyone can point me in the right direction for how to use CiviCRM more effectively that would be fantastic!
  
  **Tags:** ui, civisurvey
  
  > **Comments:**
  > **username_1**: If you are collecting data in a spreadsheet then you might want to import as Activities, shouldn't take any longer to do for one field than for 20 once you have the field mapping set up. if the contacts don't yet exists in civi, then you need to import the contacts (give them an external id as you do this) and then use that same external id to match the Activity to the contact.  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2017-02-14. Score: 3
  
  If the iPads are connected to the internet, then you can create a profile form (or Webform if your site uses Drupal) and they can submit it directly.
  
  I'm not aware of an offline app but others may know of one.
  
  
  ---
  
  ### Answer by username_3 on 2017-02-21. Score: 1
  
  I was looking at a similar solution for one of my clients a while back, where they were very likely to be offline. A quick Google search (I think I searched for 'offline forms iOS' or somesuch) revealed that there are plenty of relatively low cost solutions out there that will let you create forms on an iPad and save all the data submissions into a CSV or similar that can then be sucked in to your Civi DB.
  
  
  ---
  
  