Script in Google Spreadsheets. How to track event changes to a cell?
Good afternoon everyone. Make a file where we keep the family budget. Faced with the next problem. There is a "direction" and "category products". In one direction is collected by certain category of products. There is also a form of input (type of survey) that we could score transactions through mobile phones. So, you need to make a script analyze a product category and a gun was put down by the direction. For example, the category "metro", a gun is put in the adjacent column direction "transport". I wrote a sample script which reads the contents of the current cell and enters the results in the first. The question is, how does it all hang on the input event (hit enter - the script worked)
Asked: oshliaer 21-06-2012 в 13:10:32
In this case, it is possible to use ready-made free solution bkper.com the App has a number of advantages and several options for integration with Google Drive (upload scans from Disk, the import values to the Table using additions) - oshliaer 21-04-2015 в 17:48:59
You probably use a trigger onEdit(event):
Answered: Ilya Pirogov 21-06-2012 в 13:51:36
It's very simple, use the function onEdit(event) which only responds to the data in the table changes. An example of a solution that change when any row enter the data in column number 8 line number that was changed by You
Based on Your problem You only have to rewrite the iF condition.
Answered: santer 22-04-2015 в 00:10:51