Hi all - still very new to AppSheet. I am creating an app to let users enter an Invoice. Each invoice has an invoice number, and the beginning of that number indicates what sales channel the invoice is for. For instance, a sale in a shop starts with an 8 (80001), while a sale online starts with a 2 (i.e. 20001), etc.
I would like to automatically generate the next invoice number based on the Sales Channel that the user selects.
So for example, User selects Online as the sales channel in a drop-down, so the Invoice Number automatically populates with a new Invoice Number, which is the next number sequentially that starts with “2.” So if the last Online invoice was 20001, the system would assign 20002 to this new Invoice.
I’ve no idea how to get this done, so am looking for some tips. Another issue is that the Invoice Number is the Key, so I think I am limited on the expressions I can build here.
Any advice is appreciated!