Skip to main content

Notifications

Customer Service forum
Unanswered

Previous Record Value

Posted on by 50
Please help with fetching previous record values on new_amount field
This is what I have
  • Entity name is  :   new_Country
  • Field Name that needs to be fetched to next record :   new_amount
Note that I am using Celedon Autonumber plugin

_________________________________________________________________________________________________________________________

Example of the entire thing. Red is where I need your help. I was able to generate sequence number with Celedon Autonumber Plugin
So single Entity has multiple Countries; Each Country starts with it's auto-number sequencing.  So previous record new_amount needs to be of same country.
All country records are visible on View; Starts with it's own sequencing auto-numbers
 
new_Country     Sequencing auto number   new_amount
Argentina                     101                                 2                ( this is initial value 2 on one record)
Argentina                     102                                 2                ( 2 is auto populated and if i change it to 4, next value should be 4)               this value 2 should be auto populated ( this is where I need help)
Argentina                     103                                 4                this value  4 should be auto populated ( this is where I need help)
new_Country     Sequencing auto number   new_amount
Brazil                              101                                 4                ( this is initial value 4 on one record)
Brazil                              102                                 4                ( 4 is auto-populated, and  if i change it to 6, next value should be 6)           ( this is where I need help)
Brazil                              103                                 6                this value 6 should be auto populated ( this is where I need help)
  • Manny Floyd Profile Picture
    Manny Floyd 50 on at
    RE: Previous Record Value

    Hi Leo,

    new amount could be any integer value, I just want to copy that value to next record. Condition is country, so the the sequencing in view is consistent.

  • LeoAlt Profile Picture
    LeoAlt 16,329 on at
    RE: Previous Record Value

    Hi Partner,

    Thanks for your details, may I know that what dose the "new_amount" mean? To store the amount of the country or something else?

    If you want to populate the value based on other conditions, you could use FLOW to do this.

    If you want to roll up the amount for the same country, you could use roll up field.

    Please share more information about your requirement so that we could provide some samples to you.

    Regards,

    Leo

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,867 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,173 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans