Auto-Increment in Database and Adds

Austin
Participant V

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.

0 1 3,219
1 REPLY 1

Steve
Participant V

Nope.

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.

Top Labels in this Space