Do a search for ur number and put a sort descending as yes. Instead of using count or max - use last item. It will search for the last item in that sort number in this case the newest number. Let me know of this work
Aaaaaaaaaahhhhh, sorry, I couldn’t help myself! Too many hours in front of the computer does this to you. God, I even created the Brain data type and IQ field in my client’s app. Shoot me. Put me out of my misery, It’s better for everyone.
Count works too in these scenario but be careful when in future u need to delete an entry. A count of 4 with 1 deleted will be 4. But last item(first item depending on your sorting criteria) will be 5 because it will add up the current number. Depends on your usage. Cheers