User Activity

I have a custom table that inserts some user fields each time a request is submitted.  How can I do a check on the table to see if the Employee ID already exists, and if it does, display a message to the requester and do not allow submission?
All other fields are returning as expected, instead of 'manager'.  How can I modify this to not return a sys_id? function onChange(control, oldValue, newValue, isLoading){ var requester = ''; if(g_form.getValue('ConfirmInfoReqOtherChoice') == 'No')...
I would like to auto-populate a 'Location' field based on the person selected in the 'New Hire' field.  Trying to do this using Default Value, but not working: javascript:gs.getUser(current.variables.new_hire_name).getRecord().getValue('u_location');...
I have a script that has worked in the past for filtering a list collector based on the lookup select box selection, but not sure how to modify the script to filter a 'lookup select box' based on another lookup select box: function onChange(control, ...
I have an issue where the same user has to approve twice, because the request is for 2 different roles (even though the Approver is the same person).   Is there a script I can use to check if user has already approved?.   I would like to do this in t...