Hello All,
I have a custom UI page which is populated as UI Page variable in a catalog item as shown below
I need help with the below 2 points
1.When "OK" button is selected it has to check the email id from the "sys_user" table.
If email id is avaliable it has to redirect to another URL for example "https:dev88888.service-now.com/sp"
Variable name of UI page with email input is "email_id_uipage".
2. If not found ; it has to close and show other variables in the variable set.
Also, it has to take the email id entered in UI Page and set it to another variable from the variable set
Example. If "test@123.com" is entered from UI page variable and if email id does not exist in User table (after OK button is submitted) then that value should be passed to another variable "Email" as shown below
Need help to achieve the above 2 thanks.
UI Page
<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">
<div>
<form>
<label for="uemailid">Email</label>
<br><input type="text" id="uemailid" name="uemailid"></input></br>
</form>
<script>
</script>
<button onclick="addEmail()">Ok</button>
<button onclick="onCancel()">Cancel</button>
</div>
</j:jelly>
Querying server side with email (I have reference code) but need help on tweaking to satisfy the requirement
var gruser_list = new GlideRecord('sys_user');
gruser_list.addQuery('email',email_id_uipage);
gruser_list.query();
var results = [];
if(gruser_list.next())
{
return gruser_list.email;
}TIA
@Allen Andreas @Ankur Bawiskar @Community Alums @SatyakiBose @priyasunku
