Databases
StackOverflow2013
Postsdbo
POHow do I use accepts_nested_attributes_for?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow do I use accepts_nested_attributes_for?
    primarykey
    data
    text
    <p><strong>Editing my question for conciseness and to update what I've done:</strong></p> <p>How do I model having multiple Addresses for a Company and assign a single Address to a Contact, and be able to assign them when creating or editing a Contact?</p> <p>I want to use nested attributes to be able to add an address at the time of creating a new contact. That address exists as its own model because I may want the option to drop-down from existing addresses rather than entering from scratch.</p> <p>I can't seem to get it to work. I get a undefined method `build' for nil:NilClass error</p> <p>Here is my model for Contacts:</p> <pre><code>class Contact &lt; ActiveRecord::Base attr_accessible :first_name, :last_name, :title, :phone, :fax, :email, :company, :date_entered, :campaign_id, :company_name, :address_id, :address_attributes belongs_to :company belongs_to :address accepts_nested_attributes_for :address end </code></pre> <p>Here is my model for Address:</p> <pre><code>class Address &lt; ActiveRecord::Base attr_accessible :street1, :street2, :city, :state, :zip has_many :contacts end </code></pre> <p>I would like, when creating an new contact, access all the Addresses that belong to the other Contacts that belong to the Company. So here is how I represent Company:</p> <pre><code>class Company &lt; ActiveRecord::Base attr_accessible :name, :phone, :addresses has_many :contacts has_many :addresses, :through =&gt; :contacts end </code></pre> <p>Here is how I am trying to create a field in the View for _form for Contact so that, when someone creates a new Contact, they pass the address to the Address model and associate that address to the Contact:</p> <pre><code> &lt;% f.fields_for :address, @contact.address do |builder| %&gt; &lt;p&gt; &lt;%= builder.label :street1, "Street 1" %&gt; &lt;/br&gt; &lt;%= builder.text_field :street1 %&gt; &lt;p&gt; &lt;% end %&gt; </code></pre> <p>When I try to Edit, the field for Street 1 is blank. And I don't know how to display the value from show.html.erb.</p> <p>At the bottom is my error console -- can't seem to create values in the address table:</p> <p>My Contacts controller is as follows:</p> <pre><code> def new @contact = Contact.new @contact.address.build # Iundefined method `build' for nil:NilClass @contact.date_entered = Date.today @campaigns = Campaign.find(:all, :order =&gt; "name") if params[:campaign_id].blank? else @campaign = Campaign.find(params[:campaign_id]) @contact.campaign_id = @campaign.id end if params[:company_id].blank? else @company = Company.find(params[:company_id]) @contact.company_name = @company.name end end def create @contact = Contact.new(params[:contact]) if @contact.save flash[:notice] = "Successfully created contact." redirect_to @contact else render :action =&gt; 'new' end end def edit @contact = Contact.find(params[:id]) @campaigns = Campaign.find(:all, :order =&gt; "name") end </code></pre> <p><strong>Here is a snippet of my error console:</strong> I am POSTING the attribute, but it is not CREATING in the Address table....</p> <blockquote> <p>Processing ContactsController#create (for 127.0.0.1 at 2010-05-12 21:16:17)</p> <p>[POST] Parameters: {"commit"=>"Submit", "authenticity_token"=>"d8/gx0zy0Vgg6ghfcbAYL0YtGjYIUC2b1aG+dDKjuSs=", "contact"=>{"company_name"=>"Allyforce", "title"=>"", "campaign_id"=>"2", "address_attributes"=>{"street1"=>"abc"}, "fax"=>"", "phone"=>"", "last_name"=>"", "date_entered"=>"2010-05-12", "email"=>"", "first_name"=>"abc"}}</p> <p>Company Load (0.0ms)[0m [0mSELECT * FROM "companies" WHERE ("companies"."name" = 'Allyforce') LIMIT 1[0m</p> <p>Address Create (16.0ms)[0m<br> [0;1mINSERT INTO "addresses" ("city", "zip", "created_at", "street1", "updated_at", "street2", "state") VALUES(NULL, NULL, '2010-05-13 04:16:18', NULL, '2010-05-13 04:16:18', NULL, NULL)[0m</p> <p>Contact Create (0.0ms)[0m<br> [0mINSERT INTO "contacts" ("company", "created_at", "title", "updated_at", "campaign_id", "address_id", "last_name", "phone", "fax", "company_id", "date_entered", "first_name", "email") VALUES(NULL, '2010-05-13 04:16:18', '', '2010-05-13 04:16:18', 2, 2, '', '', '', 5, '2010-05-12', 'abc', '')[0m</p> </blockquote>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAngela
    1. USAngela
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow do I use accepts_nested_attributes_for?
      1. USAngela
      1. VTBountyStart
    2. VO
      singulars
      1. POHow do I use accepts_nested_attributes_for?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow do I use accepts_nested_attributes_for?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHmm i think creates insers value in the address table, here is where Address Create (16.0ms)[0m [0;1mINSERT INTO "addresses" ("city", "zip", "created_at", "street1", "updated_at", "street2", "state") VALUES(NULL, NULL, '2010-05-13 04:16:18', NULL, '2010-05-13 04:16:18', NULL, NULL)[0m
      singulars
      1. POHow do I use accepts_nested_attributes_for?
      1. USdombesz
    2. COUpdated my post, included the code in the views.
      singulars
      1. POHow do I use accepts_nested_attributes_for?
      1. USdombesz
    3. COYou can see that under Address Create the values for street1 are blank...not "abc"....
      singulars
      1. POHow do I use accepts_nested_attributes_for?
      1. USAngela
 

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