It is a common scene to record and manage the address and opening date of stores in the table, such as supermarket chains, clothing stores and catering stores. Let's take a supermarket store as an example to see how to record and manage the store address simply and conveniently in SeaTable.

In recent years, we have witnessed the continuous development of Xiaomeng Tofu Factory and Yutian Imperial Garden. Xie Dajiao, as the spiritual idol of middle-aged and elderly men in ivory mountain, is not inferior. With the gold-lettered signboard of Bigfoot Supermarket and the financial support of Wang Dana, an old iron, Bigfoot has successfully expanded many stores, and with the help of Liu Da's head with rich management experience, the chain stores of Bigfoot Supermarket have become more and more popular, and the cause can be described as flourishing, and he shouted out the first stage, "Go out of ivory mountain!

the following three charts are the statistical tables of stores in Bigfoot Supermarket created in the SeaTable table. By visualizing the store addresses on the map, it can be seen that the stores are mainly concentrated in the Northeast, and the first-stage expansion goal has basically been achieved.

The geographical distribution of the stores is as follows:

The default view is as follows:

Multiple views can be switched. As shown below:

In the above table:

Let's take a look at it together:

For the geographical column, you can directly select the address of the province, city, district and county in this column, and then customize the input for the detailed address. This makes the input address more convenient and standardized.

Click to install the "Map" plug-in in the plug-in market, and it will be installed automatically in a few seconds. You can click to put it in the toolbar again. At this time, click the "Map" plug-in in the toolbar directly, and the location of the store can be displayed on the map.

in order to switch and view data from different angles conveniently, you can add multiple views, and then set different filtering, sorting, grouping and other conditions on each view as required.

For example:

Opening by year view (grouping opening time by year), as shown below:

View by province (grouping store addresses by province), As shown below:

Liaoning stores are selected according to the city view, and the store addresses are grouped according to the city, as shown below:

In the default view, create a statistical table, select the column chart form, select the opening date by year on the X axis, and select counting on the Y axis to complete the statistics.

click a column chart to view its corresponding statistical records.

Through the analysis of the case of supermarket store statistics table, we can see that:

Of course, this online collaborative table can do a lot, such as store customer management, sales record and management, employee information management, etc., which can greatly facilitate the management of stores.

learn more about SeaTable at:/