This topic is locked
[SOLVED]

 Adding Mutually Exclusive Radio Buttons to a Form in ASPRunner Pro 7.2

1/30/2014 10:21:44 AM
ASPRunnerPro General questions
M
MightyFerengi author

Good day everyone,
I am rather new to ASPRunner. I have inherited the software and two sites from our former Executive Director. Both are fairly simple sites used to store healthcare data in a MySQL server. I have been updating the sites per the requests of my co-workers and came upon a form that does not work well with our data.
On this form, I have cells with checkboxes in them: Applied, Approved, Pending, Denied. When an employee checks a box, it adds a 1 to the corresponding column in the DB. However, since the checkboxes are not mutually exclusive, I have a few rows with multiple column entries. What I would like to do is add a group of radio buttons to prevent multiple entries for each column. I tried the "Lookup Wizard" option, but the radio buttons created are not mutually exclusive to each other, only to buttons for each group, and I cannot set up each button in the group to correspond to a different column. Aside from coding them in the HTML editor and then trying to direct the data back to the DB, is there a functional way to do this with ASPRunner Pro 7.2?

G
gonzalosb 1/30/2014

please post pictures if you can to understand better, but i think as i understud that the bet way is the "Lookup Wizard" option and adjust it to your needs.

you can change the the "1" values for the actual "Applied, Approved, Pending, Denied" values in only one column, that way when you replace the value by a radio button, let only one value on the database, i will post pictures on how to do it later on if you like

M
MightyFerengi author 1/30/2014



please post pictures if you can to understand better, but i think as i understud that the bet way is the "Lookup Wizard" option and adjust it to your needs.

you can change the the "1" values for the actual "Applied, Approved, Pending, Denied" values in only one column, that way when you replace the value by a radio button, let only one value on the database, i will post pictures on how to do it later on if you like


That would be a great idea, except I have a few thousand records in the DB already. I was hoping to find a way that would not involve me having to mess with the records, just the form.

M
MightyFerengi author 1/30/2014



please post pictures if you can to understand better, but i think as i understud that the bet way is the "Lookup Wizard" option and adjust it to your needs.

you can change the the "1" values for the actual "Applied, Approved, Pending, Denied" values in only one column, that way when you replace the value by a radio button, let only one value on the database, i will post pictures on how to do it later on if you like


Actually, I started to think about it, then I added a new column and updated it based off of the other columns. That was WAY easier than I was thinking it would be. So, I changed my form to use the radio buttons from the "Lookup Wizard" and modified my reports to look in the new column. Thanks for your help, gonzalosb!

G
gonzalosb 1/31/2014

you welcome, glad i can help.