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.
‘’Add File’’ icon at Toolbox
How it looks like on the Canvas
|Free Form||Responsive Form||Mobile|
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 of the form tool;
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.
There is no action for this tool.
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.
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: