Setting the Invoice Number to Reset Per Month
Hi all, I'm working on the above. I have got everything working in terms of the month reset with a script trigger on the invoice date - the user enters the date themselves (I think this is best as they want control over that).
However, if they click the wrong date and then click it again (or just enter the date twice) a new invoice number gets added. How can I set up an If situation to prevent this? I've tried a few different things. Attached images.