Form responses

after you have collected responses for a form, you can view those responses in form responses docid\ qbdlka yzjmozhsqlfw k , form responses docid\ qbdlka yzjmozhsqlfw k , or form responses docid\ qbdlka yzjmozhsqlfw k views from within the form, review or survey to view form responses from the left sidebar, select people ops tools select forms select the responses tab form response summaries form responses summary all availible responses to the form will be displayed in a default chart type if you would like to do additional analysis or share the responses with others, you can build a custom dashboards docid\ ka8 kvt0aui ekf7mecld by copying the carrot reference docid\ fl emyhb9f8nzl2vza9fq expression next to the graph group responses by using the dropdown at the top of the page, you are able to select a demographic field to split out the results by such as department or tenure range these allow you to do quick analysis for anonymous and de identified surveys & forms docid\ kexbckk0plhmifv1npcqf the options displayed will be restricted to the set of "recorded" fields " form responses sheet the sheet is a highly versetile way to view your form response data it feels in many ways like a spreadsheet a few features view approval or release states see all responses both current and historical copying and pasting to a spreadsheet or document navigating with your keyboard like a spreadsheet (along with keyboard tool like shift+arrows to select) quick count/sums/average form responses sheet view approval status if a form requires approval, you are able to see the status of that approval right within the table individual form responses the third tab allows you to view, search and filter individual form responses in a visual card format filter the responses or scroll to view additional responses editing form responses if you need to modify data for a form, survey or review, it is best to edit the form response rather than edit the field directly if you are editing a field within the form, that field value will be updated as well if you have access to edit form responses then you have the following options to edit a form response on the sheet view find the form response click the expand icon to view the individual response if you have proper permissions, you will see an pencil icon click the pencil icon to edit the form response edit the form response, then save to edit a form response on the individual view find the form response using the filters if you have proper permissions, you will see an pencil icon click the pencil icon to edit the form response edit the form response, then save filter responses for example, if you want to see the responses submitted by the sales department or forms that are about people who are managers you are be able to filter the results by who submitted the form who the form is about depending on the setup of your form, the options will vary depending on the settings of your form for example if those are the same person, then you will only see a filter for the "submitted by " filter responses by time range want to see all the survey responses from last year? no problem note this is only available on the forms page surveys and reviews will limit the response to submissions associated with that survey or review the form responses you have access to are you are the person who submitted the form response you have read access to at least one of the fields in the form response if the form is a mix of fields you do and do not have access to, you will see the response, but you will only see the responses to the fields you have access to form response access & visibility if you have access to a form, survey or review, then you will have access to the responses sheet this does not mean that you will have access to all of the form responses regular access roles and permissions still apply access to responses to questions depends on how the form is setup and how it is used form response visibiility rules situation can they view it if the user is the respondent ✅ you can always view your own responses to forms if the user is in a built in roles docid 47kdsxxzvdmh8nqhsj27i , defining a custom role docid wqkyl bv1qg2j9obe7uf with the formresponse\ read permissions docid\ noctbwb38zu91ijaq0cpm ✅ owners are the only built in role with this permission if the user has view, edit or owner access to the survey or review ✅ giving access to a survey or review allows people to see responses if the form response is hidden from who the form is about due to a workflow state such as unapproved, rejected, or unreleased ❌ they cannot view until the form is out of that workflow state all other users ❌ do not have access to the form response field access in form responses if there is a mix of fields and questions in the form response, the field sensitivity will overrides the form response visibility fields docid\ xyrlltzxie bv4zkzes g have a configured field sensitivity such as org public or private questions do not for example if a user has access to view the form response but does have access to the field, then the form response will be displayed with responses to all questions, but will not display the fields the user does not have access to importing & exporting form responses exporting form responses the form response exporter will export the form responses display, so it will apply any of the filters for submitted on, submitted by, or about to export your form responses as a csv navigate to the form > responses tab set the correct time range and filter for the responses that you would like to export in the right corner, select the import/export button, then select export form responses as csv in the dialog, select from the exporting data from the data sheet docid\ zznndmq09j6ubpvebbifw then select export csv your export will then be generated in the dialog, select download export importing form responses importing form responses can be useful for migrating a form or form responses from another system (ie a previous performance review) adding responses after a deadline or a form has closed uploading responses for special stakeholders (ie an executive who doesn't follow the normal process) bulk updating or modifying existing form responses to upload a form response create a csv of the form responses that you would like to import ensure that the form in charthop contains all of the questions or more that you would like to import if you are importing a new form from another system, you will have to recreate that form within charthop navigate to the form > responses tab in the right corner, select the import/export button, then select import form responses create a csv that aligns to your form click the download example csv template in the modal to get a form a starting point see below for additional guidance about building out your csv select the csv upload the csv and import the form responses form responses csv columns we recommend your click download example csv template in the modal to get a form a starting point for your import required columns submitpersonemail the email address of the person who submitted the form identified & de identified forms the email address of the person who submitted the form anonymous forms left blank, but must be included as a column submitat the date/time the form was submitted accepted date/time formats iso format 2024 09 06t07 44 05z date formats 9/6/2024 or 2024 09 06 (time will be set to 12 00 am) date & time with timezone 2023/10/24 3 15 41 pm ast (google sheets default) one column per question in the form match using the text of the question (ex any other thoughts you'd like to share?) the linked field name, if applicable (ex additional thoughts) you can leave out some questions if you wish only questions currently in the form can be uploaded previous questions, which may still be listed in the response table, cannot be uploaded response must align with the format and constraints of a question or field for example single select must you one of the values (ex agree) yes / no must use either use yes or no other columns externalid identifier of the form response if importing from another system optional targetpersonemail email address of the person who the form is about required if the form settings for who is this form about? > another person assessment name of the review or survey the form response is tied to 🚧 we only suggest using this if you already have this form linked in the review or survey approvalstatus the status of the form response if it has approval or review steps accepted values unreleased proposed approvalat timestamp of the approval approvalemail email address of the person who approved the form releaseat timestamp of the release releaseemail email address of the person who released the form