got a simple database set up to track box contents and locations in an upcoming move of our house.
I've got a paid PRO level account, my wife will soon do the same.
The database is shared between our accounts via the Memento Cloud, although we've also got the data synced to my google sheets account.
here's my question: I've got the database set up to auto-increment a "box id #" field, so that the first box is #1, the second is #2, etc. You create a new record, it auto-generates the number.
But, with two people working on local copies on their phones as they pack, this creates a race condition. It's trivial, in testing, to create two boxes with identical numbers.
So, how can I make a script that forces a sync to the Memento Cloud before a new record is created?