Trying to use Sheetgo for a two-way connection on google docs.
I have a master database in one google sheet (Master) that contains 144 lines of data. I was successfully able to make a connection in a new google sheet (A) that is a subset of the Master Data - comes out to about 44 lines of data. I want certain members of the team to be able to update sheet A and for that data to update the Master sheet. However when the Master sheet is updated with Sheet A’s info it deletes all of the other info on the Master sheet, so now my Master sheet is 44 lines of data - the same lines I originally imported into Sheet A
I want to maintain the original Master data and only update the appropriate lines from Sheet A.
any help is appreciated!