Is there a way to force sync before adding data to a table by clicking :“save” on a form? My app uses the initial value function of the “Name” column to assign a name to the new record, and it assigns a name that is not yet used. If it does not sync before adding the name, then it can add a name that already exists. (Note:I don’t use UNIQUEID() for that field because I need a name that has a significance. Example, the name is “CUSTOMER” & a number, and I make sure the number was not used before).
There’s no way to provide that unfortunately and using sequential keys is not a good practice because 2 users creating a record at the same time can have the same key value. Therefore it’s highly advised to use UNIQUEID() with the key.