IU-DATA

#Full Portal

1 - Presentation & features

This add-on is a complete tool that you can integrate to your FileMaker solutions. Full Portal is an improvement of the native portals proposed by FileMaker Pro, keeping the native functionalities and adding dynamism and customization.

In addition, this add-on allows you to display and manipulate data sets, move, resize rows and columns. Full Portal also allows you to interact with your database's records and provides sorting and searching tools.

Main features :

Format JSON data into a dynamic table.
Ability to scroll horizontally
Manage the add-on's main parameters
Manage the add-on's style parameters
Resize rows and columns
Move rows and columns
Edit data
Ability to filter datas
Ability to sort datas
Customization of table headers
Customizable functional columns
Import and export data from and to FileMaker
Save the table's layout changes
FileMaker scripts to interact with the add-on
Responsive or fixed table height by specifying a number of rows

2 - Installation

2.1 Automatic

To make it quicker and easier for you, IU-DATA provides a small FileMaker solution beside each add-ons that directly install the add-on inside the right directory of your computer.

Run the file
Click on Instal the Add-on
In FileMaker Pro, open the solution in which you want to add the Add-On
In layout mode, open the left side panel on the Add-ons tab, click on the add button
Under the IU-DATA category, select Full Portal then click on Choose
Drag and drop the Full Portal add-on on the layout

2.2 Manual

Close FileMaker Pro

Copy the IUD_FullPortal folder to the following directory :

 - macOs : ~/Library/Application Support/FileMaker/Extensions/AddonModules/
 - Windows : AppData\Local\FileMaker\Extensions\AddonModules\

In FileMaker Pro, open the solution in which you want to add the Add-On
In layout mode, open the left side panel on the Add-ons tab, click on the add button
Under the IU-DATA category, select Full Portal then click on Choose
Drag and drop the Full Portal add-on on the layout

2.3 Configuration

The main configuration and customization instructions can be found inside the add-on web viewer's definition. Scripts and custom functions also have a whole series of information useful for the add-on configuration. For example purpose, a script set and a sample dataset are also provided.

Please note : If your database on which you want to install the add-on is hosted with FileMaker Server. You might need to refresh the globale calculation field IUD_FullPortal::gct_WV_FinalCode. Otherwise the webviewer that contains the add-on will remain empty. To refresh this field, you can set the field IUD_FullPortal::WV_HTML by it's own value inside a script that is launch at the start of your application.

3 - Structures

3.1 - Tables

z_IUD_FULLPORTAL : Table containing the definition of the add-on.

3.2 - Scripts

All Full Portal scripts are contained in the IUDATA - Full Portal script folder.

The description of scripts and parameters can be found in each script header

3.3 - Custom functions

The descriptions of the following functions are present in their respective calculations.

IUDATA_FullPortal_Config_SetAddonTexts ( __json ; __noDataText ; __noResultText ; __simpleFilterLabel ; __simpleFilterPlaceholder ; __advancedFilterLabel ; __advancedPlaceholder ; __viewTooltip ; __deleteTooltip ; __deleteBoxText )
IUDATA_FullPortal_Config_SetOptions ( __json ; __movableCols ; __movableRows ; __resizableCols ; __resizableRows ; __wantedRows )
IUDATA_FullPortal_Config_SetScripts ( __json ; __tag ; __import ; __export ; __edit ; __delete ; __show )
IUDATA_FullPortal_Config_SetStyle ( __json ; __bodyBackgroundColor ; __bodyFontColor ; __bodyFontFamily ; __tableBorderColor ; __tableBorderSize ; __headerBackgroundColor ; __headerFontColor ; __headerSeparatorColor ; __headerSeparatorSize ; __headerHeight ; __rowHeight ; __hoverRowBackgroundColor ; __hoverRowfontColor ; __oddRowBackgroundColor ; __oddRowFontColor ; __evenRowBackgroundColor ; __evenRowFontColor ; __rowSeparatorSize ; __rowSeparatorColor )
IUDATA_FullPortal_Config_SetUtilsDelete ( __json ; __icon ; __color ; __size ; __active )
IUDATA_FullPortal_Config_SetUtilsView ( __json ; __icon ; __color ; __size ; __active )
IUDATA_FullPortal_Header_AddDropDownColumn ( __json ; __index ; __field ; __title ; __valueList ; __headerSort ; __frozen ; __resizable ; __rowHandle ; __hozAlign ; __backgroundColor ; __color ; __width ; __focus )
IUDATA_FullPortal_Header_AddFMButton ( __json ; __index ; __icon ; __size ; __iconColor ; __scriptName ; __scriptParameter ; __toolTip ; __backgroundColor ; __frozen ; __focus )
IUDATA_FullPortal_Header_AddSimpleColumn ( __json ; __index ; __field ; __title ; __editor ; __headerSort ; __frozen ; __resizable ; __rowHandle ; __hozAlign ; __backgroundColor ; __color ; __width ; __focus )
IUDATA_FullPortal_CleanSVG ( __codeSVG )

3.5 - Value lists

No Value list in this add-on.

4 - Dependencies

Tabulator v4.9.3 (c) Oliver Folkerd (MIT License)

tabulator.js
tabulator.min.css

http://tabulator.info/docs/4.9

jQuery v3.6.0 (c) OpenJS Foundation and contributors (MIT License)

jquery.js

https://jquery.org/

Font Awesome v5.15.3 (MIT License)

fontawesome.min.js

https://fontawesome.com

Moment v2.29.1 (c) Moment.js contributors (MIT License)

moment.min.js

https://momentjs.com/

5 - Compatibility

Operating systems :

macOS Catalina 10.15 or greater
Windows 10 64-bit or greater

FileMaker :

Claris FileMaker Pro 19.3 or greater
Claris FileMaker Go 19.3 or greater

Claris FileMaker WebDirect :

All browser compatible with WebDirect using the add-on on a hosted file by Claris FileMaker Server 19.3 or greater

Please note that on FileMaker Go 19 the Full Portal activation inside web viewers require a double tap.

6 - End User Licence Agreement

Important Note: Please read this EULA carefully. Downloading, installing, using or modifying this add-on signifies that the end user and their organization accept this EULA.

Definitions :

The add-on is Full Portal v1.0.0.
The end user is the physical person who purchased the add-on on IU-DATA's website.
The organization is the structure or the company for which the end user works.
The household refers to the end user's family home.

Contract terms :
IU-DATA authorizes the end user and his organization or household to use, modify, copy the add-on at their convenience. IU-DATA authorizes the end user and his organization to use for commercial purposes the add-on, when the add-on is an integral part of a solution whose spectrum of use is much wider than that defined by the functionalities of the add-on alone. On the other hand, IU-DATA does not authorize the end user and his organization to use for commercial or distribution purposes the add-on, modified or not as a final product.

The end user and his organization / household have free assistance for a period of 2 months from the date of purchase of this add-on, for any questions related to the use and configuration of this add-on.
Full access to FileMaker sources as well as to the source code used in the web viewer gives to the end user and his organization / household full control over modifying this add-on. It is therefore natural that we cannot intervene free of charge on the add-on whose code has been altered compared to the original version that IU-DATA delivered. Likewise, IU-DATA cannot be held responsible for any malfunction of any libraries mentioned in paragraph 4 - Dependencies, as well as malfunctions of the add-on following use on an operating system or a FileMaker platform other than those mentioned in paragraph 5 - Compatibilities.

Contact :
For any questions, please contact us to this address: product@iu-data.com

7 - Credits

Creation and development :

Julien Rouard from IU-DATA
Maxime Bécu-Métailler d'IU-DATA

Icon design :

Christophe Gilet from Gilet Design

8 - Change Log

31/10/2021 - Full Portal v1.0.0 - 1^st release