This is the part to choose which column.
If you want column C only, you change it to == 3, if you want any columns that are from column C backwards <= 3 or < 4.
Thank you very much it has worked!
1 Like
Hi with all due respect, I’m still learning how to use Glide, but this solution works only when you open the GS file, no?
Because when I toggle a switch in my app, nothing happens. Maybe I’m wrong.
I’m even if the file is closed it works? I mean the script runs?
Tks.
The script runs when you have added a trigger for it. The trigger will run automatically when there is a change in the sheet.
So u dont need to have the file opened? I have to study the trigger! many thx
Yeah you don’t have to open the sheet, when the trigger is set to run with an “On change” setup then it will be run automatically.
1 Like
Awesome! Thx so much! It worked! Perfect!
1 Like
onEdit worked but now onChange no.
27 de jul. de 2020 00:10:18 Erro Exception: Cell reference out of range
at onChange(Código:4:14)
function onChange(e){
var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var r = ss.getActiveCell();
if (r.getColumn() == 7 && ss.getName()==“BaseGlideApp_v2”) {
var celladdress =“I”+ r.getRowIndex()
ss.getRange(celladdress).setValue(new Date()).setNumberFormat(“dd/MM/yyyy hh:mm”);
}
var row = e.range.getRow();
var col = e.range.getColumn();
if (col == 7 && e.source.getActiveSheet().getName() == “BaseGlideApp_v2”){
e.source.getActiveSheet().getRange(row,9).setValue(new Date()).setNumberFormat(‘dd/MM/yyyy hh:mm’);
e.source.getActiveSheet().getRange(e.source.getActiveSheet().getLastRow(),6).setValue(‘última linha’);
}
It’s strange. Can you copy the data to a duplicated sheet and share to ariesarsenal@gmail.com so I can have a look?
Also, just to be sure, you want 3 actions for an action, to set current timestamp to column 7 & 9, and the value ‘última linha’ to column 6?
It doesn’t work when the changes are made with Glide. 
Have you added an “on change” trigger?
my bad, it works with the trigger 
1 Like
Dear, did you find a solution for this?
I am looking for the same thing.