Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- span class="re5"> function Ausgaben(){
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var Main=ss.getSheetByName("Main");
- var List=ss.getSheetByName("List");
- var DateCell = Main.getRange("A3");
- var Werte1 = Main.getRange("A3:I3");
- var Werte2 = Main.getRange("J3:M3");
- var nextLineCell = List.getRange(408,2).getCell(1,1);
- var nextLine = nextLineCell.getDisplayValue();
- var nextRange1 = List.getRange(nextLine,1,1,9);
- var nextRange2 = List.getRange(nextLine,27,1,4);
- var Datum = Werte1.getCell(1,1);
- var Betreff = Werte1.getCell(1,2);
- var Details = Werte1.getCell(1,3);
- var Betrag = Werte1.getCell(1,4);
- var Zahlender = Werte1.getCell(1,5);
- var MussMaze = Werte1.getCell(1,6);
- var MussSean = Werte1.getCell(1,7);
- var MussHan = Werte1.getCell(1,8);
- var MussChristian = Werte1.getCell(1,9);
- var hatMaze = Werte2.getCell(1,1);
- var hatSean = Werte2.getCell(1,2);
- var hatHan = Werte2.getCell(1,3);
- var hatChristian = Werte2.getCell(1,4);
- var nextValues1 = [[Datum.getValue(),Betreff.getValue(),Details.getValue(),Betrag.getValue(),Zahlender.getValue(),MussMaze.getValue(),MussSean.getValue(),MussHan.getValue(),MussChristian.getValue()]];
- var nextValues2 = [[hatMaze.getValue(),hatSean.getValue(),hatHan.getValue(),hatChristian.getValue()]];
- var Eintrag1 = nextRange1.setValues(nextValues1);
- var Eintrag2 = nextRange2.setValues(nextValues2);
- var Back1 = Werte1.setValues([["","","","","","","","",""]]);
- var Back2 = Werte2.setValues([["","","",""]]);
- var Back3 = DateCell.setFormula("=today()");
- }
- function Rückzahlen(){
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var Main=ss.getSheetByName("Main");
- var List=ss.getSheetByName("List");
- var DateCell = Main.getRange("A7");
- var DummyWerte = Main.getRange("A7:I7");
- var Werte1 = List.getRange("A411:I411");
- var nextLineCell = List.getRange(408,2).getCell(1,1);
- var nextLine = nextLineCell.getDisplayValue();
- var nextRange1 = List.getRange(nextLine,1,1,9);
- var Datum = Werte1.getCell(1,1);
- var Betreff = Werte1.getCell(1,2);
- var Details = Werte1.getCell(1,3);
- var Betrag = Werte1.getCell(1,4);
- var Zahlender = Werte1.getCell(1,5);
- var MussMaze = Werte1.getCell(1,6);
- var MussSean = Werte1.getCell(1,7);
- var MussHan = Werte1.getCell(1,8);
- var MussChristian = Werte1.getCell(1,9);
- var nextValues1 = [[Datum.getValue(),Betreff.getValue(),Details.getValue(),Betrag.getValue(),Zahlender.getValue(),MussMaze.getValue(),MussSean.getValue(),MussHan.getValue(),MussChristian.getValue()]];
- var Eintrag1 = nextRange1.setValues(nextValues1);
- var Back1 = DummyWerte.setValues([["","Schuldenrückzahlung","","","","","","",""]]);
- var Back3 = DateCell.setFormula("=today()");
- }
- function Einnahmen(){
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var Main=ss.getSheetByName("Main");
- var List=ss.getSheetByName("List");
- var DateCell = Main.getRange("A11");
- var DummyWerte = Main.getRange("A11:I11");
- var Werte1 = List.getRange("A413:I413");
- var nextLineCell = List.getRange(408,2).getCell(1,1);
- var nextLine = nextLineCell.getDisplayValue();
- var nextRange1 = List.getRange(nextLine,1,1,9);
- var Datum = Werte1.getCell(1,1);
- var Betreff = Werte1.getCell(1,2);
- var Details = Werte1.getCell(1,3);
- var Betrag = Werte1.getCell(1,4);
- var Zahlender = Werte1.getCell(1,5);
- var MussMaze = Werte1.getCell(1,6);
- var MussSean = Werte1.getCell(1,7);
- var MussHan = Werte1.getCell(1,8);
- var MussChristian = Werte1.getCell(1,9);
- var nextValues1 = [[Datum.getValue(),Betreff.getValue(),Details.getValue(),Betrag.getValue(),Zahlender.getValue(),MussMaze.getValue(),MussSean.getValue(),MussHan.getValue(),MussChristian.getValue()]];
- var Eintrag1 = nextRange1.setValues(nextValues1);
- var Back1 = DummyWerte.setValues([["","","","","","","","",""]]);
- var Back3 = DateCell.setFormula("=today()");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement