1. summary

If you generate an application by importing forms in UniForm, you need to create the part that sends the entered data to an external database, but if you are working with a cloud database (UniBaaS DB), you can add a function to send data in a few steps However, if you are working with a cloud database (UniBaaS DB), you can add a function to send data in a few steps.

This section introduces the setup procedure for linking an application created with UniForm to a cloud database for data transmission.

Note that to create an application using UniForm, you must use the "1. overview of UniFormfor integration with the cloud database (UniBaaS DB).8. integration with external databases (cloud databases)respectively.

2. Cooperation Procedure

2.1 Import of Excel forms

Import Excel forms in UniForm and create your application.

For information on how to import Excel forms, see "5. importing filesPlease refer to the "See

2.2 Cloud Database Integration

Open the DB design and select "(imported)" from the automatically generated tables.Sheet nameOpen the table "_ds)_ds".

If there are items set as photo or handwritten signature input on the definition sheet, convert the type of the item to "binary type" as shown in the figure below.

Then, please link to the cloud database.

Cloud database integration is available through the "8. integration with external databases (cloud databases)Please refer to the "See

After linking with the cloud database, change the "default value" of the "Send Flag" that was automatically added to the database to "1" as shown in the figure below.

2.3 Modification of user configuration logic

Open the Processing Design and select "User Setup Logic" from the automatically generated logic.

Select the item indicated in red on the screen and right-click to "delete" it.

2.4 Setting up the sending process

Open Screen Design and select "Form Input Frame" from the automatically generated screens.

Select the "Report" button at the bottom of the screen.

Then, select "Write Logic" in the "Execution Process" column of the "Behavioral Settings" tab in the "Object" pane.

The above procedure completes an application that sends the contents entered in the form application to the cloud database.

Please confirm that the input data is sent to the cloud database when you run the application created with Unifinity Application Player and click the "Report" button after inputting data into the form.