Forum Discussion
EvanMartinez
5 years agoModerator
Hi Ermias,
To create a multiple choice that can have a variable result like that it is possible to do that by creating a table of answers that is the parent to the current table. Then you could have answers like Yes and No or Si and No using a conditional dropdown to control which one shows up. There just needs to be something in your form (or a button that directs to a form) that would work as a trigger to tell the related field and conditional dropdown which results to pull. For example if there was a checkbox asking the user if they preferred spanish you could then use that to help your conditional dropdown know which result to pull.
Alternatively you can have two separate fields and then have them shown or hidden depending on the form used. Then you can use a formula field for reporting that looks at both fields and pulls in the result from the one that is filled in so when you go to compare all the results you get a unified result across both fields.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
To create a multiple choice that can have a variable result like that it is possible to do that by creating a table of answers that is the parent to the current table. Then you could have answers like Yes and No or Si and No using a conditional dropdown to control which one shows up. There just needs to be something in your form (or a button that directs to a form) that would work as a trigger to tell the related field and conditional dropdown which results to pull. For example if there was a checkbox asking the user if they preferred spanish you could then use that to help your conditional dropdown know which result to pull.
Alternatively you can have two separate fields and then have them shown or hidden depending on the form used. Then you can use a formula field for reporting that looks at both fields and pulls in the result from the one that is filled in so when you go to compare all the results you get a unified result across both fields.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------