Auto Action that will fire ONLY on the following recurring payments but not on the first one

For me it is not a problem now as I've kind of turned off your invoices numbering and made my own with the 3 UPDATE queries in the autoAction I've posted above.

What you're saying is with the above it's incrementing even though increment setting is set to 0? Is it always incrementing by 1?

Now I've noticed a bigger problem: the invoicing fields are mandatory but if the user doesn't change any of the pre-populated invoicing fields nothing gets saved in the CB invoicing fields. And because I'm including them fields in the emails with your substitutions, namely:

You can use an IF substitution to condition those fields and only show them if they actually have a value. I don't know when exactly those fields are populated, but depending on the trigger used you should be able to directly access the baskets columns, which contain the invoice address information.

What you're saying is with the above it's incrementing even though increment setting is set to 0? Is it always incrementing by 1?

After a lot of tests I can say that it was not working. The invoice number was not increasing, unfortunately.

I've decided to do it like you've suggested:

The below should work to allow a CB field to act as the invoice number. The CB field you'd use is a query field that calculates the invoice number. It would always need to return the next invoice number.

But I don't know how to write the query which will always calculate the next invoice number. Could you help me with this please?

For now, I've made a text field which is filled with the highest this far invoice number and I've changed my query autoAction to only update that field + 1 like so:



with this query in it:

It iwll be very difficult for me to write the if statement that will grab either for example the value of [cb_subs_inv_first_name] or the value of [firstname] and would be very grateful if you could help me with that also.

Thank you,
ricco

www.joomlapolis.com/forum/153-professional-member-support/232620-auto-action-that-will-fire-only-on-the-following-recurring-payments-but-not-on-the-first-one?limitstart=0#277032

Based off your queries in your above reply you should only need to use the below configuration within CBSubs > Settings > Display > Invoices.

Numbering of invoices: Proforma invoice number at order time, then different final invoice number once paid
Proforma Invoice number format: [NUMBER]
Increment each consecutive Proforma Invoice [NUMBER] by: 1
Invoice number format: [NUMBER]
Increment each consecutive Invoice [NUMBER] by: 1

The invoice number will then increment by 1. You can set whatever start value you like as well (see substitution descriptions). You have the increment set to 0 so it of course won't increment. Please note you are trying to make invoice numbers unique per user, which isn't correct as it means you'll have duplicate invoice numbers in your system and is not good for record keeping.

I can not help you with writing custom queries. We only provide simple examples at best, sorry.

Do you think of me as an enemy or as a customer?

All is working for now as per your last suggestions. Thank you.

My suggestion was to write a database query that will give an invoice number that meets your criteria. Whether it be to count the baskets and increment that count by 1 and use that as invoice number or you could count the payments then increment that by 1 as the invoice number. That's entirely up to you. You can use the query in a CB Query Field then substitute it into the invoice number format parameters. Below are some simple example queries.

Count Baskets:
Count Payments:
In your case payment counting probably makes most sense as each recurring payment will increment the invoice number. If you wanted it user specific (not recommended) then the below should also work.

Count Baskets (User Specific):
Count Payments (User Specific):
I can not provide you with anymore more specific. I am not here to write custom code for you, sorry. We do not do that here. See my signature in every post for clarification regarding this. You will need to write your own queries to fit your specific needs. I can only provide you with simple examples.