The Omni Group
These forums are now read-only. Please visit our new forums to participate in discussion. A new account will be required to post in the new forums. For more info on the switch, see this post. Thank you!

Go Back   The Omni Group Forums > OmniOutliner > OmniOutliner 3 for Mac
FAQ Members List Calendar Search Today's Posts Mark Forums Read

 
Feature request: simple formulars Thread Tools Search this Thread Display Modes
Hi!

what I really want is a simple calculation / spreadsheet functionality.

E.g. I have an outline with columns like:

"hours spend" , "rate per hour", "sub total", "tax rate", "total".

And formulas like:
"sub total" := "hours spend" * "rate per hour";
"total" := "sub total" + "sub total" * "tax rate"; -- assuming tax rate is 0.x value

Currently I'm helping myself with AppleScripts. But it is very hard to keep the AppleScripts in synch with indentation levels and column names etc.

Probably a simple JavaScript or AppleScript integration would be enough? (Means having a script attached to a column, and knowing an evaluation order: "sub total" executed before "total").

Keep in mind that formulas like above only make sense for leaf rows, so probably one would need the ability to attach formulas to a row level.

Anyway, probably some one can enlighten me about how you do calculations in outlines.

Best Regards,

Angelo
 
We're planning to add such capabilities in a future version. Sorry for the inconvenience!
 
It's been 2 yrs since the last topic reply, I was wondering have your plans changed into adding formula capability or is it coming soon ?
 
Quote:
Originally Posted by angel'o'sphere View Post
Hi!

what I really want is a simple calculation / spreadsheet functionality.

E.g. I have an outline with columns like:

"hours spend" , "rate per hour", "sub total", "tax rate", "total".

And formulas like:
"sub total" := "hours spend" * "rate per hour";
"total" := "sub total" + "sub total" * "tax rate"; -- assuming tax rate is 0.x value
why don't you use a spreadsheet application then - such as numbers, or excel? that is what they were designed for.
 
Quote:
Originally Posted by kened View Post
why don't you use a spreadsheet application then - such as numbers, or excel? that is what they were designed for.
Excel and Number are just spreadsheets.. Not suitable for idea organization... Ideas are calculations, but calculations are not always ideas...

Even if Omnioutliner does not implement formulas and functions like in Numbers, it would have been very useful to just add this feature of being able to run shell scripts or applescripts and return the results to fields or cells in the document. That way we can use perl or ruby scripts and still get all the complicated calculations working or do some heavy text processing within omnioutliner...

Ability to trigger a shell script when something changes in one of the fields is still a feature request in numbers... Excel for mac has been wavering about VBA since 2002... so this is a feature which now you see well now you dont...

Feature request is :
Field.OnChange >> Trigger script (bash, pl, rb...)
Return result to a field

An example:
If I have then a template to organize a function, when I enter an email address and choose a checkbox, I can have the script send an email to one of the attendees...

Last edited by jdbtst; 2009-12-06 at 06:05 PM..
 
I'm with the OP on this..some simple calculations would be useful. I get that you can do all of that with Excel / Numbers; but the organisation of ideas-that-have-calculations is clunky in those programs (a lot of cutting and pasting).

I often create workshop agendas, and these have time calculations so I can gauge the impact of changing the duration of an activity. Numbers and Excel do this...but it is clunky and if I need to move an activity it requires a lot "re-wiring" of the data.
 
I've just discovered Omni Outline and am very impressed!

It's an excellent tool for many things - and one I'm using it for is detailed planning of facilitation or training events.

I too need a column which will do a simple calculation between start and end times to give a duration - or work out an end time from a duration and start time for sessions.

I see the first post on this thread was 2007 & you said you were working on it! I realise that you probably have loads of features you need to prioritise! And that you can't probably give a time, but are you still working on it? Do you think it may be released in the short or medium term?

thanks!

Joe
 
I see you guys just released OmniOutliner 4.0. Is this feature included?

Thanks,
-Adam
 
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Feature request: add simple text markups to iPad Notes editor Omen OmniFocus for iPad 1 2013-06-19 07:29 AM
Reducing task overload and bad multitasking by means of a simple feature Marek Kowalczyk OmniFocus 1 for Mac 5 2012-10-07 06:37 PM
Feature Request: Add in feature to ignore or set time for sync reminder rwhitney OmniFocus 1 for Mac 3 2009-06-11 03:30 PM
A simple button request figman OmniFocus 1 for Mac 4 2009-04-03 10:28 AM
Simple UI request: don't hide checked-off tasks immediately brianogilvie OmniFocus 1 for Mac 8 2007-05-29 06:12 PM


All times are GMT -8. The time now is 02:38 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.