This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Force an app to sync after DB changes from another app

Posted on 08-17-2024 06:50 PM
JBenjamin
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

I have two separate AppSheet apps that reference the same Google Sheet. When App A makes changes to the shared sheet, those changes don't get reflected in App B until App B does some other operation on that sheet (at which point Quick sync seems to pick them up), or App B does an explicit sync, or the usual 30 minutes or so have passed.

I'd like those changes to be reflected in App B sooner, regardless of usage of App B. Is there any way to force App B to recognize there are changes in the Google Sheet and either Quick sync or full sync?

I did find this thread, which implies you can create a bot that uses a web hook and API call to from App A to App B and cause App B to realize there are changes and sync, if I'm understanding it correctly, but it's not clear to me how to actually implement it. I tried creating a bot in App A, triggered on Data Change, and sent the request to App B, but I don't know if that's what I'm supposed to do, or if so what to put in the request body (I don't actually want to change a row, or even know which row just got added). Am I on the right track, if it's possible at all? Thanks.

appbot.jpg

(BTW, I only have AppSheet Core. Webhooks work with Core, right? It's only external access via the API that you need Enterprise for?)

Solved Solved
0 2 436
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
JBenjamin
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Bad form to reply so much to my own topic maybe, but I found the answer: A search finally turned up this thread where the problem was a bad time zone... that was my problem as well (there is no "Mountain Standard Time", only "US Mountain Standard Time" and "Mountain Standard Time (Mexico)")... sigh, I had issues already with ambiguity from AppSheet inventing their own time zone specifications, but I digress...).

Once I fixed the time zone in the JSON properties, the changes took effect in the other app.

Then I realized that I could just use the automation webhook to edit everything I needed in the row, rather than how I was doing it with an action that fired after the form was saved. By making the edit via the webhook in App A, App B realized the data had been updated and did a Quick sync all on its own. Problem solved!

View solution in original post

Jump to Solution
2 REPLIES 2
Top Labels in this Space