To answer your question faster, you can search our knowledgebase articles before submitting a ticket.
Knowledgebase
How to change a text field to select and add options for that field
Posted by on 28 June 2013 08:06 AM

It is important to follow these steps carefully:

Using the example of a "school" field with options 1) for Sterling Elementary and 2)  for St. Simons:

  • Go to the database and open table "#__rpl_dbst". "#_" is in reference to the database prefix.
  • Find the row that the field "school" is in, modify column "type" and enter the text "select" in that column for the respective row.
  • Also, modify column "options" and enter value: "1||Sterling Elementary *|* 2||St. Simons"

NOTE: Remove all double-quotes from the items above, before using them.

Now you have changed the field "school" to "select" type.

If you want to modify existing properties data for it, find the 'table_column' column in same row in '#__rpl_dbst' and search for column in '#__rpl_properties' table for that column value.

All you need is to modify the column value in the "#__rpl_properites" table with following rules.

  1. Replace Sterling Elementary to 1
  2. Replace St. Simons to 2

You can easily understand this logic from the value entered in "options" column.

 Please be careful not make a mistake in any of the above steps. Any resulting issues created by these kind of manual changes are not supported by our team.


Comments (0)