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?
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
Please see our announcement here.
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.