■ Introduction to Useful Recommended Functions
Here are some useful and recommended functions.
1. Process function that allows you to create workflows such as approval requests
1. Automatic numbering function that can handle a variety of formats
1. Lookup function that can be used like Excel's VLOOKUP function
1. Dynamically change the recipient with the email notification function
1. Customize the navigation menu
1. Multiple selection of class columns
1. Sorting and filtering by specifying a view for the options
1. Customize the screen color theme
<h2>■ Process function that allows you to create workflows such as approval requests</h2>
The approval workflow function used for approval requests is realized using the process function.
You can set various approval routes and conditions with just a few mouse operations.
<img src="/binaries/e2205e8696914f6b9e065592b51932dd" alt="image" class="img-fluid">
<a href="https://pleasanter.org/manual/faq-process-workflow">FAQ▶ Using the process function to create workflows (approval processes) such as approval requests</a>
<br><br><br>
<h2>■ Automatic numbering function that can handle a variety of formats</h2>
The automatic numbering function can be used for columns that can handle strings (title, content, class, description). It is possible to specify various formats for numbering.
|Registration Order|Sequential Number|Description|
|:-:|:-|:-|
|1|202203Tokyo Branch-001|Group by the string 202203Tokyo Branch and count from 1|
|2|202203Tokyo Branch-002|Count up as it is the same string|
|3|202203Yokohama Branch-001|Count from 1 as it has changed to Yokohama Branch|
|4|202203Tokyo Branch-003|Count from 3 as it has returned to Tokyo Branch|
|5|202204Tokyo Branch-001|Count from 1 as the month has changed|
[User Manual ▶ Automatic numbering](https://pleasanter.org/manual/auto-numbering)
<br><br><br>
<h2>■ The long-awaited lookup function that can be used like Excel's VLOOKUP function</h2>
When you select a "[Linked](/en/manual/table-record-import-and-link) [Column](/en/manual/table-management-column)" , you can transcribe the "[Column](/en/manual/table-management-column)" of the linked "[Table](/en/manual/table)".<br>
For example, when linking a sales table to a customer table, you can transfer the address and phone number columns from the customer table to the sales table.<br>
Until now, this was only possible using the script function, but the lookup function can achieve it with a very simple description method.
![image](https://pleasanter.org/binaries/1d54e42c20f4482e8a7fa20c271925de)
Blog article▶ <a href="https://pleasanter.org/blogs/function-guide-lookup">Introduce the new function that can be used like Excel</a>: [Lookup](/en/manual/table-management-lookup)
User manual▶ <a href="https://pleasanter.org/manual/table-management-lookup">Manage Table: Editor: Column Advanced Settings: Option List: Lookup</a><br>
<br><br><br>
<h2 class="blog-h2">■ Dynamically change the recipient with the email notification function</h2><br>
In addition to directly specifying the address, email notifications can now be sent to the email address entered or selected in the specified column. The notification function can now be used in many tasks, such as process management.
![image](https://pleasanter.org/binaries/031a4bfde89b44c7b067b68706b82ed6)
User Manual ▶ <a href="https://pleasanter.org/manual/667214">Manage Table: Notification</a><br>
<br><br><br>
![image](https://pleasanter.org/binaries/65e1f0e0a4974374a34970f7e53b616f)
<h2>■ Customize the Navigation Menu</h2>
You can now customize the navigation menu on the left side of the screen.<br>
You can delete menus that you don't use often, and you can also add new menu column.
![image](https://pleasanter.org/binaries/f89363e9c1c9457687e53b56915eea79)
User Manual▶ <a href="https://pleasanter.org/manual/navigation-menu-json">Set Parameter: NavigationMenu.json</a><br>
<br><br><br>
![image](https://pleasanter.org/binaries/eb268092549a4021afdc2cf4b5f365f1)
<h2 class="blog-h2">■ Multiple selection of class column</h2><br>
You can now select multiple options in class column. With this new function, you can efficiently implement requirements that previously required placing multiple classes or checks.
![image](https://pleasanter.org/binaries/9c22e689fbb14b458060f4c919ff9990)
User Manual▶ <a href="https://pleasanter.org/manual/2591568">Manage Table: Editor: Multiple Selection of Class Column</a><br>
<br><br><br>
<h2>■ Sorting and filtering by specifying a view for the options</h2>
It is now possible to customize options by writing them in JSON format, such as sorting and filtering options displayed in class column.
<img src="/img/blogs/202106/20210630_filtersorter.png" width="80%"><br>
User Manual▶ <a href="https://pleasanter.org/manual/table-management-choice-json">Manage Table: Option List: Filter, Sort, Display Format</a>
<br><br>
<h2>■ Customize the screen color theme</h2>
<h3>Second-generation user interface theme</h3>
In the second generation, each user can set their own color variation from four themes.
<table>
<tr>
<td style="width:50%; text-align:center;"><img src="/img/manual/second-age-theme/26cerulean.png" style="margin: 0 !important;"></td>
<td style="width:50%; text-align:center;"><img src="/img/manual/second-age-theme/27green-tea.png" style="margin: 0 !important;"></td>
</tr>
<tr>
<td style="width:50%; text-align:center;"><img src="/img/manual/second-age-theme/28mandarin.png" style="margin: 0 !important;"></td>
<td style="width:50%; text-align:center;"><img src="/img/manual/second-age-theme/29midnight.png" style="margin: 0 !important;"></td>
</tr>
</table>
<h3>First-generation user interface theme</h3>
You can choose from a total of 25 themes in the first generation.
<table>
<tr>
<td style="width:33%; text-align:center;"><img src="/img/manual/jquery-theme/10hot-sneaks.png" style="margin: 0 !important;"></td>
<td style="width:33%; text-align:center;"><img src="/img/manual/jquery-theme/24ui-lightness.png" style="margin: 0 !important;"></td>
<td style="width:33%; text-align:center;"><img src="/img/manual/jquery-theme/12le-frog.png" style="margin: 0 !important;"></td>
</tr>
<tr>
<td style="width:33%; text-align:center;"><img src="/img/manual/jquery-theme/13mint-choc.png" style="margin: 0 !important;"></td>
<td style="width:33%; text-align:center;"><img src="/img/manual/jquery-theme/19start.png" style="margin: 0 !important;"></td>
<td style="width:33%; text-align:center;"><img src="/img/manual/jquery-theme/03blitzer.png" style="margin: 0 !important;"></td>
</tr>
</table>
User Manual▶ <a href="https://pleasanter.org/manual/user-management-theme">User Management: Customize the User Interface Theme | Pleasanter</a>
<br><br><br>