Editing database fields

Edit the field to set the default field values or drop-down selections.

About this task

Deleting a value from a Selection field in an Acoustic Campaign database does not also delete that value from contacts' records. After deleting a selection field value, you can go to the search tab of the database. There, you will see that all of the contacts with that value will continue to show that value. However, if you click into the contact, you will not see the value in that field. This is because the value is not available for selection anymore.

You can run Queries on this field value to see that it is still there for those contacts. Also, you can export the database and the export will show that the value still exists for those contacts.

Procedure

  1. In the Database Fields tab within Database Summary.
  2. Click Edit next to the field name.
  3. Enter a new default value, if needed, and click Save. All fields in this column will now have the default value.
    • You can change 'Required', unless it is a Yes/No selection. You can set the default value of a Yes/No field to 'Yes' or 'No'.
    • Fields with selections can have selections added and their order rearranged (except Country).
    • Time, date, and numeric values must be in valid formats.
      • Time: 1:00. Do not use AM or PM, use 24 hour time.
      • Date: mm/dd/year. February 12, 2015 must be entered as 02/12/2015. Do not use European notation. You may use the date formatting option upon import/export of your database to work with your files in your preferred date format outside of the UI and then have Acoustic Campaign convert them for you.
      • Numerical: No letters or spaces. A single decimal can be used, but not two decimals. Long numbers can also be used.
      • Text: Text entries can include any alpha-numeric character, including numbers.