How do I set a default value for a field in my custom table?

How do I set a default value for a field in my custom table?

When using merge tags in campaigns, it is important to consider the possibility that not all recipients may have a value stored in the field being merged. You can set default values for fields to account for the lack of data.  Follow the steps below to save a default value to a field in a custom table.

How-To

  1. Navigate to Contacts > Configuration > Custom Tables.
    1.png

  2. Hover over listed custom table name in the library and click the "Edit" button that appears to the right.
    2.png

  3. Hover over the listed field name in the listing of fields and click the "Edit" button that appears to the right.
    3.png


  4. In Merge Options box, enter the value. Remember, this should be a generic data value that would be applicable to anyone who does not have a value stored in the field. It will be seen if this field is merged into a campaign.
    merge1.png
  5. Click "Save".

 

    • Related Articles

    • Can a field name in a custom table be deleted?

      We would not recommend deleting fields from your custom table(s) but instead would recommend that the field is edited to be hidden. To do this, follow the steps below: How-To 1. Navigate to the Contacts dashboard. 2. Select "Configuration" from the ...
    • Set up a triggered campaign | Delivra Air

      This how-to article outlines the process of creating a triggered campaign in the Delivra Air system. If you are not a Delivra Air user, please see this article for this process in the legacy system. Tip: Open the images included in this article in a ...
    • How do I setup a picklist for a custom table field?

      A picklist is a list of data values saved to a demographic field. Creating a picklist for demographic fields allows you to ensure data integrity. If ever an import is made with non-matching values, you will be notified to correct the data. Follow the ...
    • How do I rename fields in my custom table?

      Easily access the fields in your custom table for updates. Follow the steps in this article to rename a field in a custom table in your account. How-To Navigate to Contacts > Configuration > Custom Tables. Hover over listed custom table name in the ...
    • Create a segment | Delivra Air

      This how-to article outlines the process of creating a segment in the Delivra Air system. If you are not a Delivra Air user, please see this article for creating a segment in the legacy system. Tip: Open the images included in this article in a new ...