Is it possible to allow my database to handle the auto-increment on a number key? I know that I can’t have appsheet handle the auto increment if I can have more than 1 user adding at a time. I know that I can use a string for my key but using auto-int makes it much easier to take a glance at my tables and see everything while I’m testing and all my values are low. It’s alot easier to remember to look for employee ID 145 than s8vk2qy3p.
You don’t have to make the employee ID and the row key the same column. Assuming they’re different, to ensure a unique employee ID, use a workflow to set the employee ID if the column is blank. To my knowledge, there’s no risk of collision if the (server-side) workflow generates a unique value.