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)
