How to Use Single Form Application

In this section, we’ll explain how to use the application automatically created by "Create app from Excel file" function.

Show data in single form

  1. Launch the published app.
  2. When the application is launched, the menu screen will open. Click the button named [Import sheet].
../../../../_images/img_01.en108.png
  1. The search screen opens. Select the data you want to see the details of from the list and click the "Detailed view" button.
../../../../_images/img_02.en106.png
  1. The main screen will open and the details of the selected data will be displayed on a single form.
../../../../_images/img_03.en90.png

Tip

If there is no data to choose from on the search screen, see "Register new data".

Register new single form data

  1. Open the search screen and click the "New Registration" button.
../../../../_images/img_04.en84.png
  1. The main screen is opened and displayed with no data registered.
../../../../_images/img_05.en77.png
  1. Enter your data and click the "Save" button.
../../../../_images/img_06.en63.png
  1. Return to the search screen and click the "Search" button.
../../../../_images/img_07.en59.png
  1. The data is displayed in the list and you can select the registered data.
../../../../_images/img_08.en55.png

Update the single form data

  1. Launch the published app and open the main screen.
  2. After editing the data, click the "Save" button.
../../../../_images/img_09.en48.png
  1. A pop-up will appear and the database will reflect your edits.
../../../../_images/img_10.en42.png

Delete single form data

  1. Open the search screen and check the data you want to delete.
../../../../_images/img_11.en41.png
  1. Click the "Delete" button. The list is updated and the deleted data is displayed.
../../../../_images/img_12.en38.png

Attention

Deleted data will be deleted from the database.
If you want to undo it, you need to back up the data in the table beforehand.
For more information on backing up table data, see Export Table Data (CSV).

Tip

If you don’t know which table to back up, you can check the table switching tab in the app publishing settings.
For more information on app publishing settings, please see Publish the application.

Duplicate the single form data.

  1. Open the search screen, select the data you want to view in detail from the list and click the "Copy Registration" button.
../../../../_images/img_13.en35.png
  1. The main screen will open and the details of the selected data will be displayed on a single form.
../../../../_images/img_14.en32.png
  1. Click the "Save" button.
../../../../_images/img_15.en29.png
  1. A pop-up will appear and the database will reflect your registration.
../../../../_images/img_16.en27.png
  1. Return to the search screen and click the "Search" button.
../../../../_images/img_17.en24.png
  1. The data is displayed in the list and you can select the registered data.
../../../../_images/img_18.en22.png