Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Mobility tracking of field data

(0) ShareShare
ReportReport
Posted on by 288

Hi Guys,

Wondering if this is possible.

I currently have a RAG status field within my account form which tells us if our clients are happy, sad etc. What I want to be able to do is if the field content changes from Green to Red I want to be able to report that it changed from Green to Red.

I know i can look at the audit trail to see the change, however, im looking for another way to get this done as I know audit trails cant be recorded or reports etc in the system.

Has something like this been built out before.

  • Jason Fleming Profile Picture
    288 on at
    RE: Mobility tracking of field data

    Thanks for the detail response. Sorry for not being up to speed with this and for not fully understanding this.

    I have followed the steps outlined above, but I still cant get this to work. My difficulty is if the Rag status is set to red, and then moved to green, the old rag status field should show as red. If then the this field changes from green to gold then the old status field should show as green.

    I havent been able to get this working as yet, if you have additional help on this Id love to hear it.

    Thanks again for your help.

  • Verified answer
    Kipetcoff Profile Picture
    1,037 on at
    RE: Mobility tracking of field data

    Hi,

    You need to create the field "Old RAG status" with the same type and options(Red, Amber, Green, Gold etc.).

    Create solution option set

    2019_2D00_10_2D00_23_5F00_15_2D00_08_2D00_41.png

    And then use it to create you field in entity Olb and Current

    2019_2D00_10_2D00_23_5F00_15_2D00_11_2D00_29.png

    2019_2D00_10_2D00_23_5F00_15_2D00_12_2D00_28.png

    Then compare them in WorkFlow

    2019_2D00_10_2D00_23_5F00_15_2D00_16_2D00_33.png

    2019_2D00_10_2D00_23_5F00_15_2D00_20_2D00_40.png

    2019_2D00_10_2D00_23_5F00_15_2D00_21_2D00_58.png

    2019_2D00_10_2D00_23_5F00_15_2D00_24_2D00_02.png

    That's all

  • Jason Fleming Profile Picture
    288 on at
    RE: Mobility tracking of field data

    Hi Andrey,

    Thanks for your response. So its just a workflow that I need to build out? Will I have to add in all the various options that my users can pick though to complete this workflow?

    So the RAG status has 4 options, Red, Amber, Green, Gold etc.... or am i thinking about this incorrectly?

  • Suggested answer
    Kipetcoff Profile Picture
    1,037 on at
    RE: Mobility tracking of field data

    Hi,

    You don't need to store all history, you just need to store previous value (Old RAG status) and compare new with previous in workflow.

    If Old was Green and new is Red then alarm. And don't forget to update Old with new at the end.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Daivat Vartak (v-9davar) Profile Picture

Daivat Vartak (v-9d... 225 Super User 2025 Season 1

#2
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 106

#3
Vahid Ghafarpour Profile Picture

Vahid Ghafarpour 82 Super User 2025 Season 1

Overall leaderboard

Product updates

Dynamics 365 release plans