CFSol

Hi, I have just tried to recreate the above code but I cant get it to work. I have put my code below, any help would be appreciated. <script> if ('[@field:Invoice_Number]'.length<1) { document.write('<a href="https://c1hcp423.caspio.com/dp/c88fb000f4126dbfd7824161a0d3?Connote=[@field:Connote]">[@field:Connote]</a>'); } else { document.write('<a href="https://c1hcp423.caspio.com/dp/c88fb0000838aba48ed646358911?Connote=[@field:Connote]">[@field:Connote]</a>'); } </script>

I have created a data page that allows a record to be 'flagged' via a checkbox. (photo below) I am finding that if someone goes into the record to update another field, the email will resend. The only way I can think to combat this is by having the 'Flagged' checkbox untick itself once the email is sent so if other fields are updated, it wont register that the checkbox isn't ticked. Appreciate all help