I’m trying to make a customer profile page to make viewing selected clients easy on the eye and to edit. I want to edit and update on edit the data from the easy on the eye section (cells B3, B5, C3, E4)
not the row. From what I understand I can’t use a formula for this, it would need to be app script.
I have found on edit update appscript. However for this to work you have to add column and row number. The data is filtered in cell A13. It is then query(to show the information on the easy on the eye section
The ID’s in col A corrispond to the row numbers. Could this be used to locate row to update onedit of specific cells in the selected range?
The range is filtered (ROW A13 by the ID types into cell B2
HERE is the script
Appscript
function onEdit(e) {
var range = e.range;
var spreadSheet = e.source;
var sheetName = spreadSheet.getActiveSheet().get Name();
var column = range.getColumn();
var row = range.getRow();
var inputValue = e.value;
if(sheetName == 'ONEDIT' && column == 1 && row == 1)
{
SpreadsheetApp.getActiveSpreadseet().getSheetByName(‘ONEDIT’).getRange(‘A2’).setValue([inputValue]);
}
}
How do I edit this appscript to include multiple. Cells based on the row ID in B2
Thanks in advance
Luan