Seeking advice on how to start a simple ServiceNow project that would work like a data lookup

[callmecourtney]

Hello. I apologize in advance. I am very new to ServiceNow and I would like to create a project. However, I am struggling with where to begin. 

Right now, my company uses a spreadsheet to keep track of all the repairmen that are assigned to our stores. There are over 732 locations and it is very big and cumbersome. 

I would like to develop an application that would allow a user to input a market in one field then input a location in another. 

I want to be able to show the repairmen assigned to that store in a read-only field.

So ideally, I want to use two reference fields and a read-only field on an application.

-

My problem is that I am lost on where I should start. I created tables for the repairmen, each market, and all of the locations. They are all separate tables and I am struggling on how to use more than one table.

I would appreciate any assistance that anyone could provide to help me figure out where I should start.

Thank you!

[Dr Atul G- LNG]

Hi @callmecourtney 

Right now, my company uses a spreadsheet to keep track of all the repairmen that are assigned to our stores. There are over 732 locations and it is very big and cumbersome. 

Atul: 1st you need to get the user and store information in User table and for store create a new table and bring this data in SN ( via manual or via  transform map) This is your foundation data.

I would like to develop an application that would allow a user to input a market in one field then input a location in another. 

Atul: You can create a catalog item and create 2 variables and map those variable to these fields. 

I want to be able to show the repairmen assigned to that store in a read-only field.

Atul: You can use the UI policy to make the field read only or ACL to show read only to Repairmen.

So ideally, I want to use two reference fields and a read-only field on an application.

Atul: Yes

-

My problem is that I am lost on where I should start. I created tables for the repairmen, each market, and all of the locations. They are all separate tables and I am struggling on how to use more than one table.

Atul: Create catalog item to show these variable.