Claravine can automatically generate a file with the data from every submission. Administrators can design the emailed file, what data to include in the file, and where to send it per template.
To add email send to a template:
- Navigate to Settings → Templates and click Connect.
- Click Add (plus + sign) to add a new outbound integration. Select the Connected Account to map to design the outbound file format to apply to submission data out of Claravine.
- Click Email Send. The Email Send configuration section displays.
- Enter the Integration Name. If no value is entered, Claravine defaults the Integration Name to the Template name.
Email Configuration - Enter email addresses in the To, CC, and BCC fields to copy on every submission using this template. Press the Enter key after entering each email address to save it.
If the email address doesn’t turn into a gray pill with the email in it, it’s not yet accepted. - Enter the Email Subject Line. If you want to use one of the metadata fields available in the Subject line, click the Insert button. Available options are: Template Name, Submission Name, Submitted At, Submitted By. You can select more than one of the options.
If no value is entered, Claravine will default the Subject Line to "Submission made for {Template Name}". - Check the box to send a copy of the email to the submitter.
Export File Configuration - Define the Filename. Add text your own text, or click the Insert button to select Template Name, Submission Name, Submitted At, or Submitted By to add one or more of these dynamic values to the generated Filename. (Submitted at will return YYYY-MM-DD_HH-MM-SS in UTC).
- Select the File Type. Options are CSV, XLSX, JSON. You may select more than one file type.
- Select the Delimiter. Options are comma (,), semicolon (;), tab, and space.
- Check the box to Include Summary Header in the file output, or exclude it to begin the file with the field headers. The Summary Header includes:
- Date
- User Name
- Targets
- Template
- File configuration options are Custom or Default Summary.
- Default Summary matches the schema in Step 2 Define and Govern schema. If the visible box is unchecked in the schema, it will not be included in the file.
- Custom allows field-specific changes:
- Include or exclude the field from the file
- Change the Output Label/column header
- Manually drag the tile to change the order
- Transform menu: Update all Output Labels to:
- Replace spaces with underscores
- Replace underscores with spaces
- Lowercase
- Uppercase
- Meta Field menu: Add a new meta field to match file output requirements:
- Template Name
- Submitter Name
- Submitter Email
- Created Date
- Updated Date
- Empty
- Default Summary matches the schema in Step 2 Define and Govern schema. If the visible box is unchecked in the schema, it will not be included in the file.
- Click Save to save the template.
Comments
0 comments
Article is closed for comments.