Increment values in a column of data by 1

[KenT]

I have simple tables of data to work with in an App, as a non-coder! The first column (1) is a GUID generated by the app, thats only used very occasionally. Second column (2) is a visible identifier seen by users and is context specific.

For a controls data table example: Column 2 (named Control ID) , Row 1 = ‘Con 01’
Column 2 (named Control ID) , Row 2 = ‘Con 02’
Column 2 (named Control ID) , Row 3 = ‘Con 03’

For a risks data table example: Column 2 (named Risk ID) , Row 1 = 'Ris01
Column 2 (named Risk ID) , Row 2 = 'Ris 03
Column 2 (named Risk ID) , Row 3 = 'Ris 03

These visible IDs should generate as the data tables are opened for new entries to be added to the table.

Any suggestions for how to do this?

thanks

[Darren_Murphy]

The below might help:

How do I create an auto-incrementing row number with Glide Tables?

This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…

[KenT]

Most useful, thank you. Realise now the limitations I have in the App platform to add relationships and such. I’m on a long learning curve!