[Showcase] Concurrent Auto Row Number preserving increment even with deletion of past rows. GS Apps Script + RowID

Hi guys, for my needs I’ve developed assigning of Row Number based on Row ID.

GS Apps Script onChange trigger that reacts to new rows without Row Number and assigns auto-incremented numbers in a locked environment(concurrent creation at the same time solved).

:lock:Row ID is optionally used as the key for assigned Row Numbers. Therefore, if row is restored - the previously assigned Row Number will be used again.

As with any GS modification - it takes time to be synced by Glide. I use update action to sync it faster(but anyway number syncs from immediately to 10-20 seconds)

If it’s interesting to the community - I’ll prepare reusable example and instructions.

Yes, interesting. Please post example. Thank you