Forum Discussion

Del's avatar
Del
Qrew Cadet
5 years ago

Field with two set of options depending on form

Is there a way to create a multiple choice field that has two sets of options depending on the form? For Example;

Form 1
Do you live in California? 
Yes
No

Form 2
Vives en california? (Do you live in California "alternate text")
 Sì
No


------------------------------
EB
------------------------------
  • 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
    ------------------------------