Resolved! VLookup in reports
Hi Community, If there is vlookup applied in excel, then how to create reports for this? Is there any functionality related to vlookups in servicenow? Thanks,Poorva Bhawsar
Forum Posts
Resolved! How is due_date determined on RITM?
Does anyone know how the due date is calculated on RITMs? I'm in my totally vanilla personal developer Helsinki instance. Go to the catalog, pick Adobe, and click order now. A RITM is created with a due date of tomorrow's date. Looking at the ...
Color scheduled report pdf column
Hi All, We have a requirement where we have to color code the planned start date column as red if the planned start date is passed form the current date and time. OOTB I see the conflict tab and Priority tab is showing red and green color highlighted...
Return date field should be have maximum 15days duration from date required field.
In Catalog form "Return Date" field on form to have a maximum limit of 15 business days (3 weeks) from the "Date Required" so that the form is used properly.
Email ...
Hi Team , What can be check here For some reason, I keep receiving the same SNOW emails although I keep approving them (through email). Is there something I am doing it incorrectly on approvals?
Catalog item variable
Hi ,Team, In request item table we have section like Request item variable I want to print that variable valuesAny one knows abt thing could pls help on this Advance thanks.
Why Create Catalog Task Action is showing Waiting event the catalog task is closed Complete in flow
Hello Everyone,I am currently working on a flow that generates catalog tasks once a request is approved. However, during testing, I am encountering an issue where all catalog tasks get closed complete, even though the flow indicates that it is still...
How to set Has Breached SLA to true based on the business elapsed percentage.
Hello Everyone,I have a requirement where I need to set the Has Breached to true for with conditions for Problem SLA as below:Conditions: SLA - Problem, Business elapsed Percentage - >95 then Has breached to True.I have written a before update BR on ...
Need to restrict Fiscal periods on the demand cost plans based on the selected date
Hi All, We have to restrict the fiscal period on cost plan table. We have a new field called fiscal period. We need to compare fiscal periods with the freeze date field. I am converting it from date to date/time code was not working.If the freeze d...
Can I have a catalogue item that opens other catalogue items?
Hello Community, I have a bunch of application request forms for 15+ applications used across the organization. Each application has its own catalogue item for people to submit. Is there a way I can make a new catalogue item and when certain things a...
help to convert a ui page from native to sow
hi , i have created a ui pop up on the native interface but i needed to be convert to work in SOW . here is the script : <?xml version="1.0" encoding="utf-8" ?><j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide"><g:evaluate var="jvar_taskId...
Script to send notification to different email addresses based on variable response
I have a RITM with a list collector variable with three options, we'll go with A, B, and C for simplicity.The ask is that a notification is sent that includes all stakeholders so they can reply all and keep a chain of questions/comments together. I b...
Approval process
I am looking to improve the overall process of approvals to ensure approvals are actioned in a timely manner. The aim is to send a reminder email at creation of an approval (which already takes place). Then send a reminder email on the 7,14 and 21 ...
Submit button is not visible in any catalog forms
Why is the submit button not visible for any catalog forms for all members of a group even though the admin role is provided in the group?
pagination in servicenow widget
i have create one custom widget to show the list of RITMS, now i want to add the pagination for that widget. please help on this
