My Purchase Order Keeps Changing when approved through Dymanic email

[KafuiDoviavu]

I have a PR system that sends approval through the Bot automatically for line managers to approve in Gmail. The Auto generated PR ID eg. VGL/PR/2025/2/5 automatically resets to VGL/PR/2025/2/1 when approved from Gmail but does not change when done directly from the Appsheet portal.

Is there something am not doing right?

[WillowMobileSys]

Using the term "resets" implies you have some expression setting this ID automatically.  Is it expected to change over time?

If not, meaning it should be set ONLY when the row is created (as all ID's should), then you should have the Initial Value expression set and make sure the "Reset on edit" property is NOT turned on.

If it does change, then there is likely some condition your are either missing or not using correctly in the expression to prevent resetting in the use case you have described.  It would help if you could show the expression, where it is implemented and how you expect it to change.

I hope this helps!