When editing a form layout bear in mind that any sections that you set to be collapsible and 'initially hidden' cannot contain any mandatory fields. If the section does contain a mandatory field then ...
- Welcome to the Knowledge Base
- Supported browsers
- Landing Pages
- HTML Editor
- Welcome Messages & Bulletins
- Exporting Data
- Multi Language
- Notifications & Reminders
- Forecasts & Quotas
- Introduction to Importing
- Preparing your Import Data
- Workbooks Import Wizard
- Managing your Imports
- Mailing Lists
- Marketing Campaigns
- Upload Library
Workbooks Web Insights
- Tracking Code
- Setting up the Plugin
- Viewing Web Insights Data on your Form Layouts
- Domain Names and Online Activities
- Reporting incorrect Leads created through Web Insights
- Reporting on Web Insights data
- Using UTM Values
- Why aren’t Online Activities being created in the database?
- Why is GatorLeads recording online activities in a foreign language?
- Using HubSpot with Workbooks
- GatorMail Integration
- People & Organisations
- Introduction to Reporting
- Displaying Reports
- Creating Reports
- Reporting Explained
- Emailing Scheduled Reports
- Sharing Reports
- Using Calculated Columns
- Displaying reports within Record Views
- Audit Reporting
- Compliance Record
- Data Enrichment
- Introduction to Transaction Documents
- Credit Notes
- Customer Orders
- Supplier Orders
- Contract Management
- Adobe Sign Integration
- Introduction to Zapier
- Available Triggers and Actions
- Linking your Workbooks Account to Zapier
Setting up Zaps
- Posted Invoices to Xero Invoices
- Xero payments to Workbooks Tasks
- New Case to Google Drive folder
- New Case to Basecamp Project
- Jira Issue to new Case
- New Workbooks Case to JIRA Ticket
- Wufoo Form Entry to Sales Lead
- Eventbrite Attendee to Sales Lead and Task
- Facebook Ad Leads to Sales Leads
- Posted Credit Note to Task
- Survey Monkey responses to Tasks
- Multistep Zaps
- Outlook Connector
- Exchange Server Sync
- Workbooks Mobile Client
- Introduction to System Administration
Users & Security
- User Groups
- Account Settings
- Licences & Modules
Email & Integration
- Email Settings
- API Keys
- Web to Case and Web to Lead
- Preference Centre
- MailChimp, Constant Contact & dotMailer
- Postcode Lookup
- SharePoint Integration
- Bank Account Validation
- Creating & Modifying Picklists
- Creating Custom Fields
- Report-based Custom Fields
- Record Templates
- Form Layouts
- Customising relationships between parties
- Opportunity Stages
- PDF Configuration
- Releases & Roadmap
- Workbooks Glossary
- Contact Support
Import templates can be generated from Workbooks to help you import your data. An Import Template is a CSV or XLS file, with column headers that correspond to record form fields inside Workbooks, so when it comes to configuring the import mappings during the import, you will be working with a one-to-one mapping between source data and Workbooks form fields. Import Templates can be generated for any type of import, and also for imports of more than one record type such as People and Employer for example.
To generate an Import Template go to Start > Import > New Import Template.
Select the Record type for the Import Template that you wish to generate. In this example, we will choose People.
Imports can be extended to include other related record types and, in some cases, multiple records of the same type. The window below gives you to the option to choose any additional record types to include in the Import template. You can add multiple instances of each record type if required. This will simply add more columns in your Import Template.
At the field mapping stage during Import, you can see how this list of options corresponds to the extended dropdown.
You may not wish for your Import template to contain all the fields available for that record type. At this stage, you can restrict the columns generated to only be those found in a particular form layout.
NOTE: The template will also include the standard reference columns Id, Object Ref and External Reference to enable unique identification when performing an update through import.
If you chose to extend to additional record types in the previous screen, you will also be able to restrict the columns based on their respective form layouts in the same way. The end result is your Import Template in a grid view - to export this to CSV or XLS click the Export button.
See how the generated template accounts for the extended record type by prefixing the column name with the respective record type.
Your data can now be cleansed and manipulated to fit the Import Template structure for easy import. During your import, when you reach the Define Field Mappings stage, most mappings will be automatically be found for you because you have used the Import Template. However, you will still need to manually extend the import and map source data in order to form fields for any extended record types (example below).