> For the complete documentation index, see [llms.txt](https://docs.agilecase.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.agilecase.com/administrator-documentation/reports/creating-reports/creating-a-report-using-custom-fields.md).

# Creating a Report Using Custom Fields

This lesson will show you how to create a report that uses custom fields. Before you do this, you should know how to create a basic report, which you can see [here](/administrator-documentation/reports/creating-reports/creating-a-basic-report.md). You will also need to know how to add conditions, which you can find [here](/administrator-documentation/reports/creating-reports/creating-a-report-with-conditions.md).

### Access case custom fields

<figure><img src="/files/fWTHH4tKHa2vvzcCImBW" alt="" width="166"><figcaption></figcaption></figure>

In order to create a report that uses custom fields you have added to the system, the process is a little more complicated.

This example will show you how to generate a basic report using case custom fields. First, look up custom fields under the case heading.

### Add Custom field entites

<figure><img src="/files/Y4aT6D3eYHokeRWPg7eO" alt="" width="159"><figcaption></figcaption></figure>

There are two entities you must add for each custom field you want to use:

{% stepper %}
{% step %}

### Add the value

Enter this as a column.
{% endstep %}

{% step %}

### Add the Custom field ID

Enter this as a condition.

You will notice that each custom field option is numbered. It does not matter what numbers you choose to add, as long as the value and custom field IDs are for the same numbers, as these will be used to define the specific custom fields each number refers to.
{% endstep %}
{% endstepper %}

### Look up custom field IDs

<figure><img src="/files/qEsK5bWaCB9gOSxqaFiR" alt=""><figcaption></figcaption></figure>

To specify your custom field IDs, you can use the Merge Field helper tool within a case. The custom field ID will be displayed beside each custom field in the case.

Using the merge field helper, pick out the IDs of the fields that you wish to use in your report. You should manually copy and paste the custom field ID, as the "copy" option in the far column copies the merge field for use in templates, rather than the ID which is used in reports.

In this example, we have circled the custom fields we will be using:

1. Project Title
2. Project Lead
3. Credit Check

### Specify your custom fields

<figure><img src="/files/t9V78yroq9x9rGrKVngG" alt=""><figcaption></figcaption></figure>

To specify your custom fields, you must set each value condition to the ID of the custom field you wish to use.

The numbered examples from the custom field reports are shown here being used as conditions.

The column titles should also be changed to reflect the custom fields that will inhabit them. For example, the first custom field is "Project Title", so the field ID condition for Custom Field 1 will be set to the ID of the Project Title field, in this case "3222".

You can do this for up to 15 custom fields in each report that you create.

### Results

<figure><img src="/files/dcXIFL8MXqTzKvXFAeMb" alt=""><figcaption></figcaption></figure>

When the report is generated, the system will cross reference the Field IDs with the custom field numbers to generate the right custom fields in the right places.

### Adding client custom fields

<figure><img src="/files/OmCpN3AN9M1Ex6qZm7Wd" alt=""><figcaption></figcaption></figure>

Client custom fields can be added in the same manner as case custom fields. However, the relevant entities and IDs are located in different places.

<figure><img src="/files/lKh8vjiOTa6278joCMxQ" alt="" width="250"><figcaption></figcaption></figure>

Client custom field column entities can be found under "Client Fields", itself under the "Client" option on the entities list.

Client custom fields can be viewed in the merge field helper on any case. Simply scroll past the case data to view your client fields and locate the IDs of any custom fields you need for your report.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.agilecase.com/administrator-documentation/reports/creating-reports/creating-a-report-using-custom-fields.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
