saving values from radio buttons to database. rails app

Question

I'm adding radio buttons to my page. I want the user to be able to pick whether the order gets sent or they pick it up.

I'm having troubles to save the values to the database.

can someone advise me?

    <div class="col-md-5 pick-up-buttons" id="country_div">

    <li><%= f.radio_button :pick_up, true %></li>
    <li><%= f.label :pick_up, "Pick up order in store", :value => "false"  %></li>


    <li><%= f.radio_button :pick_up, false, :checked => true %></li>
    <li><%= f.label :pick_up, "have the order delivered", :value => "true" %></li>

  </div>

here is the schema_file

  create_table "orders", force: :cascade do |t|
    t.string   "name"
    t.string   "email"
    t.text     "address"
    t.string   "city"
    t.string   "country"
    t.datetime "created_at",                 null: false
    t.datetime "updated_at",                 null: false
    t.boolean  "shipped",    default: false
    t.string   "pick_up"

  end

you need to run another migration and update the datatype of field — Tushar Pal
– Tushar Pal, Commented Jul 5, 2017 at 11:16

Tushar Pal · Accepted Answer · 2017-07-05 12:36:27Z

1

Just run:

rails generate migration changeStringToBooleanOfPickup

then modified the generated migration file to:

change_column :orders, :pick_up, 'boolean USING CAST(pick_up AS boolean)'

then execute rake db:migrate

edited Jul 5, 2017 at 12:36

answered Jul 5, 2017 at 11:26

Tushar Pal

5237 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Slowboy Over a year ago

I get this error messages when I do rake db:migrate

PG::DatatypeMismatch: ERROR:  column "pick_up" cannot be cast automatically to type boolean HINT:  You might need to specify "USING pick_up::boolean". : ALTER TABLE "orders" ALTER COLUMN "pick_up" TYPE boolean

Slowboy Over a year ago

fixed it by doing = def change change_column :orders, :pick_up, 'boolean USING CAST(pick_up AS boolean)' end

Tushar Pal Over a year ago

updated the answer yes you can do it by using it,is it working now?

puneet18 · Accepted Answer · 2017-07-05 11:36:09Z

1

Datatype of pickup column should be boolean to save true/false value.

<%= f.radio_button :pick_up, "1", checked: @order.pick_up?, data: { question: 'Pick up order in store' } %> <%= f.label :pick_up, "Yes" %>
<%= f.radio_button :pick_up, "0", checked: @order.pick_up?, data: { question: 'have the order delivered?' } %> <%= f.label :pick_up, "No" %>

edited Jul 5, 2017 at 11:36

answered Jul 5, 2017 at 11:31

puneet18

4,4272 gold badges25 silver badges27 bronze badges

4 Comments

Slowboy Over a year ago

thak you for that but, how would I turn this to have the 'have the order delivered?' default checked?

Slowboy Over a year ago

this might sound stupid, but were should the value "1"be inserted to the code? I've tried to inserted but always get an error

puneet18 Over a year ago

try this:

<%= f.radio_button :pick_up, "1", checked: @order.pick_up?, data: { question: 'have the order delivered?' } %> <%= f.label :pick_up, "No" %>

puneet18 Over a year ago

try

<%= f.radio_button :pick_up, "1", checked: true, data: { question: 'have the order delivered?' } %> <%= f.label :pick_up, "No" %>

Collectives™ on Stack Overflow

saving values from radio buttons to database. rails app

2 Answers 2

3 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related