Solved: Adding new element with unique ID value - Page 2

Arek · 02-02-2022 11:35 PM

Hi,

I'm new to AppSheet and trying to learn as much as possible in short time but found a small problem. I have an app which contains a number of data referred to locations (like typical POIs with name, address, lat/long). I allow adding new locations to the map with few required fields.
Even though my spreadsheet is organised by the ID's whenever new additions are made I'm able to use already existing ID's which then are multiplied in the database. Can you please suggest how to make the ID number predefined based on what's already added in the spreadsheet but incremented by 1?
(e.g. in spreadsheet there are already IDs from 1 to 17, when I add a new location the ID value in form is automatically set to 18).
Many thanks in advance.

Joseph_Seddik

Actually you should try being clearer about your objectives and how to express them to get help; since no one has a cristal ball or telepathy powers to read your mind. You want to sort in a specific order, then you should state it as a requirement.

What is your sorting criteria? Is it just which record was added after which? In this case sorting for example by a Timestamp is a better choice than using sequential numbers.

However, if you still want to use sequential numbers as index, then I encourage you to read this guide:

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Serial-Numbers-If-You-Must/m-p/286300

View solution in original post