Perform an action after the sync is completed in Delayed Sync.

[Vaibhav_Traders]

Hello there!
I am having trouble in performing an action. The action is, "External: Go to a website".

I want this action to be performed as soon as the user saves the form.
The problem is, since the form has some columns that have spreadsheet formula, those values can be calculated only after the sync is completed.

Since my action needs to take values from those columns, it takes blank ('Sync to Compute') as a value, because the sync is delayed, and the action is triggered before the sync is completed.

What I want is, my action must wait for the sync to complete, and then it should be performed. 

Can you all please help in this?
Thanks in anticipation!

[WillowMobileSys]

What are the computations?  Can they be performed in AppSheet?

If so, then you can create an action (or set of actions) that is attached to the Form Save behavior.  The idea is that once the Form is saved the set of actions is executed and then at the end of that set is your final action to navigate to the website.  Using this method, all calculations are performed on the device and are immediately available on that device - no Sync required.  The updates to the server to be disseminated out to other users is secondary.

Does this sound like something that would work for you?

[Vaibhav_Traders]

Computations are simple spreadsheet formula (mathematical formula: SUMPRODUCT(array1, array 2....)). I don't think they can be performed on AppSheet, as the number of columns are quite large (say 200), and there are multiple conditions in the formula. (If there is any way to give row's values from a list of columns (like D2:D60) to formulas of AppSheet, please let me know! This will help me a lot.)

[dbaum]

Consider creating a "Product" column that multiplies the relevant values within a row (e.g., [Quantity] * [Price]), and then creating a SUM expression to total that column (e.g., SUM([Product]) wherever you need that information.

[MultiTech]

Just throwing this out there..... 🙄

---

@Vaibhav_Traders wrote:

I don't think they {some calculations} can be performed in AppSheet

---

• Yet to really find that wall....
  • If it's not natively supported by AppSheet already, there's usually a way to "make" the results you need; and even if it's not possible directly inside AppSheet, you can usually call a script or something to get it done externally

----------------------------------------------------------------------------------------------------------------

A common thing I hear from my clients is, "You know... you never say no to us.  No matter what we want to do, you can do it."

• (^_^) Yup 😂🤣

[WillowMobileSys]

Absolutely!!