Javascript Confirm Record Submission

[sjenkins]

I am trying to create a function that will trigger on submission of a single record form grid, search for duplicates of a certain field, and then generate a javascript confirm box that will let the user decide whether or not to submit the record.

Using the videos and support forums, I have created an AJAX callback function triggered on the Javascript System CanGridSubmit event.

var rowNum = {grid.object}._selectedRow;
{grid.Object}.ajaxCallback('G',rowNum,'Submit','','_getData=true');

The Submit function uses SQL to search for the duplicate records. But I'm having trouble with the Xbasic and Javascript below. I can't figure out how to cancel the submit. I've tried another AJAX callback, but it seems like that fires too late, after the submit has happenned.

jscmd = jscmd + <<%js%
var answer = confirm('Ok To Add Record');

if(answer == true) {
alert('Record will be added');

} else {
alert('Record will not be added');
var rowNum = {grid.object}._selectedRow;
{grid.Object}.ajaxCallback('G',rowNum,'DontSubmit','','_getData=true');
}
%js%

Submit = jscmd
--

Is there a way to send a 'return false' back to the CanGridSubmit event handler if the person cancels?
--
The second part of the question is:

I see how to create a javascript alert box using a variable Xbasic below.

dim msc as c
msg = "This is A Duplicate Record With AcctID: " + results' (Results are the list of duplicate ids)
msg = js_escape(msg)
Submit = msg
dim jscmd as c
jscmd = "alert('" + msg + "');"

But I would really like to have the msg variable used directly in the confirm box.
However, I believe the confirm box must be in the javascript section so the if statement can be based on the result of the confirm box, and I dont know how to pass that msg variable to the confirm statement.



Any help would be appreciated.

Steve Jenkins

[danh]

Re: Javascript Confirm Record Submission

Steve, wondering if you had any success figuring this out. I also am looking for a way to send a 'return false' back to the browser from an ajaxcallback to cancel a submit.

Dan

[sjenkins]

Re: Javascript Confirm Record Submission

Not yet. Hoping someone responds with some guidance. Will let you know if I hear something.

Steve

[Davidk]

Re: Javascript Confirm Record Submission

Would you care if you had to replace the default Submit with your own?

[sjenkins]

Re: Javascript Confirm Record Submission

I could probably live with that. I thought that might be a solution, so that I wouldn't have to depend on the System event. Do you have an example of that?

[Davidk]

Re: Javascript Confirm Record Submission

In the Customize Grid Toolbar template, Editable Grid, put in the Default code, and then change it a bit. Here's my full code. I commented out the A5 submit button and put mine in. All of this, thanks to Bob Moore, by the way - found here http://msgboard.alphasoftware.com/al...ghlight=submit

<tr>
	<td colspan="{grid.colspan}" class="[class.gridPartToolbar]" nowrap="nowrap" >
		<table cellspacing="0" border="0" cellpadding="0" style="width:100%;">
			<tr>
				<td nowrap="nowrap" align="{grid.RecordNavigatorAlignment}">
					{grid.GridViewAddNewRecordHyperlink} {grid.RecordNavigatorButtons} {grid.RecordsPerPage}&nbsp;&nbsp;&nbsp;{grid.toggleQBERowHyperlink}
					&nbsp;&nbsp;{grid.ActionButtonHTMLTemplate}
					&nbsp;&nbsp;{grid.ExportDataButton}
					&nbsp;{grid.HelpWindowButton}
				</td>
				<td nowrap="nowrap" align="right">
					<button button class="{Grid.style} Button" id ="btnSubmit" onclick="newSubmit()">Submit</button>
					<!-- {grid.grid_part.submitbuttons} -->
				</td>
			</tr>
		</table>
	</td>
</tr>

In the onGridRender event

$('btnSubmit').disabled=true;

In the onRowStatechange event

$('btnClose').disabled= e.isDirty ? false:true;

In the Local CSS Definitions, in the Code View:

button:disabled{
opacity: .5;

}

Finally a Javascript Function Declaration

function newSubmit()
	{
	alert('Submit Button');
	}

In which you can do an ajax callback to get your stuff done, etc.