Hi.

I'm trying to convert this table:
www.ifabrix.com/index.php?option=com_fabrik&view=table&tableid=6&calculations=0&resetfilters=0&Itemid=72

into a Tiny table with the same functionality.

I have two requests:

1. How can I generate the thumbnail column based on filenames from a mysql table.

2. How can I generate a detailed view with information from the mysql table and links in each row to detailed view from the Tiny Table.

The unfinished Tiny table can be seen here:
www.ifabrix.com/index.php?option=com_k2&view=item&layout=item&id=21&Itemid=81

Regards,

Magne.

Hello,

1. Use "Columns settings -> Format" parameter. For example if column name with link to image have "Img" name, set "Columns settings -> ID" parameter to Img value and "Columns settings -> Format" parameter to the following value:

<img src="{$value}" />

2. You can read about it here.

Regards,
ARI Soft

Thanks.

The first part was easy but the information about solving number 2 is not sufficient for me.

Is it nessescary to create an article with a secondary table? and if yes can you give me an example of article content and secondary table definition?

Regards,

Magne.

Data in detailed table is loaded based on ID from main table. Regarding to this post, ID is sent as request variable to detailed tabled and uses in SQL query for detailed table.

If you provide a temporary access to your Joomla! backend by email, provide a link to a page with main table and specify what data do you want to show in secondary table, we will be glad to help configure the extension.

Regards,
ARI Soft

Check your mail.

Regards,
ARI Soft

One last question:

How is the SQL query syntax if I want to retrieve data from a second mysql table based on the integer value from the primary mysql table?

For example "Type" in first row should not say "3" but should retrieve the text value associated with id=3 from the table Kategori.

See table here:
ifabrix.com/index.php?option=com_k2&view=item&layout=item&id=29&Itemid=72

Regards,

Magne.