Prevent records Submit(save) on records duplicates

I’m looking for some ideas how to check for duplicates;

I have custom category ActiveView modified to have only Submit and Cancel buttons. I already have javascript in place to check for duplicates running subWRs.

How/where do I place my code with Submit button: I need to prevent Submit and display duplicate message in case duplicate record exists.

Here is the Submit button line from footer section:

Find more posts tagged with

Comments

Dave Carpeneto

Hiya - if what you're wanting to do is the following when someone clicks on the 'submit' button:

if no duplicates: submit
if there are duplicates: pop up a warning

... then FWIW Id do the following:

replace your 'submit' button with a 'regular' button which has 'onclick="submitFunction()"'
put the above logic in the submitFunction() :
- if no duplicates: document.getElementById("myForm").submit();
- if there are duplicates: alert(duplicateItemsText)

MFarkas

Thanks David, I almost got it all working. The “.submit” works, until I put my “zCheckDups();” inside the function. Once I put it in, it stops working.

The reason could be that I use sendRequest() + HandlerFunction() to call sub-WR, which produces the duplicates list.

All this code is in ActiveView header, and I see other “.submit()” there and they setup some other parameters before the call: for ex Apply button has this code:

document.InfoAttrsForm.ApplyCmd.value = '1';

document.InfoAttrsForm.submit();

Do you think the sendRequest() is resetting any of the parameters ? If yes, which document.InfoAttrsForm.* parameters I need to setup/clear in order to successfully “.submit” the form.

Here is my function with submit:

function zApplyData() {

zCheckDups(); [// it does not work with this line

if ( gDupCerts1 > " " ) {

alert("Warning!! Duplicate CertificateID exists: " + gDupCerts1 );

}

else {

alert("all ok! should submit now! " );

[// document.getElementById("InfoAttrsForm").submit();

document.InfoAttrsForm.submit();

}

Dave Carpeneto

> The “.submit” works, until I put my “zCheckDups();” inside the function. Once I put it in, it stops working.

It's tough to say why this doesn't work, since I don't know when it gets called / how it gets called. Do you know what the state of things is when you add this method back in / how it is messing things up? Personally I'd just put some console.log("I am here & value 'x' is "+x) lines in various points around the method / where the method is called & watch what happens in the console ;-) Another option is to add breakpoints via the dev tools in your browser, but I'm not that fancy :-P

> Do you think the sendRequest() is resetting any of the parameters

I'm not sure what sendRequest() is, so I dunno :-(

MFarkas

Thank you David. The issue is that my javascripts are asynchronous, that’s why I’m having all the problems. Will need to figure out how to change it all to be synchronous code.

John Simon

Another option may be to use SetTimeout, or better yet jquery's "deferred" (so you don't call submit until your CheckDups returns).

Cheers...

MFarkas

Thank you John. I have the setTimeout working; do you have an example code you can share for jquery deferred option?

John Simon

From the Advanced Web Reports help page, documentation on SendRequest:

Takes the following arguments:

URLreference (number/String): a required parameter. Either a URL or the numeric objectId (dataId) or the nickname (String) of the WebReport. If the nickname is numeric then it should be enclosed in quotes.

responseFunction (function): a required parameter. Function to be executed when the AJAX request returns.

reqType ('string','json','xml'): an optional parameter. The type of request to send to the web server (Content Server). Valid types are either GET or POST. The default value is GET.

optionalParms (String): an optional parameter. Any parameters to be passed to the target WebReport being executed. optionalParms has the format: &parm1=value1,&parm2=value2...

You can use the 2nd argument to pass a function that gets executed AFTER the request is executed. So change wherever you call SendRequest to call your "next" function.

Cheers...