bespokeappstt
Hubstaff freelancer
If I have 3 list and the only common element is a customer name. How do I create a list that will have all 3 list joined and grouped by Customer Name?
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
bumped into a little issue that i'd rather not deal with right now. The Fabrik dbjoin that renders as a checkbox, those values are not showing up on mysql backend, at least using the phpmyadmin. I figure it's a Fabrik thing and I'll avoid it for now if I can get what I want from Fabrik. Thus the new question.In normal cases I always use list joins which is much more straightforward (for me). If it's only read-only and you feel comfortable with mysql views, then you can of course use them.
SELECT * FROM `rad_rentals`
You don't want or need a "brand-new" list (from scratch and without any data).Okay, suppose I want to create a 'joined' list but I want this to be a separate list. So I have list A and list B. I want the look of those lists and their form layout to remain as is, unchanged. But I want to create a new list C which will be list A joined to list B. Can I do that? Looking at the wiki here https://fabrikar.com/forums/index.php?wiki/list-joins/ . It looks as though you're modifying the original list so the list view changes. I want to create a brand new list that comprises of two previous list. How do I do that?
Yes please. I would like to create a separate list, called C and the data in C is joined data of A and B. So I want to join list A and list B but as a new list.You don't want or need a "brand-new" list (from scratch and without any data).
Instead, copy e.g. list A, then use a list join (as per Wiki link you provided). This "copy of A joined with B" is just as good as the list C you're imagining.