anybody know how to get formula MAX? I want t...

(Aleksander Rogowski) #1

anybody know how to get formula MAX? I want to search maximum number in column “ID” and add 1 value.

In google spreadsheet my formula working but in AppSheet not

Thanks for help !

(Aleksi Alkio) #2

Try MAX(TableName[ID])+1

(Gil Littman [AppSheet]) #3

@Aleksander_Rogowski Keep in mind that if 2 users are doing it in the same time (or if one of them is offline), you’ll end up with 2 rows with the same ID, since the ID+1 value will be written only on sync. You can workaround this by keeping your formula in the spreadsheet and using a spreadsheet formula:

help.appsheet.com - Spreadsheet Formulas Spreadsheet Formulas help.appsheet.com