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

[adrian_jolly]

Many thanks John. Really appreciate your answer. ThanksAdrianSent from my Galaxy
-------- Original message --------From: John Ralls <jralls at ceridwen.us> Date: 11/04/2025  18:22  (GMT+00:00) To: Adrian_Jolly at btinternet.com Cc: R Losey <rlosey at gmail.com>, David H <hellvee at gmail.com>, gnucash-user at gnucash.org Subject: Re: [GNC] Help with using formula in NUM field of Scheduled Transactions Adrian,No, you cannot create a scheduled transaction with a formula in the Num field. There is no direct workaround. The simplest thing to do would be to schedule the transaction without the Num field entry and manually update the created transaction each time. You need only select the Num field in the transaction, type + to insert the next number, and <enter> to commit the edit.Otherwise you’d need to program the insertion with either the python bindings or with an external access library like PyCash.Regards,John RallsOn 11 Apr 2025, at 11:32, 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 NoCan 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 guidanceIf the answer is NO then thanks for your honesty and do you know of any workarounds that I might consider to achieve this functionMany thanksAdrian