Required Tables
Marketing activity(Campaign)
| Field name |
Required |
Field type |
Description |
| name |
x |
Text field |
Name of the marketing activity |
| type |
|
Option list |
Used to filter out the kind of campaigns to see in Newsletter |
| campaignstatus |
|
Option list |
Used to filter out the status of campaign to see in Newsletter |
| participant |
x |
Relation(1:n campaign-participant) |
The participants that will get the sendout |
Person
| Field name |
Required |
Field type |
Description |
| email |
x |
Link field |
Email to person IMPORTANT |
| participant |
x |
Relation(1:n person-participant) |
Relation to participant, a person can be many participants |
Participant
| Field name |
Required |
Field type |
Description |
| person |
x |
Relation(1:n person-participant) |
Relation to person(Can be changed to something else e.g Company) |
| campaign |
x |
Relation(1:n campaign-participant) |
Relation to campaign |
| participantstatus |
x |
Option list |
Used to set status for the participant. Must contain correct option keys |
| formresponse |
x |
Text field |
Used to display form response data. Can use "misc" field instead. Can be a hidden field as well |
| formresponseid |
x |
Integer field |
Used to identify a formresponse without it being connected to a person. Can be hidden |
Participantstatus
These statuses are used by the integration:
| Key |
| accept |
| decline |
| invitation |
| queue |
| participated |