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

[John Ralls]

David,

Adrian is talking about the num field in scheduled transactions.

Regards,
John Ralls

> On 11 Apr 2025, at 12:06, David Carlson <david.carlson.417 at gmail.com> wrote:
> 
> 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
> _______________________________________________
> 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.