-
New Commercial Services Section
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.
-
Joomla 5.1
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
Datajoin elements save null when runder as checkbox
- Thread starter confis
- Start date
cheesegrits
Support Gopher
Are you talking about what actually gets saved in the main table?
Checkbox and multiselect joins automatically create a many-to-many mapping tables, named <parent-table>_repeat_<joined-table> ... so for instance I have a checkbox join to us_states on my fab_cdd_test table, so it creates a fab_cdd_test_repeat_us_states table, which has a standard many-to-many map - a parent_id FK pointing back to the parent row, and a us_states FK pointing to the joined us_states row. And for each checkbox selection, a row is created in that map.
But yes, the main table's field (in my case 'us_states') will be null.
That's just a database thing. For a dropdown join, with only a single selection, we can do a simple one-to-one FK join, where the field on the parent table has the FK value pointing to the joined table. But for multiple selections, a many-to-many map table is required. WIthout a map table, you can't have multiple values for a join.
Checkbox elements don't have to join to other tables, so for those we just store the multiple selections as a JSON array.
-- hugh
Checkbox and multiselect joins automatically create a many-to-many mapping tables, named <parent-table>_repeat_<joined-table> ... so for instance I have a checkbox join to us_states on my fab_cdd_test table, so it creates a fab_cdd_test_repeat_us_states table, which has a standard many-to-many map - a parent_id FK pointing back to the parent row, and a us_states FK pointing to the joined us_states row. And for each checkbox selection, a row is created in that map.
But yes, the main table's field (in my case 'us_states') will be null.
That's just a database thing. For a dropdown join, with only a single selection, we can do a simple one-to-one FK join, where the field on the parent table has the FK value pointing to the joined table. But for multiple selections, a many-to-many map table is required. WIthout a map table, you can't have multiple values for a join.
Checkbox elements don't have to join to other tables, so for those we just store the multiple selections as a JSON array.
-- hugh