I’ve created an test app to learn to use SQL Server before implementing what I’ve learned to an app that’s currently being used on the field.
I’ve read the support page “Using Data from SQL Server” and (unless I’m not understanding it) it says it is best to set the Key Column to nvarchar(8).
I have a Delivery_ID column set to nvarchar(8) which is the key column on SQL Server and also made this the Key with AppSheet. I’ve added UNIQUEID() in the InitialValue, but it will not sync.
I’ve been able to successfully use RANDBETWEEN(10000, 99999).
the support page reads: “There are restrictions on how many of these operations can occur concurrently, so if this is a high-traffic app, errors could occur. In these situations, we again advise that an nvarchar(8) column should be used as the key instead.”
I will be using this on a high volume app (10 drivers capturing between up to 800 rows a day) so I want to make sure I’m setting it up correctly.
Is it safe using RANDBETWEEN? Or is there something I need to look at to get nvarchar(8) to work?