replied on September 3, 2018
Hi Mary,
This will be possible through the use of Javascript. The below code should hopefully put you on the right track.
$(document).ready(function(){
$('.Submit').click(function(){
alert('This is an alert after the submit button has been pressed'); //provide an alert to the screen
return false; //prevents form from submitting
});
});
In the code, the alert is just a prompt to advise that the submit button was pressed and the "return false" will prevent the form from submitting. What you will need to do is work out a way to trigger your lookup by either retrieving values / doing calculations or inserting values where required and run an " IF else " condition.
Regards,
Aaron