Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Forum
Support forum
Design your application
Multi Select - Check boxes
  • Page:
  • 1

TOPIC:

Multi Select - Check boxes 29 Jun 2016 17:16 #14110

Hi,
I need some help with a multi selection form field.

I see the posts pointing us to www.j-cook.pro/index.php/r/relations - but I don't understand.

Attached is my database schematic. For the Pollutant_storage_type field I would like a group of checkboxes so the user can select one or more values - such as "Wet", "Dry", "Online", "Offline".

Can somebody point me in the right direction?

(PS: it would be helpful if this forum allowed png and jpg files)
Just call me Chris :)
Attachments:

Please Log in or Create an account to join the conversation.

Multi Select - Check boxes 29 Jun 2016 18:10 #14111

Hi,

You have to create a link-table.
From your schema you have a FK (Pollutant_storage_type) directly linked to an ID in Pollutant_storage_types.
Therefore, you can only choose 1

Steps:
- Remove FK from devices table
- Create a table devices_storagetypes
- In there put an FK to devices and an FK to pollutant_storage_types
- Edit the collection view(s) if needed (there should be a cross table now, you might need to refresh the builder)
- Edit the item view(s), drag the relation to the form

This does not create a set of checkboxes however, this creates a multiple select (like the tags in Joomla)
The following user(s) said Thank You: organicwebs

Please Log in or Create an account to join the conversation.

Multi Select - Check boxes 04 Jul 2016 10:08 #14124

Thanks Romkabouter - that works well.

For others also trying to do this ... attached is an updated schematic...
Just call me Chris :)
Attachments:

Please Log in or Create an account to join the conversation.
  • Page:
  • 1
Forum
Support forum
Design your application
Multi Select - Check boxes
Time to create page: 0.058 seconds
“
”

Awards for the best Joomla app. This product is gonna win an award for this amazing job. Cook Self Service is the the best application from all over the Joomla universe ! It brings Joomla to a professional level really advanced for developers. It is a real fun to develop with it. The ACL part and security checks implementation are just... so much hours saved. I can now concentrate myself more on the design part and the creative works. Thank you so much. Guys I offer you all my congratulation ! Keep up the works because Joomla is needing it to increase the quality of extensions availables on the JED. I also learned a lot because I can see how to code at the proper place and I found all my answers reading the forum.
lack_hanson (JED)
          

Get Started

Log In Sign In