Master Detail type of Form

[smart]

Hi,

I am a new to Joomla and Fabrik.
I want to create Master/Detail type of forms.
But I don't find how to do step by step.
Could you please help me all those steps?

Thanks

 

[troester]

Can explain in detail what you want to achieve?
There are video tutorials about joining data, repeating groups
http://fabrikar.com/help/tutorials (log in)
and additional ones for bronze subscribers e.g. about one-to-many and many-to-many realations, cascading drop down element...

The videos are about Fabrik2 but the basics are the same (keep in mind that fabrik2 tables are fabrik3 lists, ACL has totally changed in Joomla2.5 and all about SVN is only Fabrik2)

 

[smart]

Hi troester,

Thanks for your reply.
Here are the things that I have setup.
1) Recipes List (RecipeID, Recipe Name)
2) Ingredients List (IngredientID, RecipeID, Ingredient Name)

There are two menu items on the form.
1) Recipe Entry; which is simple enough to show list and editing each recipe data.
2) Ingredients Entry; where I am troubling with.

At the Ingredients Entry....what I want to do is..

1) Pulldown List showing all the recipes from Recipes table.
2) List of ingredients which are related to each recipe.

So basically it is Master/Detail Form.

Once I select from Recipe Pulldown list, related records from Ingredients should show up and able to add/edit/modify as necessary.

I am still reading and testing ???

Thanks
Smart

 

[smart]

I have a small progress.
Now..two lists are created.
Another list was created and add join from Master to Child and chose repeatable "yes".
Then I see one extra group appear with the name "List name - Child name" which contains repeatable value "yes".

So in the form, I see Master Form follow by related Child forms.

Those are appear in Form Views...which are really long and not convenient to see.

Is there any way we can do to see Master form + Child List?

I think there may be some way to do..using content plug-in or filter.
But I don't know how to carry Master Key to filter on Child List.

Any thoughts ?
Thanks

 

[Jaanus]

Is there any way we can do to see Master form + Child List?

I think there may be some way to do..using content plug-in or filter.
But I don't know how to carry Master Key to filter on Child List.

Any thoughts ?
Thanks

Of course. Content plugin code for list in the "master's" form footer so that
{fabrik view=list id=# child_table___parent_id=[rowid]}

instead # your real list id number

 

[smart]

Jaanus

Thanks for your help!
It works as you said.

But I have another problem as well.
The one I have done is Main Form (Recipe) with Detail Form (Ingredients) beneath.
On Main Form, all the elements are displayed. I can disable all the elements and I want to show only Recipe Name.

That Recipe Name element has a drop down list. So if I choose desire recipe, Ingredient list will be shown automatically.

So my question is how to create a drop down element showing all the recipe names on the Master Form?

Thanks

 

[Jaanus]

I am not sure wheter this would be possible with Fabrik form. Maybe someone else could tell.

But... what you can do -

in the ingredients list you have a needed field - let's say this is named parent_id that points to the main recipe data, right? So you can make another list of ingredients, change the element type on parent_id to database join (rendered as dropdown) and make it also be a filter. You can tell the list that filtering is required. So you just go to the list and choose the needed recipe and the ingredients are displayed.

 

[smart]

OK Jaanus

I got it. By reading what you have said, I learnt how to do.
Here is another problem for me.
I tried another Master/Detail forms.

I am not getting the footer form (detail form) but instead I get
the code display there. {fabrik view=list id=33 VaIngre___varietyID =4}.

Only ID (no 4) was changing on related parent records.

Any thought on this..

Thanks

 

[troester]

Did you enable "Process Joomla Plugins" in Form/options?

 

[smart]

Thank you troester. It is not enable. now it works & still learning

 

[smart]

I have another issue here. Sorry to bother all of you again

Now I set everything and I can see the list on Master/detail Form..
But join data (related) data are not shown up in the footer. It showed no records.

When I check Join table..element name..everything are correct.
In the condition, I use the element name from the child table.

If the condition is omitted, it shows all the records in the list.

So I don't know what is going on. I think the problem is with the filter.

Any thoughts on it? Thanks

 

[Jaanus]

can you point us some url so the people could see what you mean

 

[smart]

Hey...Jaanus..

I found out the problem..
I didn't know that fabrik is space sensitive...
It takes me one full day to solve it.. ???
Ingre___ingreCatID =[rowid] didn't work.
Ingre___ingreCatID=[rowid] ..... this work.

We are used to working with SQL where most space are not sensitive..
Am I right ?