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 fo…

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

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…

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

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 …

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

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.