Google Sheets: 2-Way Sync Tutorial
How to setup 2-way data sync for formulas like FILTER(), QUERY(), and IMPORTRANGE() on Google Sheets.
Important notes:
Create a unique key for each row so the script can find the right row on the database
This simple script assumes identical headers in the database and sub sheets
Sheet to copy:
https://docs.google.com/spreadsheets/...
Script:
function onEdit(e){
let ss = e.source.getActiveSheet();
let name = ss.getName();
if (name == "Database" || e.range.rowStart == 1) return;
e.range.clearContent();
let db = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Database");
let r = ss.getRange(e.range.rowStart,1).getValue();
db.getRange(r+1,e.range.columnStart).setValue(e.value);
}
I'm Spencer Farris, a Google Product Expert for Sheets and Scripts. https://support.google.com/docs/profi...
On this page of the site you can watch the video online Google Sheets: 2-Way Sync Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Spencer Farris 29 September 2020, share the link with friends and acquaintances, this video has already been watched 20,316 times on youtube and it was liked by 192 viewers. Enjoy your viewing!
