---
title: "Surveys Table"
canonical: "https://help.agiloft.com/space/SD/44433947/Surveys+Table"
format: markdown
---
The Surveys table stores all the surveys that are sent to suppliers during their onboarding or review processes. 

# Creating Records

Surveys are typically generated from [Supplier Profile](https://agiloft-public.atlassian.net/wiki/spaces/SD/pages/44433957) records. From the Surveys tab, the supplier manager can select the types of surveys to generate and then click Generate Surveys to create the Survey Records.  

Once a survey is assigned to a supplier, a notification email is sent. To complete the survey, the supplier clicks the hyperlink in the email. They’re logged in to the KB as a Guest and taken directly to the Survey record without having access to anything else.

Survey records are owned by the assigned submitter.

# Related Tables

The diagram below shows the default incoming table relationships and linked fields in the Surveys table.

![Default table relationships for the Surveys table](media://d4761051-718b-49bd-a3af-2f498a902d17)

# Fields

In addition to the [standard fields](https://agiloft-public.atlassian.net/wiki/spaces/SD/pages/44434023/Table+Concepts#standard_fields), the out-of-the-box Surveys table includes the following fields.

| **Field Label** | **Data Type** | **Description** |
| --- | --- | --- |
| Button: Reassign Survey | Action button | Can be used by the supplier to assign the survey to someone else. |
| Button: Submit | Action button | If Status is New or In Progress, this button is visible and is used to submit the survey. |
| Cancel Survey | Action button | Sets Status to Canceled and notifies the submitter that a response is no longer required. |
| Date Due | Date | The survey’s due date. |
| Date of Next Recurrence | Date | If it’s a recurring survey, this field lists the date of the next occurance. |
| Definition ID  
Number of days to complete  
Recur Every  
Recurring Survey  
Survey Definition  
Survey Type  
Time Interval | Link to selected fields from other table: Survey Types | Lists details from the related Survey Type record. |
| Internal Notes | Append Only Text | Internal notes that are not visible to the supplier. |
| Linked Company  
Company ID  
Company Status | Link to selected fields from other table: Companies | The supplier’s company. |
| SC Assigned Person  
SC Assigned Team  
SC Customer Login  
SC Customer Name  
SC Customer Phone  
SC Date Closed  
Support Case ID  
SC Priority  
SC Summary  
SC User Company | Link to selected fields from other table: Support Cases | Identifies the linked Support Case if there is one. |
| Source Survey ID | Link to selected fields from other table: Surveys | For recurring surveys, this field displays the ID of the original source survey. |
| Status | Choice:<br>Canceled, Superseded, Submitted, In Progress, New | The current state of the survey. |
| Submitter Company  
Submitter Phone  
Submitter Email  
Submitter Name  
Submitter ID  
Submitter Login  
Submitter Team | Link to selected fields from other table: People | Lists details about the user assigned as the submitter. |
| Supplier Profile Manager  
Supplier Profile Company  
Supplier Profile Company ID  
Supplier Profile Goods/Services  
Source Supplier Profile ID  
Supplier Profile Primary Contact  
Supplier Profile Primary Contact Email  
Supplier Profile Primary Contact ID | Link to selected fields from other table: Supplier Profiles | Lists details from the linked Supplier Profile. |
| Survey Questions | Survey Presentation Field | Lists the questions included in the survey. |

# Automation

This section describes the rules that are implemented for the out-of-the-box Surveys table. For details about rule configuration options, see [Rules](https://agiloft-public.atlassian.net/wiki/spaces/HELP/pages/43714473) in the CLM Help.

- **Create: All Create actions (email, web, API)**: This rule runs when Survey records are created. Depending on the source of the Survey or the Survey Type, it sets the appropriate Submitter. If it is a recurring Survey, it sets the Date of Next Recurrence. If the 'Number of days to complete' value is provided, it also sets the Date Due for the Survey. For Surveys created as part of Supplier Onboarding and for recurring Surveys of any type, it sends an email to the Submitter with a link to respond to the Survey.
- **Edit: All Edit Actions (web, API)**: This rule runs when Survey records are edited and performs the following actions:
  - If the status is New, it’s set to In Progress.
  - If a Supplier Profile related Survey is Submitted, it sends a notification to the Assigned Supplier Manager for the Supplier Profile.
- **TB Demo Data Update: Update date fields by one month each month so reports have data**: This time-based rule runs on the 13th day of each month at 10:30pm. It updates date fields for demo data records so they stay current.
- **TB: (DISABLED) Trigger Recurring Survey**: This time-based rule is disabled by default. If enabled, it would find all Surveys where the linked Company is Active and the Date of Next Recurrence is today. A conversion action creates a new recurring Survey and sets the status of the current one to Superseded.
- **TB: (DISABLED) Send Survey Reminder Day Before Due Date**: This time-based rule is disabled by default. If enabled, it would send a reminder to the survey responder the day before the survey is due, if they haven't completed it yet.