CORRELATIVE NUMBER

[Mantenimiento_S]

Hi you all!!!

I have a number field, and I want to increase one digit in the next record.

For example: if the last value in this field is 55400, the next was 55401

Thanks in advance for your help.

[WillowMobileSys · Accepted solution]

MAX(Table Name[Boleto]) + 1

In this expression above you need to replace "Table Name" with the actual name of the table that the column [Boleto] belongs to.  I should have explained that in my previous post.

[WillowMobileSys]

Use the MAX() function to get the current maximum value and then add 1 to it.

MAX()

[Mantenimiento_S]

Hi !!!

Thank you for your help. I´m trying the MAX function, but it returns the value 1

MAX(LIST([BOLETO]))+1

BOLETO is the field with the value, and the last is 520000. Should to return 520001

I dont´t know if it´s right.

Thanks again

[WillowMobileSys]

Your expression inside of MAX() needs to return the list of values... so something like:

MAX(Table Name[Boleto]) + 1

[Mantenimiento_S]

That´s OK. If I test the expression, I get the right value, but not in the app (I always get the value 1)

[WillowMobileSys · Accepted solution]

MAX(Table Name[Boleto]) + 1

In this expression above you need to replace "Table Name" with the actual name of the table that the column [Boleto] belongs to.  I should have explained that in my previous post.

[Mantenimiento_S]

Hi Willow!!!!

It works. Thank you very much!!

[Marc_Dillon · Accepted solution]

https://community.appsheet.com/t/serial-numbers-if-you-must/19325