| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
Matrix.HTML
Queries html of matrix.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| Matrix | 13.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "Matrix.HTML"; MatrixRef { ; firstRow; lastRow; firstCol; lastCol; Flags; CSS Style } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| MatrixRef | The matrix reference number. | $matrix | |
| firstRow | The index of first row. Default is 0. |
0 | Optional |
| lastRow | The index of last row. Default is Matrix.Height-1. |
5 | Optional |
| firstCol | The index of first column. Default is 0. |
0 | Optional |
| lastCol | The index of last column. Default is Matrix.Width-1. |
6 | Optional |
| Flags | Available in MBS FileMaker Plugin 13.5 or newer. The flags for processing. Currently you can pass 1 to exclude html header and just get a HTML table. |
0 | Optional |
| CSS Style | Available in MBS FileMaker Plugin 14.0 or newer. Extra CSS / HTML to include. |
Optional |
Result
Returns text or error.
Description
Queries html of matrix.You can use this method to quickly get all values in a given area as html text to show in a web viewer.
This joins the values and removes text formatting.
Numbers, times and dates are right aligned.
If the matrix has column names, we add them as headers over the html columns.
Examples
Show html in web viewer made from data in Excel:
# load data from Excel document
Set Variable [ $matrix ; Value: MBS( "XL.Sheet.ReadCellsAsMatrix";
$bookRef;
0; // sheet index
0; // first row
9; // last row
0; // first column
5) // last column ]
# now make html
Set Variable [ $html ; Value: MBS( "Matrix.HTML"; $matrix) ]
# and show in web viewer
Set Web Viewer [ Object Name: "web" ; URL: "data:text/html;charset=utf-8," & $html ]
See also
Release notes
- Version 14.2
- Improved Matrix.HTML and JSON.ToHTML to use CSS for right alignment.
- Version 14.0
- Added CSS parameter for Matrix.HTML function.
- Version 13.5
- Added Flags Parameter for Matrix.HTML function.
- Version 13.3
- Added Matrix.HTML function.
Blog Entries
- MBS FileMaker Plugin, version 14.2pr1
- New in MBS FileMaker Plugin 14.0
- MBS FileMaker Plugin, version 13.6pr3
- MBS FileMaker Plugin, version 13.5pr1
- New in MBS FileMaker Plugin 13.3
- Neues MBS Plugin 13.3 für Claris FileMaker
- MBS Plugin 13.3 for Claris FileMaker
- MBS FileMaker Plugin, version 13.3pr1
This function checks for a license.
Created 12nd May 2023, last changed 11st December 2023
