Problem of sync with multiple devices

AppSheet AppSheet Q&A
1

Hello,
I created an app in which I use for some columns the expression: <LOOKUP([_THISROW].[_RowNumber]-1, “CASH”, “_RowNumber”, “XYZ”)>.

On 1 device, everything works properly.
But when I start using multiple devices, it creates inconsistency data.

Exemple:
I make change on device 1 (open a form, edit and save), the result expected is all correct.
I go now on device 2, and make a change (open a form, edit and save), the result is wrong, because the change of device 1 was not sync beforehand on device 2 ([_RowNumber]-1 returns the wrong value).

In the Offline/Sync option, I set:

  • Sync on start = 1
  • Delayed sync = 0
  • Automatic updates = 1
    Therefore, I expect that device 2 will auto-sync each 30min. But it looks that it is not the case.

My question:
How to ensure that all my devices have been sync before I can make a new data entry?
→ Is there any way to force a sync base on time (ex: every 15min)?
→ Creating a workflow that force to sync before opening a new Form?
→ other?

Thanks in advance for your help.

1 Like
2

I managed to save my issue using an action:

  • Do this: ‘Go to another view within this app’
  • Target: LINKTOVIEW(“XYZ”) & “&at=” & (NOW() + 1)

I guess it’s rather a good solution but if any of you think about some other way, feel free to share.

3

thibaulthess:

How to ensure that all my devices have been sync before I can make a new data entry?

Not possible.

thibaulthess:

Is there any way to force a sync base on time (ex: every 15min)?

Nope.

thibaulthess:

Creating a workflow that force to sync before opening a new Form?

Nope.

1 Like