nowGurukul ServiceNow Hands-On Challenge 2024 #Week_1

[nowGurukul]

ServiceNow Community - “Discipline is choosing between what you want now, and what you want most.” 🌟 ✅

Challenge Introduction:- In order to strengthen the ServiceNow hands-on skills , each week a challenge will be posted and you need to implement the solution in your Personal Development Instance and share the screenshots of the completion in the post comments and your take home learning for this week Challenge.

Benefits:-

1. A weekly implementation challenge in order to do goal based learning.
2. An opportunity to connect and learn from thousand of others ServiceNow Enthusiasts who are part of nowGurukul community.
3. An opportunity to learn and implement exciting features & functionalities of ServiceNow platform every week.
4. Real time project based learning opportunity which can be used in your resumes in order to showcase how competent you are in implementing ServiceNow hands-on solutions.
5. Opportunity to innovate and come up with your creative solutions for the challenges in order to grow your ServiceNow competency.

and much more....

Challenge Guidelines:- 

1. Kindly use your personal development instance for the challenge implementation.
2. In case of any assistance/discussion required , please use nowGurukul Official What's App Channel for the quick resolution.
3. Wherever needed assume the values in order to complete the challenge as you are independent enough to bring in your creativity in your hands on implementations.

*****************************************************************************************************************

Week-1 Challenge:-

For this week, as part of the end to end project implementation, we will start by create a new Custom Application using App Engine Studio, Creating tables and their fields, creating Groups, Configuring Form Layout and List Layout, and creating some dump data for these tables which will help during the whole project implementation.

Application Name: Corporate Gifting [Note: You can create a Global or Scope Application. Totally your choice].

Description: Corporate Gifting application will be used by the departments of an organisation where managers can appreciate their mentees in the form of E-Voucher with a predefined amount which will be added to the Employee e-wallet. Each employee can order the voucher based on his wallet balance and number of vouchers.

Update Set:

NowGurukul_Project_CG_V1 (If in Global Scope)

Tables:

1.   Employee (Extend from User table) – Employees who will be having E-wallet balance and can raise Voucher requests for himself. Also, Employees at Manager or above level can raise E-Wallet requests for him mentees to add an amount to their wallet.

Field Name	Field Type	Comment
Employee Number	Auto-generated Number.	Prefix - EMP
E-Wallet Balance	Integer	Read Only
Project/Account	Choice	ABZ Consultancy PTL India Ltd. Zone IT Services YUC Motors Qwerty Hospitals
Position Level	Choice	Associate, Senior Associate, Technical Lead, Manager, Senior Manager, Director, Delivery Head, HR
E-Wallet Balance Validity	Date	3 months later from the last E-Wallet balance added.
Awards/Appreciations	String	Should contain the list of Awards/Appreciation received with E-Wallet balance.
E-Wallet Budget	Integer	Ready Only

2. E-Wallet Request by Managers (Extend from Task table)

Field Name	Field Type	Comment
E-Wallet Req Number	Auto-generated Number.	Prefix - EWR
Requested By (Manager)	Reference User table
Requested For (Employee)	Reference User table
Request Status	Choice	Submitted, Approval Requested, Approved, Rejected, Completed, Cancelled.

Groups:

1.       E-Wallet HR Approver – People who must approve the E-Wallet request by the Manager before it is added to the employee E-Wallet.
2.       E-Commerce Voucher Agents – HR Agents who would be assigned to the E-Commerce vouchers request submitted by the Managers to help the Employee provide the vouchers offline.
3.       Shopping/Sports-Wear Voucher Agents - HR Agents who would be assigned to the Shopping vouchers request submitted by the Managers to help the Employee provide the vouchers offline.
4.       Food Delivery Voucher Agents - HR Agents who would be assigned to the Food vouchers request submitted by the Managers to help the Employee provide the vouchers offline.

Form Layout:

1.       Employee Table

Employee

Employee Number	Email ID
User ID	Mobile Number
First Name	Career Level
Last Name	Project/Account
Name	Active
Position Level	Photo
Manager

Corporate Appreciations (Form Section)

E-Wallet Balance	E-Wallet Budget
E-Wallet Balance Validity
Awards/Appreciations

2. E-Wallet Request by Managers Table

E-Wallet Request by Managers

E-Wallet Req Number	Request Status
Requested By (Manager)	Opened
Requested For (Employee)	Assignment Group
Watchlist	Assigned To

Notes (Form Section)

Additional Comments (Customer Visible) / Work Notes

Activities

List Layout:

1.       Employee Table

Default View:

Employee Number

User ID

Name

Email

Position Level

Manager

Active

Corporate View:

Employee Number

User ID

Name

Email

Manager

E-Wallet Balance

E-Wallet Balance Validity

Awards/ Appreciations

      2.   E-Wallet Request by Managers Table

Default View:

E-Wallet Req Number

Requested By (Manager)

Requested For (Employee)

Request Status

Assignment Group

Assigned To

Created

Data Preparation:

1.  Create 12-15 records or more for the Employee table with different Position Levels.
2.  Create 8-10 records or more for the Employee table with HR Position Level. Include them in 4 groups mentioned.
3.  For Employees, map Managers or above level employees to their manager field.

*****************************************************************************************************************

Join nowGurukul Communication Channels to get latest updates:-

LinkedIn:- https://www.linkedin.com/company/nowgurukul

What's App:- https://chat.whatsapp.com/DlXPEZCFFTn0ImvGA5UErP

YouTube:- https://www.youtube.com/channel/UClnJHTVq8kNkS1KCzMptYGg

Please Bookmark this Article 🔖 for your future reference and do Mark it as Helpful 👍.

Regards,

nowGurukul Team

[Vignesh_18]

Can anybody know how to extend from User table as part of step 1? I tried making 'extensible' field "True" in User table configuration. However, It is not updating. Please let me know if anyone knows.

[TayyabMujeeb]

@Vignesh_18  Select the global scope first, and then mark the extensible checkbox as true.

[Dr Atul G- LNG]

Hi @Vignesh_18 

Did you get the answer to still waiting?

You need to make the user table as extensible.

[Sivasangeethp]

Hi @nowGurukul,

I have completed the challenge 1 and I have added my ss below. Please check.

Name – Siva Sangeeth P

LinkedIn URL - https://www.linkedin.com/in/siva-sangeeth-p?utm_source=share&utm_campaign=share_via&utm_content=prof...

Week-1 Challenge: -

App Engine Studio – Corporate Gifting

Tables & Form Layout

Employee table – Preview with all the fields and the form Layout

E-Wallet Request by Managers - Preview with all the fields and the form Layout

Groups:

List Layout:

Employee Table:

Default View:

Corporate View:

E-Wallet Request by Managers Table

Default View:

Thanks,

Siva

[Abhishek_Thakur]

Hi @nowGurukul Team,

I have completed the week 1 challenge, below screenshot attached.

Week-1 Challenge: -

App Engine Studio – Corporate Gifting

Form Layout for Employee Table:

List Layout for default view -Employee Table

List Layout for corporate view -Employee Table

Form Layout for default view - E-Wallet Request by Managers Table

List Layout for default view -

E-Wallet Request by Managers Table

Groups:

Records: Employee Table

Records: E-Wallet Request by Managers Table

Thanks!

Abhishek Thakur

[Logesh]

Hi @nowGurukul,

I have completed challenge 1. Please find below screenshots.

Week 1 Challenge :- App Engine Studio - Corporate Gifting

Application and Tables :

Employee table (Form layout) :

Employee table (List layout and default view) :

Employee table (List layout & Corporate view) :

E-Wallet request by managers table (Form layout) :

E-Wallet request by managers table (List layout) :

Groups :

Thanks,

Logesh V

[Bphan]

Hi @nowGurukul 

I have completed the week 1 challenge, below screenshot attached.

App Engine Studio – Corporate Gifting

Tables & Form Layout

Group

List Layout:

Thanks,

Bach Phan

[Sathish Kumar S]

Hi @nowGurukul 

Completed Week_1 challenge.

AES Application:

Employee Form:

EWR Form:

Employee record+list_view:

EWR list_view:

HR employees included in the groups:

@Gagan Jolly @Dr Atul G- LNG 

[Varaprasad kan1]

Hi @nowGurukul ,

Please find the below screenshots for the Week1 challenge.
Application:

Employee Form:

Employee List view(Default):

Corporate view:

E-Wallet Request By Managers Form:

EWR List view:

HR Groups:

[Sathish Kumar S]

Quick tip:

For the EMP prefix, if you face issues, use EMPY/EMPL, etc...Follow the below method to get the auto number pad.

For E-Wallet Request by Managers we have "Assigned to" field that is referenced from task table and by default it has a reference role=itil. DO Not make changes, instead update the reference on your table level as per below.

OOB Assigned to field:

Update reference qualifier on EWR table:

Please mark "Helpful" if you find this post useful!!

Regards,

SMS

[Anubhav24]

Career Level mentioned in form layout of employee table but not mentioned in the list of fields to be added , I assume that this field is not available OOB.

[Community Alums]

Hello @nowGurukul,

Thanks!

[Dr Atul G- LNG]

Thanks to all who submitted the screen shots. and those who are still working dont worry, it is not a RACE, it is a Journey. You still have 4 days to complete this. 

[Mohan raj]

Hi @nowGurukul,

I have successfully completed the Week 1 challenge.

Corporate Gifting

Tables & Form Layout

Employee table – Preview with all the fields and the form Layout

E-Wallet Request by Managers - Preview with all the fields and the form Layout

Groups:

List Layout:

Employee Table:

Default View:

Corporate View:

E-Wallet Request by Managers Table

Default View:

Thanks,

T Mohan.

[SunilKumar_P]

Hello @nowGurukul, Below are the screenshots of Week-1 Challenge

App Engine Studio:

Groups:

Tables Form Layout:

Employee Form:

E-Wallet Request Form:

Tables List Layout:

Employee List (Default View):

Employee List (Corporate View):

E-Wallet Request List View:

Thanks,

Sunil

[dgarad]

Hi @nowGurukul 

I have completed the Week 1 challenge.

Application:  Corporate Gifting

Employee Form:

E-Wallet Request by Managers

Groups:

List Layout:

1.  Employee Table

Default View:

Corporate View:

 E-Wallet Request by Managers Table

Default View:

Data Preparation:

1. Create 12-15 records or more for the Employee table with different Position Levels.

2. Create 8-10 records or more for the Employee table with HR Position Level. Include them in 4 groups mentioned.

3. For Employees, map Managers or above-level employees to their manager field.

Regards,

Dharmaraj

[Community Alums]

Week 1 - Completed

[arijtis]

Hi @nowGurukul team,

I have completed the week 1 challenge, pls find the below screenshots attached-

Week 1 Challenge :- App Engine Studio - Corporate Gifting

1. Application and Tables-

Employee table layout(Default view)-

Used Tooltip to add the comments in the field as mentioned in the requirement

Corporate View-

E-Wallet Request by Manager-

 2. List layout- Employee(default view)-

Corporate view-

E-Wallet Request by Manager(default view)-

1. Data Preparation-

     a. Records with different position levels and mapped Managers or above level employees to their manager field.

b. Employees with HR Position Level are included in 4 groups mentioned.

Thanks,

Arijit Saha

[Himanshu Raj]

Hi @nowGurukul,

I have successfully completed the Week 1 challenge. Please find screenshot below.

• Application (Corporate Gifting)

• Tables (List and Form views)
• Employee (form view)
  

• Employee (list default view)
  

• Employee (list corporate view)
  

• E-Wallet Request by Managers (form view)
  

• E-Wallet Request by Managers (list default view)

• Groups

Please let me know if any suggestions/questions regarding same.

Thanks & Regards,

Himanshu Raj

[ROHIT TOMAR]

Hi @nowGurukul !!

I have completed the Week 1 challenge. Please find the screenshot below.

• Application (Corporate Gifting)

Default View:

Corporate View:

FORM LAYOUT DEFAULT:

E WALLET BY MANAGER (Default):

GROUPS: 

[eqbalkhan]

Hii @nowGurukul team,

I have successfully completed the first weekly challenge. Here is my attached screenshot of work done.

App Engine Studio - Corporate GiftingForm Layout for Employee Table:-Default view :- Employee TableCorporate View :- Employee TableForm Layout :- E-Wallet Request by Manager TableList Layout for Default View :- E-Wallet Request by Managers Table

[Rai Shivam Ajay]

Hi @nowGurukul Team,

I have successfully completed the week 1 challenge . As below I am attaching the screenshot.

Thank you
Shivam Rai

[jindal]

Hi @nowGurukul, I have completed the week 1 challenge.

[Anubhav24]

Hi @Rai Shivam Ajay ,

How did you get the option of submitting your app from AES , I am unable to get the option of submitting my app from AES. Please guide me accordingly

[jindal]

Hi @nowGurukul Team, I have completed the week 1 challenge. Please find the below screenshot. 

Week-1 Challenge: -App Engine Studio – Corporate Gifting

Application and Tables:

Groups:

Form Layout

Employee Table

E-Wallet Request by Managers Table

List Layout:

    Employee Table

Default View:

Corporate View:

  E-Wallet Request by Managers Table

Default View:

Data Preparation:

Create 12-15 records or more for the Employee table with different Position Levels.

Create 8-10 records or more for the Employee table with HR Position Level. Include them in the 4 groups mentioned.

For Employees, map Managers or above-level employees to their manager field.

[Mayuri Khairnar]

First weeks Challenge complete
thanks,

Mayuri K

[Litu05]

Hi @nowGurukul,

Name – Pritikant Dhal

LinkedIn URL-https://www.linkedin.com/in/pritikant-dhal-145977aa/

Week-1 ChallangeTables & Form LayoutEmployees Record Field & form LayoutList Default View of Employee TableList Corporate View Of Employee

[sairahul]

Hi @nowGurukul Team,

I have completed the week1 challenge.

PFA

[Litu05]

Hi@nowGurukul Team,

I Have completed this Week 1 Challenge

[jagadevi2010]

Hello @nowGurukul Team, I have completed the week 1 challenge. Please find the below screenshots

Application: 

Employee table record form view :

List View default view:

Corporate View:

E-Wallet Requests table records form view:

List View :

Assignment groups :

I am having trouble publishing or submitting this application, see the error screenshot below

[Dr Atul G- LNG]

Nice to see lots of responses.

Now what's next

- Lets try to add 1-2 pain point which you faced during  the development of this exercise. 

[Sivasangeethp]

@jagadevi2010  - You need to setup pipeline for your instance.

Please follow the steps:

1. App Engine > Pipeline and Deployment > Environment 

2. Create new Environment 

• Instance Type as "Development"
• Instance URL as "Use your Instance URL.",
• Instance Credential - create a credentials in connection and credential module (table name - sys_alias).

In credentials form section use your instance "Username & password" like in below ss.

while creating credential choose type as Basic Auth Credentials

3. After setting the instance credential click validate button and instance id will auto populate.

4. Save the record.

5.  App Engine > Pipeline and Deployment > Pipeline 

6. Create new Pipeline 

7. set the fields like in below ss

8. save the pipeline record.

9. Now goto App Engine studio and try to submit the application. 

If its work fine. please mark it as helpful

[Aamir3]

Hi @nowGurukul Team,

I have completed the week 1 challenge; the screenshot below is attached.

Week-1 Challenge:

App Engine Studio: Corporate Gifting

Application and Tables:

Employee table record form view :

E-Wallet request by manager form view

Employee table list Default view

Employee table list Corporate view

E-Wallet Request by Managers list Default view

Groups 

Employee table records

E-Wallet Request by Managers records

[H562]

Hi @nowGurukul Team,

I have completed the week 1 challenge, below screenshot attached.

Week-1 Challenge: -

App Engine Studio – Corporate Gifting

Form Layout for Employee Table:

List Layout for default view -Employee Table

List Layout for Corporate view -Employee Table

Form Layout for default view - E-Wallet Request by Managers Table

List Layout for default view - 

E-Wallet Request by Managers Table

Groups:

Records: Employee Table

Records: E-Wallet Request by Managers Table

Thanks,

Harish Akurati

[Ravi Prasad589]

Week-1 Challenge

Hi @nowGurukul ,

I have completed the Week -1 Challenge and below are the attached screenshots - 

1. Corporate Gifting Application: 

2. Table 1 - Employee(Extend from User table) :

Form Layout & Choice fields : 

List Layout:

• Default View:

• Corporate View:

3. Table 2 - E-Wallet Request by Managers (Extend from Task table) :

Form Layout and fields: 

List Layout:

Groups: 

Regards,

Ravi Prasad

LinkedIn

[sonu9]

Hi @nowGurukul,

Completed week1 challenge-

1. Group -

2. Employee list layout -

(Default View)-

 (corporate view)-

Form Layout of Employee -

3- E-Wallet Request by Managers -

List layout - 

Form layout -

Thanks,

[Shaik Dimple]

Hi @nowGurukul Team,

I have completed the week 1 challenge, below screenshot attached.

 App Engine Studio: Corporate Gifting

FORM LAYOUT - EMPLOYEE TABLE

LIST LAYOUT: Default view(EMPLOYEE TABLE)

LIST LAYOUT: Corporate view(EMPLOYEE TABLE)

FORM LAYOUT: E-Wallet Request by Managers Table

LIST LAYOUT: Default view(E-Wallet Request by Managers Table

GROUPS:

Thanks,

Dimple Shaik

[abhilash5]

I have completed the task

[Sivasangeethp]

Link to source Control - Pull to git hub from ServiceNow

To get Access token from Github

1. Login to Github

2. Click the profile icon on right side

3. Goto Settings

4. Click the Developer setting like 

5. Personal Access Token > Token (Classic)

6. Click the Token (classic) and then right side you could see "Generate new token > choose Generate new token(classic)" and you need to fill mandatory fields and choose all check box "read and write access". once u submit the token u will get the token . 

For creating credential in Servicenow

1. Goto Credentials in navigator and open it.

2. Click New and choose basic auth 

3. Set the User name  ( same as git hub) and for Password ( paste the access token from above 6 steps) and submit.

4. Now open App engine studio and open your Application (Corporate Gifting).

5. Click the Link to Source Control

6. fill the URL (which is your git repository) and credential give access token which you have created on 3rd step and click "link to Sorce control " button.

7. After successfully linked. Goto GitHub and there you will see the "Compare and pull request" button with your "instance name (ex:sn_instances/dev71462)". 

8. click it and afterwards, you will find " create a pull request" button. Click it. And changes will be moved to github.

Mark it helpful. if it's working for you.

[Community Alums]

@nowGurukul 

I have successfully completed the Week 1 challenge !!.

Corporate Gifting . (Screenshot as below)

 App Engine Studio: Corporate Gifting

FORM LAYOUT - EMPLOYEE TABLE

LIST LAYOUT: Default view (EMPLOYEE TABLE)

LIST LAYOUT: Corporate view(EMPLOYEE TABLE)

FORM LAYOUT: E-Wallet Request by Managers Table

LIST LAYOUT: Default view (E-Wallet Request by Managers Table)

GROUPS:

Records: Employee Table (Read Data Record! 😂)

Records: E-Wallet Request by Managers Table

Regards,

Shiv Prasad Tiwari

[Himani_14]

Hi @nowGurukul Team,

Thanks for introducing this weekly challenge. It will help us to learn and grow together. 

Please find screenshots of Week 1 challenge :

App Engine Studio 

Tables 

Groups and Members

Form Layout

1. Employee Table

2. E-Wallet Request by Managers Table

List Layouts

Default View

Corporate View

2. E-Wallet Request by Managers Table

Thanks!

[Atheher Fathima]

@nowGurukul 

Week 1 Challenge Completed . attaching the document with the screenshots

1. Mark the User table as Extensible

Before starting creation of the application, ensure that you mark the User table as extensible . Go to System Definition - > Tables - > search for user table , under controls tab, check the  Extensible option and update.

1. Create the new custom application Corporate Gifting

1. Creation and configuration of table 1 Employee
2. Once the form layout is updated as mentioned, remove the remaining Related list
3. Remove the “Set Password” button

List View : Default View

Corporate view

1. Creation and configuration of table 2 : E-Wallet Request  by Managers

List view

1. Creating the groups

1. Creating records in Employee table with different position levels with all information filled in

1. Adding the HR users into the groups

[Chetna_dev]

Hii @nowGurukul thanks for this challenge. It was my first time with AES and I absolutely enjoyed working with that and OfCourse learnt new stuff. Below are the screenshots.

Week 1 Challenge:- App Engine Studio - Corporate Gifting

Application and Tables:

Employee table (Form layout) :

Employee table (List layout and default view) 

Employee table (List layout & Corporate view) 

E-Wallet request by managers table (Form layout) :

E-Wallet request by managers table (List layout) 

Groups :

My linkedIn profile link: Chetna Sharma | LinkedIn

best

Chetna

[Venkata Sai Ku1]

Hello @nowGurukul ,

First, I would like to thank @Gagan Jolly and the team for bringing up this kind of practical activity every week 🙂

Corporate Gifting Application:

Employee (Form View):

Employee (List - Default View):

Employee (List - Corporate View):

E-wallet Request by Managers(Form View):

E-wallet Request by Managers (List View):

Groups Created:

Included Members in Each Group:

h

LinkedIn Profile: linkedin.com/in/venkata-sai-kumar-juturi-550190203 
I would appreciate any new connections for more learning and networking!!

Thanks again @Gagan Jolly and @Dr Atul G- LNG 

Best Regards,
Sai

[Rampriya-S]

Kudos to the 'Now Gurukul' team for fostering community through these challenges! Their initiative not only brings people together but also motivates them to embrace new challenges. Massive appreciation for the hardworking team behind it all! 👏

Corporate Gifting Application:

YouTube: https://youtu.be/kXs7p8TAMU4

LinkedIn: https://www.linkedin.com/feed/update/urn:li:activity:7148883329814036481/

Thank you!

Rampriya

[J_31]

@nowGurukul

@Gagan Jolly and @LearnNGrow-Atul @AnubhavRitolia 

Week 1 Challenge: App Engine Studio - Corporate Gifting

Application and Tables:

Application in Navigation

Employee table (Form layout) :

Employee table (List layout and Corporate view) 

Employee table (List layout & Default view) 

E-Wallet request by managers table (Form layout) :

E-Wallet request by managers table (List layout) 

Groups :

Populate E-Validity Balance date three months from today's date.

Regards

Jayanthi 

www.linkedin.com/in/jayanthi-jeyakumar-02a5a3a7

[Sai Pavan]

Hello @nowGurukul @Gagan Jolly and @LearnNGrow-Atul @AnubhavRitolia 

This is Sai Pavan. [https://www.linkedin.com/in/sai-pavan-reddy-9b339317a/]

I have Completed Week 1 Challenge Successfully.

Few points to mention,

1. I have created a custom scope using app engine studio. I have Created tables and views in the app engine studio. The experience was nice and simple.

2. Career Level field which is mentioned in form layout of employee table but not mentioned in the list of fields to be added. So I created a string field for the same.

3. No data was created in E-Wallet Request by Managers Table as it is not mentioned.

Here are the screenshots of the Tables, Forms and Lists.

Regards,

Sai Pavan

[mohanambalnanja]

Hi ,

I have completed the Week1 Challenge. Below are the screenshots.

Corporate Gifting - App Engine

Employee Table - Form View

Employee Table List View - Default

Employee Table List View - Corporate

E-Wallet Request by Managers - Form View

E-Wallet Request by Managers - Default View

Groups:

[Savitha]

Week-1 Challenge
App Engine Studio – Corporate Gifting

Employee - Form Layout

Employee - List Layout (Corporate view)

Employee - List Layout (Default view)

E-wallet Request by managers - Form Layout

E-wallet request by managers - List Layout

Groups

Employees with HR Position level are added to all 4 groups

Thanks & Regards,

Savitha

[Chetna_dev]

Thanks @Sivasangeethp  for the detailed explanation of setting up pipeline for instance. It helped me to submit my app.