Yes or No toggle field?

  • Resolved grungyape

    (@grungyape)


    3 years ago

    I have a table with a Yes|No field to indicate if the row is disabled. It is not a linked table, so I can’t do a relationship to get the dropdown, at least not without changes.

    Is there anyway to manually set a DB column with a pre-set Yes|No value defaulting to No if not currently set?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi @grungyape,

    You can use an enum:
    column_name enum(‘Yes’, ‘No’) default ‘No’

    This will set the default to No and the plugin will automatically generate a listbox for this column.

    Is this what you are looking for?

    Thanks,
    Peter

    Thread Starter grungyape

    (@grungyape)

    Perfect!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Yes or No toggle field?’ is closed to new replies.