Modify "Quotation" sheet

This section explains how to modify the "Quotation" sheet.

Attention

This document describes how to set up CELF 3.6.1 and earlier.

For CELF 4.0.0 and later versions, use Modify "Quotation" sheet .

Set up layout

Add more columns to enter temporary values in the workflow action.

1. Double-click the "Quotation" sheet.

2. Click the sheet settings icon.

   

3. Increase the sheet column number by one to "22". Column V is added to the sheet.

   

4. Hide column V. Select column V and select Hide from the right-click menu.

   

Placement of buttons related to workflow

Place buttons related to workflow.

These buttons will be shown and hidden later by an action.

1. Double-click the "Quotation" sheet.

2. Add a button to the following position.

   

   When creating a button by copying from an existing button, change the button ID (the second argument of the =BUTTON function) so that it does not overlap in the sheet.

Modify action

Set Save button (1)

Circulation starts when saved.

1. Click the "Save" button on top of the sheet.
2. At the end of the "Save" action set, before the "Redisplay" action, drop the "Start circulating of the following data in the circulation data []" action.
3. Click the Select Circulation Data button, and select "Quotation".
4. Enter 「=Quotation_Control（Action）!B2」in a Specify Data cell.

Hint

It refers to an external sheet automatically generated by the "Create app from Excel file" function.

5. Check the "Set the issued workflow number to the next cell" checkbox, and select the V1 cell. This cell will be used for specifying the "Workflow number" in subsequent workflow actions.

Hint

Column V is the column you added in "Set up sheet layout" above.

6. Uncheck "Generate error if already registered". 3 to 6 will result in the following actions

   

8. Click the "OK" button in the "Action set settings" dialog.

Set Save button (2)

Already circulated data cannot be updated.

1. Click the "Save" button on top of the sheet.
2. Drop the action at the top of the "Save" action set, as shown below.

In the "If ～ then" action, enter =AND(NOT(ISBLANK(Quotation_Control（action）!B2)),quotation_control(action）!B3<>"true").

This allows you to check the circulation status only when the data is existing.

3. For the "Start circulation of the following data in the circulation data []" action after 2, enter the same as in "Set Save button (1)" above.
4. For the "Show circulation status for the following circulation data" action after 3, enter the data as shown in the figure.

(The status of the circulated data corresponding to the workflow number in V1 cell is output to V2 cell.)

5. Next to the action in 4, drop and enter the next three actions from the "Control" tab.

Enter =AND(NOT(ISBLANK(V2)), V2<>"New") in "If ～ then" action.

This will make the system to display a message and exit if the circulation status is not "New".

6. Click the "OK" button in the "Action set settings" dialog.

Set the Circulate button

This allows you to execute the circulation process (application, approval, etc.).

1. Click the "Execute Circulation" on top of the sheet.

2. Click the "New action set" button in the "Action definition" dialog, enter "Execute Circulation" and click "OK" button.

3. Drop the "Perform circulation for the following circulation data" action and enter the following

   

Hint

V1 is the address of the cell where the workflow number was entered.

4. Click the "OK" button in the "Action set settings" dialog.
5. In the "Select Action Set" dialog, make sure that the "Execute Circulation" line is selected, and click the "Select" button.

Set the Inquiry Status button

Enable the display of the screen to check the status of the circulation.

1. Click the "Inquiry Status" button on top of the sheet.

2. Click the "New action set" button in the "Action definition" dialog, enter "Inquiry Status" and click "OK" button.

3. Drop the "Show circulation status for the following circulation data" action and enter the following

   

Hint

V1 is the address of the cell where the workflow number was entered.

4. Click the "OK" button in the "Action set settings" dialog.
5. In the "Select Action Set" dialog, make sure that the "Inquiry Status" line is selected and click the "Select" button.

Set History of Circulation button

Enable display of a screen to check the history of the circulation.

1. Click "History of Circulation" button on top of the sheet.

2. Click the "New action set" button in the "Action definition" dialog, enter "History of Circulation" and click "OK" button.

3. Drop the "Display circulation history for the following circulation data" action and enter the following

   

Hint

V1 is the address of the cell where the workflow number was entered.

4. Click the "OK" button in the "Action set settings" dialog.
5. In the "Select action set" dialog, confirm that the "History of Circulation" row is selected, and click the "Select" button.

Set comment button

Enable the display of a screen for referencing and registering comments.

1. Click the "Comment" button on top of the sheet.

2. Click the "New action set" button in the "Action definition" dialog, enter "Comment" and click "OK" button.

3. Drop the "Show comment screen for the following circulation data" action and enter the following

   

Hint

V1 is the address of the cell where the workflow number was entered.

4. Click the "OK" button in the "Action set settings" dialog.
5. In the "Select action set" dialog, confirm that the "Comment" row is selected, and click the "Select" button.

Setting of Initial Display action set

When the screen is initially displayed, show/hide the buttons according to their status.

1. Click the action set setting icon.

   

2. Double-click the "Initial display" action set in the opened dialog.

3. Place the action at the top of the "Initial display" action set as follows

   

   =ISBLANK(V1) of "If ～ then" action determines whether or not there is a workflow number, and controls the button as follows

   • In case there is no workflow number… Clear value of I2:L4,、set format to standard
     • "Execute circulation" "Inquiry Status" "History of Circulation" "Comment" buttons are hidden.
   • In case there is a workflow number…Clear value of C4:C6,、set format to standard
     • "Save" button is hidden.

4. Click the "OK" button in the "Action set settings" dialog.

5. Click "OK" button in the "Select action set" dialog.