From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: how to group together fields
Date: Sun, 23 Feb 2014 08:32:39 +0100
Message-ID: <CALn3zoj0oR5kytZ5ekgMzL_4STdiwM4mmY0Jm425y=QE7y4FzA@mail.gmail.com>
References: <87fvo5tqvo.fsf@mars.lan> <87fvo4bcjw.fsf@gmail.com>
	<87r47nshuh.fsf@mars.lan> <87bnyrayda.fsf@gmail.com>
	<87ioszrr6l.fsf@mars.lan> <87wqhf9fmy.fsf@gmail.com>
	<87d2j7rno9.fsf@mars.lan> <87txcgy3ya.fsf@bzg.ath.cx>
	<8738k09q13.fsf@mars.lan>
	<CALn3zojuvqgnzkW2e2B6WPpF+ipSN3gLbcAN9xZrdR=P_VoYoA@mail.gmail.com>
	<87siraiqdx.fsf@mars.lan>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:59628)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1WHTYH-0001gj-S5
	for emacs-orgmode@gnu.org; Sun, 23 Feb 2014 02:32:42 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1WHTYG-0005op-DB
	for emacs-orgmode@gnu.org; Sun, 23 Feb 2014 02:32:41 -0500
Received: from mail-qa0-x22e.google.com ([2607:f8b0:400d:c00::22e]:34087)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1WHTYG-0005oj-8u
	for emacs-orgmode@gnu.org; Sun, 23 Feb 2014 02:32:40 -0500
Received: by mail-qa0-f46.google.com with SMTP id k15so5119122qaq.33
	for <emacs-orgmode@gnu.org>; Sat, 22 Feb 2014 23:32:39 -0800 (PST)
In-Reply-To: <87siraiqdx.fsf@mars.lan>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Stefan Huchler <stefan.huchler@mail.de>
Cc: Org Mode <emacs-orgmode@gnu.org>

Hi Stefan

On Sun, Feb 23, 2014 at 2:12 AM, Stefan Huchler <stefan.huchler@mail.de> wrote:
> that works great, sadly I have to type in the name of the shop
> redundantly but I can live with that, with a good org-capture template I
> could tab-complete them so it would not be that problem.
>
> I dont want to bother you endlessly but just if you happen to know that
> randomly:
>
> can you somehow define a template that autocompletes to all other values
> like that:
>
> %^{Shop|shop 1|shop 2|**all-knows-old-choices**}

Although there are many completion tools I doubt that there is one
which knows in which Org table column you are.
http://www.emacswiki.org/emacs/CategoryCompletion

But [...]_ALL to predefine Org property values to be selected easily
in the column view as described here
http://orgmode.org/manual/Property-syntax.html
knows in which column you are. To make benefit of this you could use a
flat tree with an entry for each purchase and a property for product,
shop and rating and capture the column view with
http://orgmode.org/manual/Capturing-column-view.html
into the known table "#+NAME: data" to be processed further.

> A second question for me in trying to understand your code:
>
>  @I$4..@>$4
>
> I get @> stands for something like first line or is it a * wildcard? I
> should find that somewhere in doku but what does @I stand for?

@> is the last row, @I is the first hline to exclude the table header
that could have more than one line. For both and more see
http://orgmode.org/manual/References.html

Michael