Hi guys, for my needs I’ve developed assigning of Row Number based on Row ID.
Approach
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).
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.
Caveat
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.