Add File

It is a tool to add files to the form. Approval is required for each file to be deleted from the file attachment element. The file can be deleted according to the approval status. Clicking on the image or pdf files added with Add File can display the file.

a14.jpg

‘’Add File’’ icon at Toolbox

 

a15.jpg

How it looks like on the Canvas

 

Compatibility

Free Form Responsive Form Mobile
icons8-check-circle-48.png icons8-check-circle-48.png icons8-check-circle-48.png

 

 

Remarks

After the files are saved, this file is not in your table as the file content. But, you can access the file with UserTableID area of your table. These files are saved in XPODA_FILES for each file. ProjectID and FormTypeID represent your table property. TableID is UserTableID of your table.

 

Properties

Properties of the form tool;

a16.jpg

 

  • Name: The name of the field is written.

  • Linked Form: Allows for the listing of selected linked form files.

  • Maximum (MB): The maximum size of the file is entered.

  • Help Text: It is the text typed for an explanation when mouse over the form tool.

  • Height / Width: Regulates the height and width of the form tool (The width field has been removed from Responsive Forms).

  • From Left / Top: Regulates the distance of the form tool from the left and top (This field has been removed from responsive forms).

  • Maximum Number of Files: The maximum number of files to be added is entered.

  • Types of File Example  .jpg | .png: You can limit file types in this area.

  • Store in File: When the feature is activated, the added files are stored in a local folder on the server where Xpoda is installed, instead of being stored in the table in SQL.

  • Display: Makes the form tool not appear on the screen.

Actions

There is no action for this tool.

Example Used

The example view of the Add File control in the form. When you click the select file, files are added to the form; and when the form is saved, the file is saved to the database in the varbinary data type. In the following screen, two files added to the field.

mceclip0.png

Client view on screen

You can do it with the file options that can be maximum with the maximum File space in the properties of the Add File tool. But being able to define minimal filesystem.

You can use the query to get approval without confirming the file in the form.

File analysis is performed by the File tool in the FileCount value form.

SELECT CASE WHEN $PFileCount$<=0 THEN 0 ELSE 1 END

With this query, the file will be looked up, nothing will happen where the file is stored.

Usage of query with action:

mceclip0.png