Home

// send uses MailApp.sendEmail(message) // onOpen(e = onstart) writes (write your text and hit enter) // app confrts word to morse code // delet clears all cells // lan uses LanguageApp.translate to use api foe translate

function send() { var ui = SpreadsheetApp.getUi(); // Same variations.

var result = ui.prompt( 'the emal you wan to send this to', 'Please enter resipercants email:', ui.ButtonSet.OK_CANCEL);

// Process the user's response. var button = result.getSelectedButton(); var text = result.getResponseText(); if (button == ui.Button.OK) { // User clicked "OK". ui.alert('sending to ' + text + '.'); var ss = SpreadsheetApp.getActiveSpreadsheet(); MailApp.sendEmail( text , "morse code", ss. getRange("B1").getValue()); } else if (button == ui.Button.CANCEL) { // User clicked "Cancel". ui.alert('I didn't get your name.'); } else if (button == ui.Button.CLOSE) { // User clicked X in the title bar. ui.alert('You closed the dialog.'); } }

function onOpen(e) { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var cell = sheet.getRange("A2"); cell.setValue("write your text and hit enter"); }

function app() { const morseCode = { "A": ".-", "B": "-...", "C": "-.-.", "D": "-..", "E": ".", "F": "..-.", "G": "--.", "H": "....", "I": "..", "J": ".---", "K": "-.-", "L": ".-..", "M": "--", "N": "-.", "O": "---", "P": ".--.", "Q": "--.-", "R": ".-.", "S": "...", "T": "-", "U": "..-", "W": ".--", "X": "-..-", "Y": "-.--", "Z": "--..", "1": ".----", "2": "..---", "3": "...--", "4": "....-", "5": ".....", "6": "-....", "7": "--...", "8": "---..", "9": "----.", "0": "-----", "+": ".-.-.", "=": "-...-", "-": "-....-", "_": "..--.-", ".": ".-.-.- ", ",": "--..-- ", "?": "..--.. ", "'": ".----. ", "!": "-.-.-- ", "/": "-..-.", "(": "-.--.", ")": "-.--.-", "&": ".-...", ":": "---... ", ";": "-.-.-. ", "@": ".--.-.", "¿": "..-.-", "¡": "--...-"

} const convertToMorse = (str) => { return str.toUpperCase().split("").map(el => { return morseCode[el] ? morseCode[el] : el; }).join(""); };

var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var cell = sheet.getRange("B1"); var a = ss. getRange("A1").getValue();

cell.setValue(convertToMorse(a));

}

function delet(){ var ss = SpreadsheetApp.getActiveSheet(); ss.getRange("A1").clear(); ss.getRange("B1").clear(); ss.getRange("C1").clear(); ss.getRange("D1").clear(); }

function lan(){

var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var a = ss. getRange("A1").getValue();

var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var b = ss. getRange("C1").getValue();

var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheets()[0]; var c = ss. getRange("D1").getValue();

var d = ["af","sq","am","ar","hy","az","eu","be","bn","bs","bg","ca","zh","tw","co","hr","cs","da","nl","en","eo","et","fi","fr","fy","gl","ka","de","el","gu","ht","ha","haw","he ","hi","hu","is","ig","id","ga","it","ja","jv","kn","kk","km","rw","ko","ku","ky","Lao","lo","la","lv","lt","lb","mk","mg","ms","ml","mt","mi","mr","mn","my","ne","no","ny","or","ps","fa","pl","pt","pa","ro","ru","sm","gd","sr","st","sn","sd","si","sk","sl","so","es","su","sw","sv","tl","tg","ta","tt","te","th","tr","tk","uk","ur","ug","uz","vi","cy","xh","yi","yo","zu",];

if (d.includes(b)){ var b = (b);

} else { var b = ("en"); }

if (d.includes(c)){ var c = (c);

} else { var c = ("af"); }

var lang = LanguageApp.translate(a , b, c); var cell = sheet.getRange("B1"); cell.setValue(lang);

}