Dynamic columns / horizontally sliding portal / fixed left column
I'm trying to build a 'spreadsheet'-like view on a normal user-screen layout.
What i basically like to do is generate a pivot-table, with the column-headers being the different values (=records) of a specific field in a different table.
I suppose that i need to work with a portal for this, but then i need to be able to determine the number of 'columns' dynamically (depending on the number of records in the 'other' file) and hence it might be that not all values fit in display-size of the portal which would then mean that a horizontal slidebar would be required.
Preferable also the first column should be 'fixed' so that it remains visible at all times.
... and i would like to do all this in FM (=without exports of data and further treatment in Excel, ...)
Am i asking something impossible? Does anybody has any suggestion?
Filemaker is not flexible in he horizontal direction. The number of field columns is set in Layout mode (or in Modify Table View) and cannot be adjusted dynamically.
The closest you can get to something like that is to build your table inside a field or in a web-viewer. See also: