Claravine can automatically generate a Google Cloud Storage file with the data from every submission. Administrators can design the file, what data to include in the file, and where to send it per template.
To add Google Cloud Storage Outbound to a template:
- Open the correct Template in the Templates Sub-Navigation menu.
- Click Step 3 - Connect.
- Click to add a new Outbound integration.
- Click Google Cloud.
The Google Cloud Outbound configuration section displays. - Enter the Integration Name. If no value is entered, Claravine will default the Integration Name to the Template name.
- Select the connected Google Account.
An Administrator must first connect the Google Account in the Accounts Sub-Navigation menu of Integrations. - Select the Destination Bucket.
- Define the Filename. It will default to {{template_name}}{{submitted_at). You can add text, remove text or click +Insert on the right to add additional dynamic values Submitted By and Submission Name, 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.
- 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 being 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.
- Click Save to save the template.
Comments
0 comments
Article is closed for comments.