Databases
StackOverflow2013
Postsdbo
PORails 3 has_many :through form with dropdown menus?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PORails 3 has_many :through form with dropdown menus?
    primarykey
    data
    text
    <p>I'm trying to implement a has_many :through join in Rails 3 (with Formtastic) and I'm a little stuck. I have the models set up as follows:</p> <p><b>Models:</b></p> <pre><code>class Project &lt; ActiveRecord::Base has_many :employees, :through =&gt; :teams has_many :teams class Employee &lt; ActiveRecord::Base has_many :projects, :through =&gt; :teams has_many :teams class Team &lt; ActiveRecord::Base belongs_to :project belongs_to :employee </code></pre> <p>And this line gives me a multi-select box in the projects view that allows employees to be selected:</p> <p><b>View:</b></p> <pre><code>&lt;%= f.input :employees, :as =&gt; :select %&gt; </code></pre> <p>So far this gets the job done, but what I'd LIKE to have is a separate dropdown box to select each employee's name, then their role in the project. I can't figure out the form code to get me there...</p> <hr> <p><strong>EDIT:</strong></p> <p>As suggested, I've gotten the code from <a href="http://railscasts.com/episodes/197-nested-model-form-part-2" rel="nofollow">Railscast 197: Nested Model Forms</a> working and it's part-way there. This is what I have in the view:</p> <pre><code>&lt;%= f.semantic_fields_for :employees do |builder| %&gt; &lt;%= render 'employee_fields', :f =&gt; builder %&gt; &lt;% end %&gt; &lt;%= link_to_add_fields "add employee", f, :employees %&gt; </code></pre> <p>and the 'employee_fields' partial:</p> <pre><code>&lt;p class="fields"&gt; &lt;%= f.input :name, :as =&gt; :select, :collection =&gt; Employee.find(:all) %&gt; &lt;%= f.hidden_field :_destroy %&gt; &lt;%= link_to_remove_fields "remove", f %&gt; &lt;/p&gt; </code></pre> <p>But right now this creates a new employee rather than a new team (project-employee join record), so I think it's acting as a <code>has_many</code> rather than a <code>has_many :through</code>. How can I edit this so that the <code>:name</code> input above adds a record to <code>project[employee_ids][]</code>?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USellawren
    1. USellawren
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PORails 3 has_many :through form with dropdown menus?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PORails 3 has_many :through form with dropdown menus?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PORails 3 has_many :through form with dropdown menus?
      1. USussferox
      1. VTFavorite
    1. COThe railscasts.com episodes on nested model forms, numbers 196 & 197, may provide some ideas. They are not specifically on `has_many :through` but they do provide the ability to have multiple child fields for a parent object.
      singulars
      1. PORails 3 has_many :through form with dropdown menus?
      1. USnmott
    2. COI just watched those last night! I got that functionality working, but I'm still stuck on the `has_many :through` part.
      singulars
      1. PORails 3 has_many :through form with dropdown menus?
      1. USellawren
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload