[GNC] Help with using formula in NUM field of Scheduled Transactions

[David Carlson]

 Adrian_Jolly,

The check number is controlled in the check printing process rather than
the scheduled transaction process.  There it is possible to correct for
misprints, etc.

As for simply giving each transaction a unique ID number in the Since Last
Run process, I never tried that myself.



On Fri, Apr 11, 2025 at 10:33 AM Adrian Jolly via gnucash-user <
gnucash-user at gnucash.org> wrote:

> Thanks for your responses, but I’m still unclear.
>
>
>
> Simple question – please answer Yes or No
>
>
>
> Can I enter a formula into a scheduled transaction so that the check
> number (Num field) will automatically increment?
>
>
>
> If the answer is Yes, can you help me make it work with a bit more detail
> and guidance
>
>
>
> If the answer is NO then thanks for your honesty and do you know of any
> workarounds that I might consider to achieve this function
>
>
>
> Many thanks
>
> Adrian
>
>
>
> From: R Losey <rlosey at gmail.com>
> Sent: 11 April 2025 02:32
> To: David H <hellvee at gmail.com>
> Cc: Adrian_Jolly at btinternet.com; gnucash-user at gnucash.org
> Subject: Re: [GNC] Help with using formula in NUM field of Scheduled
> Transactions
>
>
>
> Can I enter a formula into a scheduled transaction so that the check
> number will fill in with the next one?
>
>
>
>
>
> On Thu, Apr 10, 2025 at 7:48 PM David H <hellvee at gmail.com <mailto:
> hellvee at gmail.com> > wrote:
>
> Check the wiki at https://wiki.gnucash.org/wiki/Scheduled_Transactions
> ???
>
> Variables and Formulas were introduced to serve the *mortgage/loan druid*
> in
> 2002. Variables and Formulas work only in cells like Deposit and Withdrawal
> (or Debit and Credit if you have formal account names turned on) that
> require something that evaluates to a number.
>
>    1. Any text string [not followed by parens] entered in the template
>    transaction will be recognized as a *variable*, and you will be prompted
>    to provide a value when the scheduled transaction is created.
>    2. Any text string *followed by parens*, optionally with arguments, will
>    have the string "gnc:" prepended to it and *evaluated in the scheme
>    environment*.*Arguments* are separated with :. See fin.scm
>    <https://github.com/Gnucash/gnucash/blob/stable/bindings/guile/fin.scm>
> for
>    examples of providing functions.
>    3. There is a *magic variable* '*i'*, which stands for the *current
>    instance-count of the scheduled transaction*. 1 for the first, 2 for the
>    second, &c. It might be 0-based.
>
>
>    - I'd like to have a variable which decrements each month, in order to
>    automatically calculate sum-of-digits depreciation.
>
> In any case, if you know the starting point, "(42 - i)" should work.
> Cheers David H.
>
> On Fri, 11 Apr 2025 at 09:43, Adrian Jolly via gnucash-user <
> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> > wrote:
>
> > I require to schedule a weekly transaction, where the Num field
> increments
> > by 1 for each transaction
> >
> >
> >
> > My template has " i + 1 " (without the quotes), in the Num field. But
> all I
> > get is " i + 1 " (without the quotes) in each and every transaction.
> What
> > am I doing wrong?
> >
> >
> >
> >
> >
> >
> >
> > Adrian
> >
> >
> >
> >
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
>
>
>
>
>
> --
>
> _________________________________
> Richard Losey
> rlosey at gmail.com <mailto:rlosey at gmail.com>
> Micah 6:8
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson