Resolved! Change date format to YYYY-MM-DD 00:00:00Z format
Hi, User is entering the date from record producer in dd-mm-yyyy format. In backend I want the fields to be in the YYYY-MM-DD 00:00:00Z format. How can I achieve this ?
Forum Posts
Auto populate fields using business rule
Hello, I am having trouble populating some fields from one table to another through a business rule. I want to take the flieds from this table form and view. And auto populate on Site, here. This is my business rule. Table is set to cmn_loca...
add fields from reference variable to report
Hi, I have a variable that is reference to the user table. i would like to created report on the sc_req_item table. i'm able to pull the variable to the report - but i would like to also add a value from one of the fields of the reference variable. F...
How to configure body in an email from toggle bar on any form?
Hi All, We are trying to add a footer on the email while sending a mail through toggle bar option on top of the form. If there is any way we can configure the same, please guide. Thanks.
Auto-closure of all child incidents and it's tasks if parent incident is set to resolved.
For now, the script has been written in way where if any incident is set to resolved where there is open tasks, or if the child incident has open tasks, info message will be shown so that first close the open tasks, and then only you can resolve.But ...
3 columns in a table form
Hi... I checked in table form design and can see that we have option for 2 columns max in a row. But I need to create 3 columns in a row. Can anyone suggest if it is possible then how to do so... Thanks for your help.
how to add date picker on report
Hi All, I want to show a report like how many cases are opened on a specific date and I am able to get the report . But for end-user I like to provide a date picker on the report itself so that the user can use the date picker and select the date and...
Resolved! Standalone list field on a portal page
I'm super stuck on this and cannot figure out a way to tackle what I want to achieve in the portal so I'm hoping someone can point me in the right direction. I am looking to enhance the ticket sharing functionality we have in place. In the current se...
Database View - Where Clause
Does anyone know the script to filter on records created 90 days or 3 months ago within the Where Clause of a Table within a Database View? Below is the javascript command I have applied but this does not work. Note 'sa_timestamp' is the field that d...
Resolved! How to call email template in Flow Designer Send Email action?
Hi, I want to call email template in Send email action in flow designer to set the body and subject. @Ankur Bawiskar Any idea here? Thanks in advance, Bala
Resolved! How to get the label name of a specific language
I am using getDisplayValue() to get the label name of a field.However, it is retrieved in English.How can I get it in Japanese?
Resolved! [Workflow] Requested item and caller not showing in catalog task
Hi, I am creating a demo workflow for service catalog item which creates catalog tasks after approving the request: When I ran validator I received an ValidateTableChange with detail as below: I checked everything and assigned those tasks to the ri...
Configuration item field is not showing values in it on incidentt form?
Hi, When i try to create a new incident, Configuration Item field is showing all the records. But configuration item field is not showing the records with existing incident. I got to know that its a OOB behavior. can anyone suggest on this issue ...
Resolved! Help with 'Summary of Requested Item' Script in RITM workflow
Background: We are using the script below to add a summary of the requested item in our catalog items to the work notes of the the sc_task. This was previously only used in catalog items with 1:1 relationships for Request -> Requested Item -> Service...
how to update multiple records in target table from one record in source table in a transform map?
Hi All,i have multiple records in a target table with the same user ID. As per the requirement i want to update all the records in target table using one source record. i am using an excel with data for 5 fields. rest of the column data will remain s...
