web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Reporting on Custom Fields

(0) ShareShare
ReportReport
Posted on by 40

I am new to Dynamics for Sales. I am trying to create a view and report on a custom activity field that our admin added under "Appointment" activity. This new field is called "Appointment Status" which identifies if the appointment is a first appointment set or a follow-up appointment. When trying to create a new view I do not see the custom field, "Appointment Status" as an option to add as a new column. Any suggestions on how I can create a view and report on this custom field will be appreciated. Thank you in advance.

I have the same question (0)
  • LuHao Profile Picture
    40,892 on at

    Hi jbroyhill,

    When we want to add a field to the view, first check if there is this column in the view.

    If this field has been added to the view as a column, then you cannot see it in the field list of "Add Columns".

    pastedimage1590733687904v2.png

  • jbroyhill Profile Picture
    40 on at

    The field is not currently showing as a column in the view. When I go to the "Add Column" you have highlighted I do not see the custom field as an option under "Activity".

    pastedimage1590757785483v1.png

    "Appointment Status" does not appear as column I can add and view.

    pastedimage1590757937268v2.png

  • LuHao Profile Picture
    40,892 on at

    Hi jbroyhill,

    Since the "Appointment Status" field appears in the Appointment form, then it belongs to the Appointment entity, not the Activity entity.

    So, in your second screenshot, "Record Type" should be Appointment instead of Activity.

    pastedimage1590978899470v1.png

    BTW, Activity entity is not allowed to create custom fields.

  • jbroyhill Profile Picture
    40 on at

    Thank you Hao. Unfortunately, "Appointment" does not show up in my drop-down list of options to add as a column. Does my System Administrator need to do something to make this entity available to report on?

    pastedimage1591016819840v1.png

  • Suggested answer
    LuHao Profile Picture
    40,892 on at

    Hi jbroyhill,

    It seems that you edited the view of the Activity entity, not the Appointment entity, so you can only see the Activity fields.

    In the customizations, go to Appointment > Views, edit the Appointment view.

    pastedimage1591064946890v1.png

    Then click Add Columns.

    pastedimage1591064976426v2.png

    You will select Appointment fields.

    pastedimage1591065006745v3.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Nagaraju_Matta Profile Picture

Nagaraju_Matta 121

#2
ManoVerse Profile Picture

ManoVerse 67 Super User 2026 Season 1

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 66 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans