How to Display an alert in Record producer if form variable value not matched in table

[vsharma]

Hi All:

I have a Record producer (table - u_visitor with fields - Name/ mobile no/ checkin time/ checkout time/ state) where I need to check mobile number and if it matches in table then user state change to "checked out" else alert user to check mobile number and abort.

I tried but not able to get else condition work to alert user & abort process. Please suggest.

—— Record Producer Script section -------

var mno = producer.u_mobile_number;

var rec = new GlideRecord('u_visitor');

rec.addQuery('u_mobile_number', mno);

rec.query();

if (rec.next()) {

rec.u_state = 'checkedout';

rec.u_checkout_time = current.u_checkout_time;

rec.update();

current.setAbortAction(true);

} 

Note: All RP form fields mapped to table fields.

Thanks

[vsharma]

Yes, even on my service portal without using redirection(which is not working actually) error message is coming and stays on the form as "submitted" which may confuse user that anyhow form is submitted so he will ignore it.

So that's why redirection is required.

Is the producer.redirect do not work on portal?

Thanks

[Alikutty A]

It does not stay submitted in my instance, I am able to submit it again in this case adding a different input. 

The service portal is auto-redirecting to same form, so forced redirection is not required here. There is some other issue with your Submitted button getting locked out

[vsharma]

Yes after your input I have tried in my personal instance too and noticed the same that error message is coming and submit button is not getting greyed out. So can update and submit again.

But interesting part is even when user is entering valid mobile number even then submit button is not turned to submitted.

So force redirection is must. Any idea why redirection is not working?

Thanks

[Harsh Vardhan]

once you hit the submit button , is your submit button showing like "submitting.." ?

can you share the screenshot?

[vsharma]

Yes, from submitting to submitted in my actual development instance. However, in my personal instance its as Submit only.

It should be submitted when valid mobile number is entered and abort (be at submit) with wrong mobile no.