Value is invalid in multiple_select

Marmanvii

I have a multiple_select to select a single medic for an appointment, I managed to show up a list to choose a medic, and when inspecting the element it does have an id as a value, the thing is that when trying to add an appointment it will give an error is invalid in the medic field.
This is my form:

<%= form_for @changeset, @action, fn f -> %>
  <%= if @changeset.action do %>
    <div class="alert alert-danger">
      <p>Oops, something went wrong! Please check the errors below.</p>
    </div>
  <% end %>

(...)

  <div class="form-group">
    <%= label f, :id_medico, class: "control-label" %>
    <%= multiple_select f, :id_medico, Enum.map(@medics, &{&1.nombre, Integer.to_string(&1.id)}) %>
    <%= error_tag f, :id_medico %>
  </div>

(...)

  <div class="form-group">
    <%= submit "✔", class: "btn btn-primary" %>
    <a class="btn btn-danger" href="/appointments" role="button">✖</a>
  </div>
<% end %>

and my controller:

  def new(conn, _params) do
    medics = Clinic.list_medics()
    changeset = Clinic.change_appointment(%Appointment{})
    render(conn, "new.html", changeset: changeset, medics: medics)
  end

Thanks.

26 comments

/phoenix #select

0 2424 26

2018-06-05 15:12:09 UTC

Showing Posts 1 to 10

Show Best Posts
Show All (oldest first)
Show All (newest first)

kokolegorille

I guess the problem is in the appointment schema.

Post #1

Marmanvii

This is the appointment schema:

schema "appointments" do
    field :bloque, :integer
    field :descripcion, :string
    field :fecha, :date
    field :id_medico, :integer
    field :rut_paciente, :string

    timestamps()
  end

Post #2

kokolegorille

… and the validation

Post #3

Marmanvii

Sorry:

def changeset(appointment, attrs) do
    appointment
    |> cast(attrs, [:rut_paciente, :fecha, :id_medico, :bloque, :descripcion])
    |> validate_required([:rut_paciente, :fecha, :id_medico, :bloque, :descripcion])
    |>unique_constraint(:bloque, name: :appointments_fecha_bloque_id_medico_index)
    |>unique_constraint(:fecha, name: :appointments_fecha_bloque_id_medico_index)
    |>unique_constraint(:id_medico, name: :appointments_fecha_bloque_id_medico_index)
    |>foreign_key_constraint(:bloque, name: :appointments_id_medico_fkey)
    |>foreign_key_constraint(:fecha, name: :appointments_id_medico_fkey)
    |>foreign_key_constraint(:id_medico, name: :appointments_id_medico_fkey)
  end

Post #4

Marmanvii

If I change it to number_input it works fine, but I would like to implement a multiple_select

Post #5

kokolegorille

It seems like has_many/belongs_to, but You do not define association.

I would add those… like this

schema "appointments" do
    field :bloque, :integer
    field :descripcion, :string
    field :fecha, :date
    field :rut_paciente, :string

    belongs_to :medico, Medico

    timestamps()
  end


schema "medicos" do
    ...
    has_many :appointments, Appointment
    timestamps()
  end

I also doubt about this, because a medico could potentially have may appointment, but here You say something else… You say there should be only one appointment with id_medico = x

|>unique_constraint(:id_medico, name: :appointments_fecha_bloque_id_medico_index)

Post #6

Marmanvii

Hmm, for some reason now I get:
ERROR 42703 (undefined_column): column a0.medics_id does not exist
In index.

Post #7

Marmanvii

Also, the unique constraint is there to avoid mutliple appointments with the same date, block and medic, the combination of these three attributes must be unique.

Post #8