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

[NamitD]

Is there any way we can change the list view from AES ? 

@nowGurukul

[ayush_glob]

Week-1 Challenge
App Engine Studio – Corporate Gifting

Employee table (form layout):

E-wallet Request by managers - Form Layout

Employee - List layout (default view)

Employee - List layout (Corporate view)

Ewallet Request by Manager - List layout (default view)

Groups:

[Aamir3]

After submitting the deployment request,. Its getting failed-closed. can anyone please help on this.

PFA

[Dr Atul G- LNG]

Hi @ayush_glob @NamitD @Chetna_dev  @Savitha 

Thank you much for sharing the feedback and learning. Get ready for Week 2.

[Dr Atul G- LNG]

Thank you much all for sharing the feedback and learning. Get ready for Week 2.

[NamitD]

Hi Everyone ,

How you guys achieved the 3 months after the E wallet balance added thing in E wallet balance validity column .

@Dr Atul G- LNG @nowGurukul 

[Hamad Baseer]

Hello Everyone,

I have done a few things differently than what was initially asked. 

1. Employee table is extended from Task - It is not recommended to extend from sys_user. I have omitted few fields which seemed to be repetitive. In the form, I kept few fields and used GlideAjax to populate remaining fields based on one "name" field. 

2. Used Before Business Rule to populate the voucher validity field.

That's all for this part of the challenge.

[Vignesh33]

ApplicationEmployee - Form LayoutEmployee-List LayoutE-Wallet-Form LayoutE-Wallet-List Layout

[Twinkle Athole]

Hi @nowGurukul Team, 

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

Week-1 Challenge: - 

1.App Engine Studio – Corporate Gifting 

2.Form Layout for Employee Table: 

3.List Layout for default view - Employee Table 

4.List Layout for default view - Corporate view 

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

6.List Layout for default view - E-Wallet Request by Managers Table.

7.Groups: 

8.Records: Employee Table 

9.Records: E-Wallet Request by Managers Table 

Regards,

Twinkle Athole.

[divyabhanugali]

Unable to extend the user table on app engine studio.

[divyabhanugali]

unable to extend the user table in app engine studio.

[Sameeksha Sahu]

Hi @nowGurukul,

I have completed challenge 1.

App Engine Studio: Corporate gifting 

Groups:

Employees : Corporate View:

Employees : Default View:

Employees : Default form layout:

 

E-Walley by Manager ( list view):

E-Wallet by Manager (form view):

 

Thanks & Regards,

Sameeksha Sahu

[Sujatha V M]

Hi @nowGurukul 

Thank you for the opportunity given by nowGurukul to work on AES.

Week - 1- Challenge Screenshots: 

APPLICATION NAME : CORPORATE GIFTING

TABLES

Employee & E-Wallet Request by Managers

Employee (Extend from User table)

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

Validations:

For scenario, disabled the read only of e-wallet balance as there is a validation mentioned in the challenge.

FORM DESIGN

Employee (Extend from User table)

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

GROUPS

LIST LAYOUT

Employee (Default View)

Employee (Corporate View)

E-Wallet Request by Managers (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.

Food Delivery Voucher Agents Group

Shopping/Sports-Wear Voucher Agents Group

E-Commerce Voucher Agents Group

E-Wallet HR Approver Group

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

Happy Learning!!!!

Regards,

Velvizhi Sujatha V.M.

LinkedIn Profile : https://www.linkedin.com/in/velvizhi-sujatha-67267baa/

[Rupanjani]

Hi @nowGurukul,

I have completed the week 1 challenge and screenshot are attached below. 

Week-1 Challenge:

App Engine Studio – Corporate Gifting 

Tables & Form Layout

Employee table – Form Layout and Fields:

 E-Wallet Request by Managers Form Layout and Fields:

Groups:

List Layout:

Employee Table:

Default View:

Corporate View:

E-Wallet Request by Managers Table: 

Default View:

 Thanks,

Rupanjani

https://www.linkedin.com/in/rupanjani-patnana-aa8879176/

[Atheher Fathima]

@divyabhanugali ,

You should extend the table in global scope. You will not be able to do so in AES.

[Community Alums]

Hey everyone, 

Quick ques: The number is getting incremented by +2 instead of +1 when the new record is created for (Employee number field). Any reasoning and how can we get rid of it?

[Mangesh5]

Hi @nowGurukul Team,

I have completed week1 challenge, please find attached screenshots.

Form Layout for Employee table:

List Layout of Employee table: Default View

List Layout of Employee table: Corporate View

Form layout of E-Wallet Request by Managers

Thanks,

Mangesh

[Hakeem2]

[pooja_m]

Hi @nowGurukul 

I have completed all the tasks from the Week-1 Challenge. Thanks for the great initiative.

1. Custom Application - Corporate Gifting

2. Tables("Employee" which extends 2from user table and "E-wallet Request by Manager" which extends from task table)

3. Fields

4. Groups:

5.. Form Layout:

• Employee

• E-Wallet Request by Managers

6. List Layout:

E-Wallet Request by Manager

Employee

7. Data Preparation

Employee - Corporate View:

Employee - Default View:

E-Wallet Request by Manager - Default View:

Happy Learning!

Thank you!

[azharsheikh]

Data Preparation: 

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

Can anyone explain above line? 
Do I need to add any `users` to the `groups` (which is been mentioned in the task) and Then fill out `manager field` (by any user) or (those user which are the part of a group which made earlier)

[Ranjith95]

Hello @nowGurukul 

If any one is not able to see the "Corporate gifting" Application menu in Main ServiceNow Platform/window

Please follow the below steps.

Note : Give appropriate roles to admin.

1)Type Application Menus in app navigator

Create New if "Corporate gifting" is not available and give appropriate roles for visibility and save the form.

2)After the creation of menu you can see Modules section below the form, create new and save one by one.

Save and submit.

3)After that go to the "Corporate Gifting" Application, Select appropriate application menu and user role as per below and save the form.

After performing all the above steps check on Servicenow Main window, you will be able to see Corporate Gifting menu and modules under the app.

Please mark it as helpful if it helps.

Happy Learning.

#ServiceNowCommunity  #Servicenow  #Servicenowadmin

Thanks.

[snowsiri7]

Hi @nowGurukul !!

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

Application(Corporate Gifting)

Form Layout

1.Employee 

2.E-Wallet by Manager

Groups

Employee Table

Default View:

Corporate View:

E-Wallet Request by Managers Table

[Alkakum1]

Hi @nowGurukul,

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

Name – Alka Kumari

Week 1 Challenge

App Engine Studio – Corporate Gifting

Employee - Form Layout

Employee - List Layout (Corporate view)

Employee - List Layout (Default view)

[TayyabMujeeb]

Week 1 Challenge Completed Finally!

Employee Table Form layout: 

Employee Table List layout (Default View): 

Employee Table List layout (Corporate View): 

E- Wallet Request Table Form Layout:

E- Wallet Request Table List Layout:

Groups:

[BobbyA]

Hi @nowGurukul @Dr Atul G- LNG 

 week 1 challenge screenshot attached

  Employee (Extend from User table)

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

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.

Thank you

[sola2]

Can someone please explain to me how do you the "3 months later from the last E-Wallet balance added" part on the E-Wallet Balance Validity field? Thank you 

[v1z-D]

@nowGurukul 

Thank you for creating these challenges and appreciate your effort . It really helps to test ones knowledge.
I joined very late into this so took time to post.

I have completed challenge 1. Please find below screenshots.

Week 1 Challenge :- App Engine Studio - Corporate Gifting

Application and Tables :

[v1z-D]

How to configure list views in AES?

[Grettel]

Thank you for the steps . I couldn't use Studio Engineer I had to use Studio App . Can someone please let me know if faced the same issues? 

[Carlos Camacho]

1) Employee Form

2) E-Wallet Request Form

3) Employee List (Default)

4) Employee List (Corporate)

5) Groups

Congratulations on this initiative! 🏆

[Carlos Camacho]

@v1z-D , @Grettel , 

You are not wrong. The masterminds behind this are sages. 
There are lots of hidden gems and one of them, is that you’ll realize that some things you can’t accomplish using just AES and that Studio IDE is a powerful alternative when such requirements arises.
This journey is going to be fun! 

[Carlos Camacho]

@sola2 , research about a component called Business Rule. 
When the E-Wallet Balance is added/updated in the table, you can configure this component to calculate a future date and store it within the field E-Wallet Balance Validity. 

[Carlos Camacho]

@azharsheikh , 

First you can create Users in the table Employee and set their Position Level as Manager. 
Then, for other users you create use those Managers to fulfil the field Manager as in the image above. 

[Dr Atul G- LNG]

Hi @Carlos Camacho 

Thanks for kind words and motivation. Its all about learning and sharing experiences together. 

[Jagadish Sanadi]

Hello  Divyabhanugali

Please make user table as extensible.

[zain nawaz abba]

Week 1 Task is Completed Successfully

[AnimeshP_96]

Hi @nowGurukul 
I have completed the above challenge.

Above are the default view.

This is corporate view

4 Groups created

Let me know if anything was missed or it's done.!!

[yadavkiran]

Week 1 Challenge Done: 
Employee Table List View

Employee Table Form View :

E-Wallet Request by Managers List View:

E-Wallet Request by Managers Form View:

Groups :