What are Media Fields?

Media Fields are headers of the columns in the Sheet view. On the screenshot Market, Country, Media Vehicle, Start and End Date, etc. - are all media fields.

Prefer a quick walkthrough?

Watch our short Academy video on media field customization.

Watch now

To see the list of all existing Media Fields within an organization, follow these steps:

Navigate to Media Types & Fields: Enter Settings in the left-hand menu of your parent account and then select Media Types & Fields.
Select Any Media Type: Click on the drop-down list and select any media type.
Access Library of Fields: On the right you'll find a Library of fields - all the fields that exist on your accounts.

💡 You can filter the available options by typing the name of the field in the upper right-hand corner or scrolling through the list.

Types of Media Fields

All fields are labeled with an icon representing the field type:

Text – Free text field. You also have the option to configure a text field as a template field. Read more about this option in our article on template fields.
Date – Date field - note that the date format (MM/DD/YYYY) will be set in your personal settings
Number – General number or percentage. Choose whether to have the field summarize itself in columns and reports as a sum total or none. Choose the number of decimal places.
Calculation – An auto-populated field based on the formula added in the settings.
- A Calculation field can only be based on number fields.
- You cannot manually enter data in this field within the sheet view, as it is locked. However, you can enable 'Calculate on Condition', allowing it to calculate in some situations but not in others.
- All of the component fields required for the calculation must be present in the same media type for the calculation to function.
- Enter the calculation formula by tagging the @name of each field and using general calculation signs (/,-,+,*) and brackets.
- Choose the number of decimal places.
- You can also configure a conditional calculation.
Tags - Tags are media fields whose inputs are limited to a restricted list. Read more about tags here.
Generated Field – Automatically creates unique codes with a specific set of digits, making it easier to, for example, match results to planned entries.
File Fields – A file field lets planners upload new files or select from a predefined list directly within each row of the planning sheet view. You can customize each field to control which types of files are allowed, ensuring that uploads stay relevant and organized.

Create a new Media Field (column)

Camphouse has some default fields, but if none of these match your needs, you can create a new field. Follow these steps to create a new field:

Access Settings: Enter Settings in the left-hand menu of your parent account and then select Media Types & Fields.
Select a Media type: Click on the drop-down menu and select the media type to which you want to add the field.
Add a New Media Field: Click on '+Add field' blue text located above the library of fields on the right side of your screen.
Fill In Field Settings: Add the name and type of the future field and other settings available depending on a field type.
Save the Field: In the left corner you'll find a 'Create field button'. Once the field is created, it'll be automatically added to the current media type.

⚠️ It is not possible to have two fields with the same exact title.

Edit a Media Field

To edit an existing field:

Select the Field: Click on the field from the library of fields on the right-hand sidebar. A preview of the field and its settings will appear below.
Edit the Field: Click the edit field to open up the field settings in more detail. Adjust your desired setting and then click the green button titled update field.

Delete a Media Field

To delete the field:

Select the Field: Click on the field from the library of fields on the right-hand sidebar. A preview of the field and its settings will appear below.
Edit the Field: Click the edit field to open up the field settings in more detail.
Delete the Field: Click on the red button towards the bottom left titled delete field.

⚠️The type of the field cannot be changed after the field creation.

Additional Field Settings

Total is - decide how to summarize your values. It'll be displayed at the very top of the sheet view and will be considered in reports.

Required: the user will not be able to save their changes in the Sheet view until a value is input.
Does not affect plan status: if the user is trying to make changes to this field in the approved plan, it won't send the plan back to "working" status.
Disabled by condition: if checked, the field will be disabled (locked) according to a condition(s).
Delivery Plan: checking the 'Appears in Delivery plan' box will have this field/ column appear in the delivery plan section of your Media Overview.
Default hidden: the field will be hidden from the sheet view by default. The field can be unhidden manually.
Custom field color: Choose the color in which the column header should be displayed in the Sheet view. You can group fields by assigning them a specific color to make navigation easier for planners.