VCOO0019

OmniOutliner: Add Columns for Quarters

This command adds four columns to the outline document, divided into quarters: 1st QTR, 2nd QTR, 3rd QTR, and 4th QTR

A dialog is presented for indicating the formatting and alignment for the column content. Formats include:

• Text (abc)
• Integers (123)
• Decimal (123.00)
• Percent (123%)
• Decimal Percent (123.12%)
• Decimal Separators (1,234.12)
• Currency

Scope and Syntax

Language: English (United States 🇺🇸 · Great Britain 🇬🇧 · Australia 🇦🇺 · Canada 🇨🇦)

Scope: OmniOutliner

Command phrase variations (words in [brackets] are optional):

• “Add Columns for Quarters”

Requirements

• Application: OmniOutliner: 5.10 (macOS), OmniOutliner 3.9.1 (iOS/iPadOS)
• System: macOS 12, iOS 15, iPadOS 15

Video: Add Columns for Quarters

This command adds four columns to the outline document, divided into quarters: 1st QTR, 2nd QTR, 3rd QTR, and 4th QTR

PLAY (E) PAUSE BACK REWIND

Downloads

• ⇩ COMMANDS-FILE (OmniOutliner 5) (macOS)
• ⇩ SHORTCUT-LINK (“Add Columns for Quarters”) (iOS/iPadOS)

Script Code

Here is the script code for the commands:

Add Columns for Quarters
Copy

(async () => {
	try {
		function createUtterance(textToSpeak){
			AlexID = (
				(app.platformName === "macOS") ? 
				"com.apple.speech.synthesis.voice.Alex" : 
				"com.apple.speech.voice.Alex"
			)
			voiceObj = Speech.Voice.withIdentifier(AlexID)
			voiceRate = 0.4
			utterance = new Speech.Utterance(textToSpeak)
			utterance.voice = voiceObj
			utterance.rate = voiceRate
			return utterance
		}
		var synthesizer = new Speech.Synthesizer()
		
		inputForm = new Form()
		
		formats = ["Text (abc)", "Integers (123)", "Decimal (123.00)", "Percent (123%)", "Decimal Percent (123.12%)", "Decimal Separators (1,234.12)", "Currency"]
		formatMenu = new Form.Field.Option(
			"formatType", 
			"Format", 
			[0, 1, 2, 3, 4, 5, 6], 
			formats, 
			0
		)
		
		alignmentMenu = new Form.Field.Option(
			"alignmentValue", 
			"Align", 
			TextAlignment.all, 
			null, 
			TextAlignment.all[2]
		)
		
		inputForm.addField(formatMenu)
		inputForm.addField(alignmentMenu)
		
		inputForm.validate = function(formObject){
			return true
		}
		
		formPrompt = "Column type and alignment:"
		formButton = "Add"
		spokenPrompt = "Please indicate the column data type, and alignment."
		
		utterance = createUtterance(spokenPrompt)
		synthesizer.speakUtterance(utterance)

		formObject = await inputForm.show(formPrompt, formButton)
		
		alignmentValue = formObject.values['alignmentValue']
		formatType = formObject.values['formatType']
		
		switch(formatType) {
			case 0:
				var fmtr = null
				var columnType = Column.Type.Text
				break;
			case 1:
				var fmtr = Formatter.Decimal.plain
				var columnType = Column.Type.Number
				break;
			case 2:
				var fmtr = Formatter.Decimal.decimal
				var columnType = Column.Type.Number
				break;
			case 3:
				var fmtr = Formatter.Decimal.percent
				var columnType = Column.Type.Number
				break;
			case 4:
				var fmtr = Formatter.Decimal.percentWithDecimal
				var columnType = Column.Type.Number
				break;
			case 5:
				var fmtr = Formatter.Decimal.thousandsAndDecimal
				var columnType = Column.Type.Number
				break;
			case 6:
				var fmtr = Formatter.Decimal.currency()
				var columnType = Column.Type.Number
				break;
			default:
				var fmtr = Formatter.Decimal.plain
				var columnType = Column.Type.Number
				break;
		}

		tree = document.outline
		editor = document.editors[0]
		editor.autosizeTopicColumn = true
		
		columnTitles = ["1st QTR", "2nd QTR", "3rd QTR", "4th QTR"]
				
		columnTitles.forEach(columnTitle => {
			tree.addColumn(
				columnType,
				editor.afterColumn(),
				column => {
					column.title = columnTitle
					column.style.set(Style.Attribute.ParagraphAlignment, alignmentValue)
					if(fmtr){column.formatter = fmtr}
				}
			)
		})		
		
		utterance = createUtterance("Columns Added!")
		synthesizer.speakUtterance(utterance)
	}
	catch(err){
		utterance = createUtterance(err.message)
		synthesizer.speakUtterance(utterance)
		//new Alert(err.name, err.message).show()	
	}
})();