MOISES A. REICHERT motz182
motz182
/ removeAll.txt
Last active
February 28, 2022 20:24
— forked from iaindooley/gist:1050206046077b04c489433f0f85d9e6
removeAllAttachments
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| new Notification(notification).addedLabel("Remove All Attachments").card().attachments().each(function(att) | |
| { | |
| att.remove(); | |
| }); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** @OnlyCurrentDoc */ | |
| function custo() { | |
| var spreadsheet = SpreadsheetApp.getActive(); | |
| spreadsheet.getRange('F5:F29').activate(); | |
| spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Calc Custo'), true); | |
| spreadsheet.getRange('C:C').activate(); | |
| spreadsheet.getActiveSheet().insertColumnsAfter(spreadsheet.getActiveRange().getLastColumn(), 1); | |
| spreadsheet.getActiveRange().offset(0, spreadsheet.getActiveRange().getNumColumns(), spreadsheet.getActiveRange().getNumRows(), 1).activate(); | |
| spreadsheet.getRange('D2').activate(); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /** | |
| * @copyright 2014-2019 Sentora Project (http://www.sentora.org/) | |
| * Sentora is a GPL fork of the ZPanel Project whose original header follows: | |
| * | |
| * ZPanel - A Cross-Platform Open-Source Web Hosting Control panel. | |
| * | |
| * @package ZPanel | |
| * @version $Id$ |
motz182
/ copy_not_duplicated.txt
Last active
September 12, 2019 03:57
— forked from iaindooley/gist:1a5f6411524cc60f010636b781e5885d
Copy card if not duplicated
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function copp_auto(notification) | |
| { | |
| var added = new Notification(notification).addedCard("Fechada"); | |
| try | |
| { | |
| added.board("Automação").list("Temp").card(added.name()); | |
| } | |
| catch(e) |
motz182
/ Checklist_corte.txt
Last active
November 26, 2019 02:52
— forked from iaindooley/gist:6b414089d8d421eabdd7b59762e03bf7
Add labels to checklist
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function addchecklistfromlabel(notification) | |
| { | |
| new Notification(notification).cards().each(function(card) | |
| { var label = new Notification(notification).addedLabel(); | |
| card.addChecklist("Corte",function(list) | |
| { | |
| list.addItem(label.name()); | |
| }); |
motz182
/ cp_to_esc
Last active
September 11, 2021 03:34
— forked from iaindooley/Linked checklists
Linked checklists
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function CpEscritorio(notification) | |
| { | |
| //Get a card moved to the Fechada List | |
| var card = new Notification(notification).movedCard("Obras Fechadas"); | |
| //Copy the card to the top of the Started list in the Work In Progress Board | |
| card.attachLink( | |
| card | |
| .copyToList(new Trellinator().board("Automação").findOrCreateList("Temp"),"top") | |
| .attachLink(card.link()) | |
| .link() |
motz182
/ mv_Esc.txt
Last active
September 7, 2019 23:34
— forked from iaindooley/gist:765d40fbadb8ff42a9a9564dca54ab98
Move card to Escritorio
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function MvEsc(notification) | |
| { | |
| new Notification(notification) | |
| .movedCard("Fechada") | |
| .moveToList(Board.findOrCreate("Escritório - Alumínio").findOrCreateList("Obras Fechadas")); | |
| } |
motz182
/ add_checklist_from_label
Last active
September 19, 2019 16:08
— forked from iaindooley/add_checklist_from_label
Add checklist from label
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function addChecklistFromLabel(notification) | |
| { | |
| var label = new Notification(notification).addedLabel(); | |
| label.card().board("Orçamentos - Alumínio").card("teste").addChecklist(label.name(),label.card()); | |
| } |
motz182
/ perfil add
Last active
September 8, 2019 18:07
— forked from iaindooley/notify_on_label_add
Notify on label add
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function notifyOnLabelAdd(notification) | |
| { | |
| var label = new Notification(notification).addedLabel(); | |
| label.card().postComment("Esquadria "+label.name()); | |
| } |
motz182
/ Full audit trail
Created
September 7, 2019 02:56
— forked from iaindooley/Full audit trail
Full audit trail
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function fullAuditTrail(notification) | |
| { | |
| var notif = new Notification(notification); | |
| var card = notif.card(); | |
| try | |
| { | |
| var sheet = SpreadsheetApp.openByUrl(card.attachment("Full Audit Trail").link()).getSheetByName("Actions Log"); | |
| } |
NewerOlder