In order to make it possible to have all the surveys and answer responses available for report building and database wide analysis, Esensorics generates flat tables that contain all the data in columns. Survey fields: publishedOn - time stamp when the survey was published createdByUser - name of the admin user who created the survey sampleDescription - sample description sampleName - sample name surveyName - survey name Sample fields: answerComment - every question in Esensorics has comment box:  . The text saved in this comment box is here. answerKeyLabel - The text label of the response answer choice answerKeyStaticLabel - The text label of the response answer choice above the slider value (only used for slider) answerKeyValue - stores the value of selected answer defined by admin answerValue - stores the position of selected answer fieldLabel - field/question name fieldType - field/question type, eg select, slider, textfield, etc User fields, same logic as for sample fields, names start with U: UanswerComment UanswerKeyLabel UanswerKeyStaticLabel UanswerKeyValue UanswerValue UfieldLabel UfieldType userid   |
3. Clicdata >