[TYPO3-project-formidable] Simple Example

[Jonas Dübi]

Hi Everyone

I'm starting to use formidable, and I plaied around with the existing 
examples and I read most of the documentation.

I wanna solve a realy simple example:

Table1: alert

Fields:
uid		int
title		varchar
text		text (rte)
alert_date	date
alert_for	int -> uid of the fe_users
alert_category	int -> uid of the alert_category

Table2: fe_users
uid		int
username 	varchar()
....


Table3: alert_category
uid		int
title		varchar

All relations are properly set in TCA, backend editing for those tables 
works great...

Now I wanna do a list with the LISTER for all alerts where I can filter 
for keyword (title and text), alert periode (start date, end date), 
alert_category (selectbox with all categorys) and alert_for (selectbox 
with all fe_users).

I started with just the listing. Most things worked.

I don't wanna display the uid of the user, I wanna display the username. 
I don't wanna display the category uid I wanna display the category 
title. Couldn't find any example or hint in the documentation how that 
could work out.

At that point I got stuck. The only possiblity I saw, was to throw the 
array trough a function which replaces the uids with the names.

I didn't finish the listing yet, because in the End I had to do so many 
things in external php code, that I just didn't saw a big advantage of 
formidable.

Did I miss something? In the examples there is not hint about relations.

Does formidable even care about TCA?

Regards Jonas