Code

Re: Check for a duplicate record prior to submit

RhysAZ — Thu, 02 Jul 2009 18:24:22 GMT

Thank you both. I'll give it a try. And yes, I've set up my main connection via the database as submit and receive.

Re: Check for a duplicate record prior to submit

Patrick Halstead — Thu, 02 Jul 2009 05:30:32 GMT

Clayton's post is correct. You need to add a receive connection on load. Check to see if a record with the date has already been added and if so, maybe disable the submit button and conditionally display some red guidance text telling them that they have already submitted (use conditional formatting to display that).

However, this won't work if your form doesn't close on submit. If users keep the form open, please add a rule that disables submit after they submit once. To do that, add a field to your form to track submits (main data source, or for extra credit you can add as a secondary data source).

Even so, users may still be upset because they may mistakenly submit before they meant to. I recommend warning them in both cases and just saying "You already submitted once today. The next time you submit, e-mail will be sent to the support alias. Please enter your justification here: ..." and provide a text box. That allows the user to submit again if they have second thoughts and the second submit should e-mail some distribution list with the justification. Then, you can refer to that if there is an issue. This way, you reduce your support costs.

Re: Check for a duplicate record prior to submit

warrtalon — Wed, 01 Jul 2009 22:47:08 GMT

Make sure your data connection to the DB can also receive (it already can if you create the form using the DB schema). Retrieve that column and see if any occurrence of that field contains today's date.

Check for a duplicate record prior to submit

RhysAZ — Wed, 01 Jul 2009 22:24:45 GMT

Hi-

My users submit their daily stats via an Infopath 2003 form to my Access 2003 database. In the form, they enter their name (text box) and the date (date picker), along with their stats for that day.

Is there a way (prior to submission to the database) to see if that user has already entered a record for that date? I would like to have a pop up message box letting them know that an existing record has already been created for that date, and prevent them from entering another record with that same date.

Thanks in advance,

RhysAZ