Incrementing Numbers Automatically

[Garak0410]

With the help and encouragement of the awesome user base on here, I created a simple app to track revisions to orders...

This is the entry screen:

I am looking for a way to code this in such a way that the revision number is automatic and increments when needed. What I would love for it to do is automatically increment the revision number by 1 if one already exists for the JOB # and if it is the first revision to default to 1. 

Any suggestions? 

[KrishnaV · Accepted solution]

Hi @Garak0410 ,

You can do as below:

Default property of the text box of screening:
Default : Text(if(Max(SPListName,'revision')=0,1,Max(SPListName,'revision')+1))

That will show 0 for the first review and it adds one for all the next revisions.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

[KrishnaV]

Hi @Garak0410,

I just want to follow up with you on this issue to see is it resolved or still you see any challenges.

If you see any challenge/need further help let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more