AU2008201852A1 - Editing query conditions, calculations, formulas and equations - Google Patents

Description

00 00 Australian Patents Act 1990 Regulation 3.2 ORIGINAL COMPLETE SPECIFICATION STANDARD PATENT Invention Title "Editing query conditions, calculations, formulas and equations" The following statement is a full description of this invention, including the best method of performing it known to us:- Q:\OPER\RAB\30531536 cor div doc

I

00 -1o EDITING QUERY CONDITIONS, CALCULATIONS, FORMULAS AND EQUATIONS 00

BACKGROUND

SOn computer systems, specifying a query condition or calculation frequently 00 requires selecting from a list of valid options to fill specific roles in a query condition or 0 N 5 calculation. For example, conditions frequently take the form of <Variable> <Operator> 00 S<Variable Value>, for example, "Sales Costs." c1 User interfaces frequently present such an equation using a series of drop-down list boxes or other controls to select from the valid list of choices to fill each of the positions in the equation. Alternatively, applications often allow users to edit equations by simply entering the information in a text entry box, which can be both difficult, since the user is not given any guidance, and very error prone.

SUMMARY

In an embodiment of the present invention, keywords in query conditions and calculations, or other parts of a form, can be represented as hyperlinks by means of color coding and formatting. For example, text might be blue and underlined to match user expectations resulting from web browsing experience. Clicking on the hyperlink can display an appropriate control, in context, for editing the value of the clicked term. The control might be, for example, a list of valid choices or an text entry box for entering text.

The original term can then be replaced by the selected choice or entered value.

One advantage of the new solutions is that equations can be presented in a familiar, easily readable form, and edited in place. It is not necessary to present a series of controls that require substantially more screen real estate, and that often make it harder to read the equation.

Usability tests have shown that while users do not initially understand what the links are for, once they do understand how to use the links, users find using the links to be a very easy and natural way to edit equations. Compared to simply editing the text of an equation, these solutions provide much more guidance because the format of the equation 0 OPER'GCP2OO22367962 dox.

00 -2can be provided. In addition, there is less room for error, because modifications can be 00 C restricted to valid alternatives.

The solution is an elegant combination of a well known interface convention, i.e., N clicking on hyperlinks, to perform a new task, editing equations or other parts of a 00 5 form. It allows an equation to be presented in a simple, readable format, while maintaining 0 N its editability.

00 According to the invention there is provided a computer method for editing a form, N comprising: displaying a hyperlink for an element in the form, to indicate to a user that a control is available for the element, said hyperlink including a plurality of hyperlink targets, each of the hyperlink targets identified by reference to a Universal Resource Locator (URL), each of said hyperlink targets providing one of the group consisting of(i) a link from the form to another location, wherein the another location is identified by a particular URL in the hyperlink target, and (ii) a link from the form to another file, wherein the another file is identified by a particular URL in the hyperlink target; upon a selection of the hyperlink by the user, presenting the control, the control including the plurality of hyperlink targets for user interaction; selecting, via a user action, a hyperlink target from the plurality of hyperlink targets; and upon completion of user interaction with the control, replacing the element with a new element responsive to the user action.

The invention also provides a computer system for editing a form, comprising: a user interface for displaying information to a user and for accepting input from the user; a hyperlink displayed on the user interface for an element in the form, to indicate to the user that a control is available for the element, said hyperlink including a plurality of hyperlink targets, each of the hyperlink targets identified by reference to a Universal Resource Locator (URL), each of said hyperlink targets providing one of the group consisting of a link from the form to another location, wherein the another location is identified by a particular URL in the hyperlink target, and (ii) a link from the form to r _I I Q: WOPER'GCP1002236796c2 dc- 00 S-2Aanother file, wherein the another file is identified by a particular UJRL in the hyperlink 00 C target; upon a selection of the hyperlink by the user, the control being displayed on the t user interface for user interaction, the displayed control including the plurality of hyperlink 00 targets; 0 N selecting, via a user action, a hyperlink target from the plurality of hyperlink 00 targets; and Ni upon completion of user interaction with the control, a new element responsive to user action replacing the element.

The invention also provides a computer program product for editing a form, the computer program product comprising a computer useable storage medium having computer readable code thereon, including program code which: displays a hyperlink for an element in the form, to indicate to a user that a control is available for the element, said hyperlink including a plurality of hyperlink targets, each of the hyperlink targets identified by reference to a Universal Resource Locator (URL), each of said hyperlink targets providing one of the group consisting of(i) a link from the form to another location, wherein the another location is identified by a particular URL in the hyperlink target and (ii) a link from the form to another file, wherein the another file is identified by a particular URL in the hyperlink target; upon a selection of the hyperlink by the user, presents the selected control for user interaction, the presented control including the plurality ofhyperlink targets; selecting, via a user action a hyperlink target from the plurality of hyperlink targets; and upon completion of user interaction with the control, replaces the element with a new element responsive to the user action.

In one embodiment, upon completion of user interaction with the control, the element is replaced with a new element responsive to user action.

The form can be, but is not limited to, a database query or a spreadsheet.

The element can be, for example, part of a calculation.

The control can be, but is not limited to, a list of choices, such as a pull-down menu, a dialog box, or a text entry field.

P: OPER\RAB\Rcsponsc30531536 div.doc-28/0'200 00 00 (N 2B Finally, in one embodiment, the hyperlink is colour coded and underlined.

BRIEF DESCRIPTION OF THE DRAWINGS SPreferred embodiments of the present invention are hereinafter described, by way 00 5 of example only, with reference to the accompanying drawings in which like reference N< characters refer to the same parts throughout the different views, and wherein: 00 0Fig. 1 is a block diagram of a typical computer system which has been simplified C for the sake of discussion.

Fig. 2 is a screen shot which illustrates a preferred embodiment of the present invention.

Fig. 3 illustrates the screen of Fig. 2 after the user has clicked on the "Top" link.

Fig. 4 illustrates the screen of Fig. 2 after the user selects the "10" link.

Fig. 5 illustrates the screen of Fig. 2 after the user has selected "Bottom" and entered 00 -3- DETAILED DESCRIPTION 00 Fig. 1 is a block diagram of a typical computer system 8, which has been simplified for the sake of discussion. A processor 10 is typically connected to volatile memory 12 which may be external or internal to the CPU 10. The CPU 10 is also typically connected 00 5 to one or more storage media 14 such as hard disks, floppy disks, CD-ROMs and tape drives. Often a database is stored on the mass storage 14.

00 The CPU 10 is typically also connected to user input devices such as a mouse 16 O and a keyboard 18. These allow a user to input information and enterrequest such as database queries to the computer Output devices can include, for example, a printer 20 and a monitor 22.

Finally, a CPU 10 may be connected to other computers over a network 24 such as a local area network (LAN) or the internet.

Fig. 2 is a screen shot which illustrates a preferred embodiment of the present invention. The screen shot 30 includes an instruction area 32 which indicates to a user that the user should choose a condition similar to the condition that the user desires. The user is also instructed to modify the selected condition by clicking the blue underlined text.

Below the instruction 32, is a tree structure 33. A highlighted line illustrates a condition which the user has selected. There are three "links" in this condition: the descriptor "Top" 34, the value "10" 36 and the variable "Direct Cost" 38.

Fig. 3 illustrates the screen shot 30 after the user has clicked on the "Top" link 34.

In this particular example, a pull-down menu 40 appears, providing a list of valid choices to the user. These choices include "Top," "Bottom" and "Top or bottom." After selecting one of these choices, the selected choice will replace the existing link. For example, if the user selects "Bottom," the menu 40 will disappear and the highlighted line will now read "Bottom 10 based on Direct Cost." The "Top" link 40 is replaced by a "Bottom" link (not shown), which would typically, but not necessarily, bring up the same menu Fig. 4 similarly illustrates a screen shot 30 when the user selects the second link 36. In this particular example, a text entrybox 42 appears. This allows the user to enter any numeric value. Note that only numbers can be entered in this particular case, thus lowering the possibility of an error that could occur in free-form text entry.

00 -4- Fig. 5 illustrates the screen of Fig. 2 after the user has selected "Bottom" in the 00 pulldown menu 40 of Fig. 3 and entered in the text entry box 42 of Fig. 4. Note how the contents of the affected hyperlinks 34, 36 has changed according to the user's selections.

00 5 In similar fashion, when the user clicks on the "Direct Cost" link 38, a pull down menu of valid variables (not shown) appears.

00 Of course, these controls are exemplary. Other controls are equally possible. For example, a dialog for setting up some configuration might appear in response to selection of a link. The link is used to indicate to the user that a control is available.

The links may appear, for example, in a form, or a form letter. They can be used to edit a query into a database, stored for example, on mass storage 14, or to edit a spreadsheet or some calculation. In a particular embodiment, the text of the link is color coded and underlined. Alternatively, the text may be highlighted in some other manner.

As another example of the applicability of the present method, in composing a web page or other hypertext document using HTML or some other paging language, for a given tag, all valid parameters that can be used with the tag can be listed in a hyperlinked control.

Furthermore, a form letter could have hyperlinked pull-down menus for a title where "LMiss" and are options, as well as for the closing where options can be, for example, "Sincerely," "Very truly yours," etc.

It will be apparent to those of ordinary skill in the art that methods involved in the present system for editing query conditions, formulas and equations may be embodied in a computer program product that includes a computer usable medium. For example, such a computer usable medium can include a readable memory device, such as a hard drive device, a CD-ROM, a DVD-ROM, or a computer diskette, having computer readable program code segments stored thereon. The computer readable medium can also include a communications or transmission medium, such as a bus or a communications link, either optical, wired, or wireless, having program code segments carried thereon as digital or analog data signals.

While this invention has been particularly shown and described with references to particular embodiments thereof, it will be understood by those skilled in the art that various 1 Q \OPERGCP\200223676c do. I SATE 4ERGEFOR4AT 00 (N changes in form and details may be made therein without departing from the scope of the 00 invention encompassed by the appended claims.

The reference in this specification to any prior publication (or information derived from it), or to any matter which is known, is not, and should not be taken as an 00 S 5 acknowledgment or admission or any form of suggestion that that prior publication (or C information derived from it) or known matter forms part of the common general 00 knowledge in the field of endeavour to which this specification relates.

C Throughout this specification and the claims which follow, unless the context requires otherwise, the word "comprise", and variations such as "comprises" and "comprising", will be understood to imply the inclusion of a stated integer or step or group of integers or steps but not the exclusion of any other integer or step or group of integers or steps.

Claims (12)

1. A computer method for editing a form, comprising: displaying a hyperlink for an element in the form, to indicate to a user that a control 00 S 5 is available for the element, said hyperlink including a plurality of hyperlink targets, each of the hyperlink targets identified by reference to a Universal Resource Locator (URL), 00 each of said hyperlink targets providing one of the group consisting of(i) a link from the C1 form to another location, wherein the another location is identified by a particular URL in the hyperlink target, and (ii) a link from the form to another file, wherein the another file is identified by a particular URL in the hyperlink target; upon a selection of the hyperlink by the user, presenting the control, the control including the plurality of hyperlink targets for user interaction; selecting, via a user action, a hyperlink target from the plurality of hyperlink targets; and upon completion of user interaction with the control, replacing the element with a new element responsive to the user action.

2. The method of claim 1, wherein the form is a database query.

3. The method of claim 1, wherein the form is a spreadsheet.

4. The method of claim 1, wherein the element is part of a calculation. The method of claim 1, wherein the element is part of a formula.

6. The method of claim 1, wherein the control is a list of choices.

7. The method of claim 6, wherein the list of choices is a pull-down menu.

8. The method of claim 1, wherein the control is a dialog box. Q \OPERIGC\202236796c2 doc- 00 -7-

9. The method of claim 1, wherein the control is a text entry field. 00 The method of claim 1, further comprising: Nt upon completion of user interaction with the control, replacing the element with a 00 5 new element responsive to user action, wherein the control is selected from a group of 0 N, controls consisting of a list, a dialog box and a text entry field. 00 S11. A computer system for editing a form, comprising: a user interface for displaying information to a user and for accepting input from the user; a hyperlink displayed on the user interface for an element in the form, to indicate to the user that a control is available for the element, said hyperlink including a plurality of hyperlink targets, each of the hyperlink targets identified by reference to a Universal Resource Locator (URL), each of said hyperlink targets providing one of the group consisting of(i) a link from the form to another location, wherein the another location is identified by a particular URL in the hyperlink target, and (ii) a link from the form to another file, wherein the another file is identified by a particular URL in the hyperlink target; upon a selection of the hyperlink by the user, the control being displayed on the user interface for user interaction, the displayed control including the plurality of hyperlink targets; selecting, via a user action, a hyperlink target from the plurality of hyperlink targets; and upon completion of user interaction with the control, a new element responsive to user action replacing the element.

12. The computer system of claim 11, wherein the control is selected from a group of controls consisting of a list, a dialog box and a text entry field.

13. A computer program product for editing a form, the computer program product comprising a computer useable storage medium having computer readable code thereon, 1 Q \OPERGCP\2IO2236796c.doc- IATE 4ERGEFOR4AT 00 00 displays a hyperlink for an element in the form, to indicate to a user that a control is 00 available for the element, said hyperlink including a plurality ofhyperlink targets, each of S 5 of said hyperlink targets providing one of the group consisting of a link from the form 0 N, to another location, wherein the another location is identified by a particular URL in the 00 0hyperlink target and (ii) a link from the form to another file, wherein the another file is N1 identified by a particular URL in the hyperlink target; upon a selection of the hyperlink by the user, presents the selected control for user interaction, the presented control including the plurality of hyperlink targets; selecting, via a user action a hyperlink target from the plurality of hyperlink targets; and upon completion of user interaction with the control, replaces the element with a new element responsive to the user action.

14. A computer method for editing a form substantially as hereinbefore described with reference to the accompanying drawings. A computer system for editing a form substantially as hereinbefore described with reference to the accompanying drawings.

16. A computer program product for editing a form substantially as hereinbefore described with reference to the accompanying drawings.