Field Labels Error

  • My database has two custom radio button fields which have labels associated with them. For example 1::Admin, 2::Floor, 3::Kiosk.

    It worked fine for several years. Recently I ran a report with those fields included. Some of the older records displayed the labels but other newer records display the full definition i.e. instead of displaying “Admin” it will display “1::Admin”. Both old an newer records on the same report display their values differently.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author xnau webdesign

    (@xnau)

    First, make sure the configuration of the radio button field is correct. Something could have changed in the “options” attribute of the field definition. Make sure that is correct and then save the fields.

    The next thing to check is the data in the database: you will need to look at it directly, using phpMyAdmin (usually found in your hosting control panel) so you can see what’s going on with the data.

    You may have to correct the data in the database, which you can do either with a database query (if you know how to do that) or by eporting the data, fixing it in a spreadsheet app, then reimporting it. Make sure to export the record ID so you can update the records when you reimport the data.

    Plugin Author xnau webdesign

    (@xnau)

    Just to remind you: the format for the options attribute for a radio button (or any options type field) should be title::data, so if you want it to store the number and display the name, the option should be:

    Admin::1,Floor::2,Kiosk::3

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Field Labels Error’ is closed to new replies.