Delayed Sync : Force App Sync with grouped action not working as intended

I have a grouped execution of actions on a table for when a user submits a form. I would like to get an action that forces a sync because I have delayed sync enabled and realized that we are having some data loss from people closing their apps before the form was fully submitted.

I have tried using the LINKTOROW()&"&at="&(NOW()+1) as seen on other posts but it does not work when it is part of a grouped sequence of actions. It will not force the app to update/sync and just continue on with the delayed sync.

Hereโ€™s a breakdown of the grouped actions when Form Submitted triggers it (via form saved behavior)

  1. App: Go to another view within this app
    LINKTOROW([ID], "Jobs-Assigned_Detail")&"&at="&(NOW()+1)
  2. Data: Set the value of some columns : Job status change
  3. Data: Set the value of some columns : DateTime capture
  4. Data: Set the value of some columns : UserEmail capture

Any ideas on what I could do to mitigate this?

Solved Solved
1 7 1,469
1 ACCEPTED SOLUTION

Huh, that seems to have worked. Odd because I remember doing that earlier last week and it didnโ€™t work. Fabian with the magic touch, Thank you!

Answer:
If you are making use of Delayed Sync and would like to force a sync using LINKTOROW()&"&at="&(NOW()+1) on a grouped sequence of actions, ensure the sync is at the END of the stack.

In my case:
On Form Saved (On Reports Table)

  1. Data: Execute an action on a set of rows (Target table Jobs) : Report Submitted Action

Report Submitted Action (Grouped Execution)

  1. Data: Set the value of some columns : Job status change
  2. Data: Set the value of some columns : DateTime capture
  3. Data: Set the value of some columns : UserEmail capture
  4. App: Go to another view within this app
    LINKTOROW([ID], "Jobs-Assigned_Detail")&"&at="&(NOW()+1)

View solution in original post

7 REPLIES 7

@praveen I tested this and Iโ€™m seeing this as well.
https://cl.ly/2653b5

In my case it is working.
I have Grouped Actions:

  1. Set the value of a column
  2. Force a Sync

I put this grouped Action to the โ€œForm Savedโ€ Event. After saving the form, both actions are executed.

Nice! So it works when in a group thatโ€™s on the form save event, but not when initiated by an action press.

@Fabian
I have a similar set up for another action but it is not working.

On Form Saved (On Reports Table)

  1. Data: Execute an action on a set of rows (Target table Jobs) : Report Submitted Action

Report Submitted Action (Grouped Execution)

  1. App: Go to another view within this app
    LINKTOROW([ID], "Jobs-Assigned_Detail")&"&at="&(NOW()+1)
  2. Data: Set the value of some columns : Job status change
  3. Data: Set the value of some columns : DateTime capture
  4. Data: Set the value of some columns : UserEmail capture

Could you try to put the second step at the end?

Huh, that seems to have worked. Odd because I remember doing that earlier last week and it didnโ€™t work. Fabian with the magic touch, Thank you!

Answer:
If you are making use of Delayed Sync and would like to force a sync using LINKTOROW()&"&at="&(NOW()+1) on a grouped sequence of actions, ensure the sync is at the END of the stack.

In my case:
On Form Saved (On Reports Table)

  1. Data: Execute an action on a set of rows (Target table Jobs) : Report Submitted Action

Report Submitted Action (Grouped Execution)

  1. Data: Set the value of some columns : Job status change
  2. Data: Set the value of some columns : DateTime capture
  3. Data: Set the value of some columns : UserEmail capture
  4. App: Go to another view within this app
    LINKTOROW([ID], "Jobs-Assigned_Detail")&"&at="&(NOW()+1)

So it seems you can sync on a manual action press, sync when part of a sequence of actions on a form save, but not on a manual press of that group action.

Top Labels in this Space