× If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting: joodb.feenders.de/support.html

Restrict editing field to a dropdown or radio button

  • gordon.springwoodhouse
  • Offline
More
3 years 2 months ago #6019 by gordon.springwoodhouse
Restrict editing field to a dropdown or radio button was created by gordon.springwoodhouse
Hi

I need to restrict editing one filed in my table to a list of approx 5 text entries. So this could be a dropdown select box or radio buttons.
Is this possible with JoomDB?

Thanks for any tips on helping me achieve this.

Please Log in to join the conversation.

More
3 years 2 months ago #6023 by Dirk
Replied by Dirk on topic Restrict editing field to a dropdown or radio button

gordon.springwoodhouse wrote: Hi

I need to restrict editing one filed in my table to a list of approx 5 text entries. So this could be a dropdown select box or radio buttons.
Is this possible with JoomDB.


The easiest way is to use the ENUM or SET field type for MySql.
You can use PHPMyAdmin or any other tool to change your table.
Look at the category field at sample Database.

If you can not edit your table for any reason you must write
yourself a plugin or manually insert the select field into template.

Please Log in to join the conversation.

  • gordon.springwoodhouse
  • Offline
More
3 years 2 months ago #6025 by gordon.springwoodhouse
Replied by gordon.springwoodhouse on topic Restrict editing field to a dropdown or radio button
Thanks Dirk.
ENUM works perfectly.

Cheers!

Please Log in to join the conversation.

Moderators: Dirk, joest