Data refresh - Subscribe to updates or pull from URL?

[jeffminder]

Are there any sample apps which employ methods to update data tables from a central shared source, pre-configured URL,  or user entered arbitrary URL?   Have seen mentions about how it could be done, but want to examine one to see specifically how it was done.

Thought about doing this from the google sheet side, as that feels like it would be easier... maybe.   The purpose I'm working on is a calendar of nationwide events, where users typically interested in things within a small radius.   Already have a state by state filter mechanism, but no way to update their data other than manual once app is created. 

[WillowMobileSys]

I'm not aware of any sample apps that do this.  All AppSheet provided sample apps or very simplistic and do not go outside of the AppSheet platform.

You have a single source to retrieve your event details from, that's good.  Have you investigated if they provide a mechanism that allows you to download the details? 

How they provide the details will dictate what process you need.  Some may provide an API where you can retrieve the details.  Others may provide a CSV file down that can be imported.  Other don't provide anything leaving you to perform tedious "data scraping" tactics to get the details.  AppSheet does provide several EXTRACT...() functions to help with this.

I hope this helps!

[jeffminder]

In this case I have to do all the parsing of events manually and am the creator of the aggregate of all the combine sources of event data.  Currently those are in google sheets and that is the datasource for appsheet to build a calendar view.  

The problem is that is a one-time event at the time the app is handed over (as a copy).  I'd like to add a mechanism to allow the handed over app to be able to sync with a master list as event are added later.   It seems copying creates a snapshot in time and breaks the connection to the original source. 

To make a long story short, can put the data in whatever form is most efficient to perform delta syncs, etc....