Hi all, Just a not so humble brag.
For ages I've been looking to automate our gift vouchers and online forms away from CSIs to something a little more useful like an output set for automated sending by wordfly or an SSRS report where the form data is in distinct fields. Finally I've cracked the Stored Procedure pulling the data from TNEW to my Local table.
This will save my christmas morning not having to build and email gift vouchers. And we'll be able to take the war and peace sized answers that dance course students like to write about themselves that always blow up CSIs by going over the character limit.
I'll sleep well tonight
If you want to go a little further. You can give them a page in TNEW to see the balance and apply them to an order or donation. So, force a login in the on email, see the fancy landing page, do something.., apply to the cart. Found this to be effective to encourage retaining revenue from previous season. ~80% kept using this approach.