Can I automatically fill a field in a new record with the next available number in a series?

[dilon_perera]

Oh then I think you need to use the Record ID.

Make unique record IDs publicly available | Feature Requests | Adalo

Still not available but Pragmaflow created a component.

A Button that gives the Record Id

My team was making SMS verification and was complaining about needing to filter the entire collection table to find the record to update. Also, a sports enthusiast posted the same thing on the forum today. So, I whipped up a quick component that will let you get the record id of an item when the button is clicked on. Installed it from adalo.pragmaflowservers.com/install-component and use it for your custom actions today and save a whole bunch of work. https://youtu.be/OuyZX15aPXg