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?
Discussion posts and replies are publicly visible
You can use any data type for the radio button choice values.
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....
I do not understand. Can you share some code?
tinyInt is just boolean (or specifically, the DB-backed data type appian uses to back the Boolean type in appian). That has nothing specifically to do with the Radio Button component, which as Stefan mentioned, can use any data type based on how it's configured / what you want it to do. You haven't given us much context by which we can determine what you want to accomplish, what you've tried, and what isn't working...
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
It's because you have TINYINT at backend right? And you are using same constant for choiceLables and choiceValues so whenever you are clicking MALE the VALUE saved will be "MALE" which is string. So, it's not getting saved either take VARCHAR at the backend or just provide {0,1} in choiceValues 1 for MALE and 0 for FEMALE.
a!radioButtonField(
label: "Gender",
labelPosition: "ABOVE",
choiceLabels: cons!HCMS_GENDER,
choiceValues: {0,1},
value: ri!HCMSCUSTOMERDETAILS.gender,
saveInto: ri!HCMSCUSTOMERDETAILS.gender
),
Copy and Try