2-Way sync between sheets without a unique ID

How to setup 2-way sync within the same workbook without any unique ID.

I’m in the habit of adding IDs to sheets where I need to do lookups, but sometimes, I inherit a sheet without IDs in place (or I can’t edit the sheet structure). Spencer outlines a clever way to handle syncing between two sheets without using IDs in this video.

Source: 2-Way Sync: No Unique ID

Google App Script Properties and Cache Services

Properties and Cache

Video showing the Properties and Cache Services available for Google Apps Script

  • The Properties and Cache Services are designed to hold data for use beyond a single run of a script.
  • The Legacy IDE had an option to see view and directly interact with the Script Properties. This is not available in the new IDE but the service still exists and can be interacted with via code.
  • The primary difference between the PropertiesService and CacheService is that key-value pairs in the Cache are automatically deleted after 25 minutes, while data in the PropertiesService persist until deleted via code (or manually from the Legacy IDE)

Interesting to see a growing number of video tutorials being produced by the App Script community. The latest we’ve come across comes fromĀ  Spencer Farris who in this post provides an overview of the Properties and Cache service. Click through to the source post to watch the video and access additional resources.

Source: Google App Script Properties and Cache Services