Welcome to GW Manager. 

In this video, I will show you how to create a custom schema in Google Workspace with GW Manager. 

If you want to create a new custom schema with a few custom fields you can use GW manager's create custom schema function in which you can create a new custom schema with at least one custom field or more .

 If you already have created a custom schema and you need to either edit that schema or to add more custom fields to this existing schema then you should use GW manager's update custom schema module.

Let me quickly tell you about the field mapping between GW Manager and Google Workspace custom schema.

whatever you want to put as the category name of that custom schema, you can put that in the schema display name. 

Your custom field name should be provided in the field display name in GW Manager.

Field type, whether it's a number or boolean or string or email, you can put in field type and that will become the info type in custom schema.

Visibility, it can either be admins and self or all domain users, it can be entered under a field read access type in GW manager.

And multi field value, by default, it is single line, but if you need to make it multiline, you can write TRUE in this column to make it multi line value.

‍

Let me show you how to use GW Manager to create a custom schema in Google Workspace.

 I'm in my Google sheet, and I'll go to Extensions.

Here, I should see a GW Manager.

If you need help with the installation, please install our GW Manager installation guide here.

For now, I will click on launch, to launch the GW manager in the sidebar. 

‍

Once it is launched, we will first need to  insert the sheet where we can provide information about which custom schema we want to create. And for that we have two options. Either we can go to manage utilities, select, insert all sheets, execute to insert all the sheets at once, so that you can deal with any of these modules. For now, I'll click on manage custom schema. I have created a custom schema selected. 

GW Manager recognizes that we don't have to create a custom schema sheet inserted yet. It is asking us to insert one.

so we will click on Execute. 

GW Manager has now inserted a Create custom schema sheet. 

Columns which have asterisks are required information.

I've copied some information, so I'll paste it here. 

Let's talk about these fields before we create a custom schema. The first column is schema id. Please do not use period or space in the name of this ID because Google APIs do not support  that. Then we have a schema display name. This is the name, which will be displayed to you in the admin console. 

Then we have the field id, which is not shown, again, do not use spaces or periods in this, because it is an id, you won't generally see it.

‍

Then we have the field name, which is required. Here, you can use the user-friendly name. Then we have a field type, and if you hover the header for that column, you will see the possible values and their use case. 

‍

For instance, here I am asking for a blood group, which will be a text value, so I need to write a string. If it would have been an email, I can just write an email. 

The next column is field access type, which means who can read the values of these custom attributes. 

If I hover on the column header, it says Admins and self, which means only the admin and the user himself or herself can see the value. 

If you make it all domain users, everyone in your Google Workspace domain can see the value of this custom attribute. 

Last, we have multi field value. Possible values here are true or false.

False is default If you leave this column or this row empty. If you write true, then this will make this custom attribute a multiline field. 

Now before we create a custom schema, let's go to our admin console and do a quick reload and we will see that we do not have any custom schema created yet. 

We will come back to GW Manager and as we have provided all the information, we will click on execute. 

At this time, GW Manager will create these two custom schemas, personal details and employment details. 

And under that it should add four fields under personal and two under employment details. 

 Within a few seconds it came back to us saying, custom schemas are successfully created. 

And now to check this, let's go to the admin console. We do not have anything yet, so let's do a quick reload. And now we have two custom schemas created. 

One is user personal details, second one is employment details. 

When I click on personal details, we see the custom field names as we proposed and also the values.

If you go back to GW manager, We told it to create a skillset field. It's a string, visible to all domain users and multi field value.we made it true to bypass the default false value

GW Manager created it as a multi value field. 

Now if we go to employment details, GW Manager created two fields here, employee ID and Employee Bio. 

Both are text fields, single value, but employee ID is only visible to user and admin, but employee bio is visible to the organization. 

If we go back to our GW manager sheet, this is what we told GW Manager to do.

We said, create both of them as string, but only allow admins and self to read employee id, but employee bio should be visible to all domain users. 

This is how you can quickly create custom schema and custom fields in Google Workspace with GW Manager.

You can do much more with GW Manager and we are constantly adding new features. 

To learn more, please visit our website gwmanager.com. 

Thank you for reading.