【Form Designer】Visibility of the forms in process within our business

# Introduction #
I mentioned the Sharperlight Form Designer briefly in a previous post [【Form Designer】Creating a simple web based solution with minimal effort](https://qiita.com/Miki_Yokohata/items/a3c1defe07d4bc65a0f2).
Today, I look into the other functionalities that the Form Designer offers.

# Template #
I use one of the default templates provided by Sharperlight.
Open **Form Designer** from Sharperlight Application menu.
Click `New` to display a list of templates.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/f79fbd79-12c7-6db1-fd48-c51f2341116a.png)
I choose **Staff Expenses** template.
The definition is loaded like this.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/bac73e80-e51e-c0f6-6764-5e39c95a313e.png)
Click `OK` to close it for now.

# Dashboard Page for the Form #
One of functionalities I want to have a look is `Dashboard Page`.
We can see the current status of the form and manage the form entered here.

Select `Dashboard Page` from the right-click menu.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/b889c586-51d7-60da-ba8d-aeace4cd0833.png)
The dashboard page is now open. (Please make sure the Sharperlight Service is running)
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/2afa86d1-fe46-2356-bddf-f6386bc783a5.png)
There is no form entered currently so nothing is displayed here.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/03062db8-d7f9-b670-fae3-18fde1f03ba7.png)

### Scheduling the form ###
We can schedule the entry of the form.
Open the definition and set the schedule so that the form can be created every Friday starting from July 5, 2024.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/99944ef4-b5d8-a5cd-9875-043deb9d016c.png)
Save the change and have a look the dashboard page.
13 forms are now scheduled. (Today: 18/Sep/2024)
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/9a6e9ef0-ff31-3084-de84-9cf28870fd16.png)

### New Form ###
I create a new form for the scheduled date **Fri 5 Jul 2024** to see what happens.
Click the `New` button on the row of **Fri 5 Jul 2024**.
Fill in the form like this, then submit it.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/b11188b8-d60e-75f3-5dfb-ee42dc404946.png)
The dashboard page shows the update here.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/b1a3eeeb-1745-fde2-3311-3803e6591bb9.png)
Let's browse what it is showing.

### *Submission* Column ###
There are three buttons `New`, `Edit` and `View`.
I can edit or view the entered form and it is read-only in `View` mode, and I can also create a new form for the scheduled date with the `New` button.
The `New`button can be controlled with this option, also the number of forms per scheduled date can also be controlled with this option.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/5678ec68-6906-fa5e-bba4-0ecbf334a411.png)

When I use the option and set 1 for it,
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/21e7a107-78e2-be73-62a4-74c43f00f6bd.png)
`New` button is disabled for the form scheduled on Fri 5 Jul 2024 as a form already exists.
However, `New` button for the form scheduled on Fri 12 Jul 2024 is enabled because there is no form created for the scheduled date yet.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/f23588b7-de3a-9d81-ec3d-b929a24dddcd.png)


### *Complete* Column ###
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/1e940fdf-c703-0956-874f-853b8bba07fb.png)
It shows the number of fields that exist for the form and how many of those fields are filled in.
15/11 indicates that 11 out of 15 fields are filled in. 
You may say there are 13 fields in the editor, but there are two hidden fields.
Let's have a look the definition. There are 15 fields defined.
The 2 fields **Amount(sys)** and **Tax(sys)** are hidden with this Advanced Option.
They are calculated fields and they are not shown in the editor without selecting this checkbox.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/13ad0f46-c4f9-712a-0f9a-206ce2575909.png)
I make change to show them like this.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/b75471fc-61ff-e2bd-2e13-cd3e8215652e.png)
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/f9d6c72b-9efe-5c9d-1d25-fb90a687bfa5.png)
I can now see all 15 fields.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/f6cea253-5d61-1394-0e1c-3d6dd8bcd47c.png)

If I want to exclude those two fields from the total field count, I can set a tag **\<ignore\>** to this option for those 2 fields.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/74ed5a1b-91f4-cbb0-8579-20395b9ceb44.png)
It says 13/9 now.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/cedb4a32-abd5-12a2-f76f-938de10c86ac.png)

### *Flagged* Column ###
It currently shows 1, so let's check the reason why.
Open the definition and go to the Fields tab to check the options for each field one by one.
Please notice the Flagged option here.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/53ced8a2-7162-3b53-d792-eb88ac57e414.png)
There are 5 fields which have the Flagged condition.
I think the value in one of the fields does not meet the Flagged condition.
|Definition: Field|Condition |Value entered |
|---|---|---|
|Amount|<=0|99.0 |
|Tax|<=0|9.0 |
|Tax(Sys)|<=0|9.0 |
|Exchange Rate|<=0|1.000 |
|Receipt1|0| no file attached |

As you can see, the condition for Receipt1 field says **when no receipt is attached, make a flag**.
This is the reason why the Flagged column shows 1.
If I attach a file for Receipt1, the column show 0. Then Receipt1 is also filled in now so the `Complete` column shows 13/10.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/226a6624-f4ed-02ee-7ecf-a6b9f73c6767.png)

### *Pending* Column ###
The column says **Expired**.
It is due to this option here.
Today (18 Sep 2024) is more the 60 days from the scheduled date i.e. Fri 5 Jul 2024, so it shows **Expired**.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/2b1e30a5-c6d1-9ab4-fc18-adaf1eb004e0.png)
If I create a new form for the scheduled date **Fri 6 Sep 2024** today (18 Sep 2024), It shows **Late**. 
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/a03d2553-8a1e-a126-6063-5253cd2e7956.png)
The value shown is calculated based on this option with the scheduled date.
![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/2530698/8b774c61-2080-b64a-cbbe-ab513157b517.png)


# Conclusion #
I looked at the dashboard page for the forms this time and found that it provides a clear view of the forms being processed. It is also a powerful tool for managing such processes within the organization.