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 <rlo...@gmail.com> Sent: 11 April 2025 02:32 To: David H <hell...@gmail.com> Cc: adrian_jo...@btinternet.com; gnucash-user@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 <hell...@gmail.com <mailto:hell...@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@gnucash.org <mailto:gnucash-user@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@gnucash.org <mailto:gnucash-user@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@gnucash.org <mailto:gnucash-user@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 rlo...@gmail.com <mailto:rlo...@gmail.com> Micah 6:8 _______________________________________________ gnucash-user mailing list gnucash-user@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.
