# user_input Survey User Input ## Documentation Metadata for a set of one user's answers to a particular survey - Catalog: `Odoo` - Schema: `survey` The data in this table is partitioned per value of the column. This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API. ## Table Columns The columns of the table `user_input` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `access_token` | `string` | Identification token | ☑ | | | `activity_calendar_event_id_label` | `string` | | ☐ | | | `activity_calendar_event_id` | `string` | | ☐ | | | `activity_date_deadline` | `datetime` | Next Activity Deadline | ☐ | | | `activity_exception_decoration` | `string` | Activity Exception Decoration | ☐ | Type of the exception activity on record. | | `activity_exception_icon` | `string` | Icon | ☐ | Icon to indicate an exception activity. | | `activity_ids` | `string` | | ☐ | | | `activity_state` | `string` | Activity State | ☐ | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | | `activity_summary` | `string` | Next Activity Summary | ☐ | | | `activity_type_icon` | `string` | Activity Type Icon | ☐ | Font awesome icon e.g. fa-tasks | | `activity_type_id_label` | `string` | | ☐ | | | `activity_type_id` | `string` | | ☐ | | | `activity_user_id_label` | `string` | | ☐ | | | `activity_user_id` | `string` | | ☐ | | | `attempts_count` | `int32` | Attempts Count | ☐ | | | `attempts_limit` | `int32` | Number of attempts | ☐ | | | `attempts_number` | `int32` | Attempt n° | ☐ | | | `create_date` | `datetime` | Created on | ☐ | | | `create_uid_label` | `string` | | ☐ | | | `create_uid` | `string` | | ☐ | | | `deadline` | `datetime` | Deadline | ☐ | Datetime until customer can open the survey and submit answers | | `display_name` | `string` | Display Name | ☐ | | | `email` | `string` | Email | ☐ | | | `end_datetime` | `datetime` | End date and time | ☐ | | | `has_message` | `boolean` | Has Message | ☐ | | | `id` | `int32` | ID | ☐ | | | `invite_token` | `string` | Invite token | ☐ | | | `is_attempts_limited` | `boolean` | Limited number of attempts | ☐ | Check this option if you want to limit the number of attempts per user | | `is_session_answer` | `boolean` | Is in a Session | ☐ | Is that user input part of a survey session or not. | | `last_displayed_page_id_label` | `string` | | ☐ | | | `last_displayed_page_id` | `string` | | ☐ | | | `message_attachment_count` | `int32` | Attachment Count | ☐ | | | `message_follower_ids` | `string` | | ☐ | | | `message_has_error_counter` | `int32` | Number of errors | ☐ | Number of messages with delivery error | | `message_has_error` | `boolean` | Message Delivery error | ☐ | If checked, some messages have a delivery error. | | `message_has_sms_error` | `boolean` | SMS Delivery error | ☐ | If checked, some messages have a delivery error. | | `message_ids` | `string` | | ☐ | | | `message_is_follower` | `boolean` | Is Follower | ☐ | | | `message_main_attachment_id_label` | `string` | | ☐ | | | `message_main_attachment_id` | `string` | | ☐ | | | `message_needaction_counter` | `int32` | Number of Actions | ☐ | Number of messages which requires an action | | `message_needaction` | `boolean` | Action Needed | ☐ | If checked, new messages require your attention. | | `message_partner_ids` | `string` | | ☐ | | | `my_activity_date_deadline` | `datetime` | My Activity Deadline | ☐ | | | `nickname` | `string` | Nickname | ☐ | Attendee nickname, mainly used to identify them in the survey session leaderboard. | | `partner_id_label` | `string` | | ☐ | | | `partner_id` | `string` | | ☐ | | | `predefined_question_ids` | `string` | | ☐ | | | `question_time_limit_reached` | `boolean` | Question Time Limit Reached | ☐ | | | `scoring_percentage` | `decimal` | Score (%) | ☐ | | | `scoring_success` | `boolean` | Quizz Passed | ☐ | | | `scoring_total` | `decimal` | Total Score | ☐ | | | `scoring_type` | `string` | Scoring | ☐ | | | `slide_id_label` | `string` | | ☐ | The related course slide when there is no membership information | | `slide_id` | `string` | | ☐ | The related course slide when there is no membership information | | `slide_partner_id_label` | `string` | | ☐ | Slide membership information for the logged in user | | `slide_partner_id` | `string` | | ☐ | Slide membership information for the logged in user | | `start_datetime` | `datetime` | Start date and time | ☐ | | | `state` | `string` | Status | ☐ | | | `survey_id_label` | `string` | | ☐ | | | `survey_id` | `string` | | ☐ | | | `survey_time_limit_reached` | `boolean` | Survey Time Limit Reached | ☐ | | | `test_entry` | `boolean` | Test Entry | ☐ | | | `user_input_line_ids` | `string` | | ☐ | | | `website_message_ids` | `string` | | ☐ | Website communication history | | `write_date` | `datetime` | Last Updated on | ☐ | | | `write_uid_label` | `string` | | ☐ | | | `write_uid` | `string` | | ☐ | |