Skip to main content
krishnav9816
krishnav9816
Known Participant
Jul 10, 2022 7:24 AM UTC
Question

what is data type for radio button in data base?

in DB we use tinyint (type), afterwards we create a interface from builders use table 1(where radio button contains like gender either male or female) but it is different from db to interface data type then how to do?

    12 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    Jul 10, 2022 9:43 AM UTC

    You can use any data type for the radio button choice values.

      krishnav9816
      krishnav9816Author
      Known Participant
      Jul 15, 2022 1:31 PM UTC

      when I am using tiny int in DB for radio button, whereas coming to interface initially it shows null values after I give value ,save into, choice values and choice labels then also it shows null values & I am clicking on button it erases not taken any values why ? plz....

      stefanhelzle0001
      stefanhelzle0001
      Brainy
      Jul 15, 2022 1:35 PM UTC

      I do not understand. Can you share some code?

      harshitb6843
      harshitb6843
      Brainy
      Jul 11, 2022 7:46 AM UTC

      For boolean types in the CDT, Appian keeps it as tiny int or bit in the DB

      krishnav9816
      krishnav9816Author
      Known Participant
      Jul 15, 2022 1:29 PM UTC

      when I am using tiny int in DB for radio button, whereas coming to interface initially it shows null values after I give value ,save into, choice values and choice labels then also it shows null values & I am clicking on button it erases not taken any values why ? plz....

      krishnav9816
      krishnav9816Author
      Known Participant
      Jul 15, 2022 4:51 PM UTC
       

      a!radioButtonField(
      label: "Gender",
      labelPosition: "ABOVE",
      choiceLabels: cons!HCMS_GENDER,
      choiceValues: {cons!HCMS_GENDER},
      value: ri!HCMSCUSTOMERDETAILS.gender,
      saveInto: ri!HCMSCUSTOMERDETAILS.gender
      ),

      when i click on male radio button & then also it shows null values and not getting any values

      karanl3932
      Participating Frequently
      Jul 11, 2022 9:34 AM UTC

      Its TINYINT at the backend or the integer with only 1 limit.

      charliee5034
      New Participant
      Jul 12, 2022 5:53 AM UTC

      A radio button is a type of data entry field that allows users to select one from a group of options. When you create a radio button, you specify the name and ID for the option, as well as its base value. The user can then choose between explicitly selecting this option or leaving it open so that any value entered will be applied to all instances of this radio button.

      Terms & ConditionsAccessibility statement