Skip to main content
Question

Field with two set of options depending on form

  • August 11, 2020
  • 0 replies
  • 21 views
  • Del
  • Quickbase Alumni
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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+17
  • EvanMartinez
  • Community Moderator
  • August 13, 2020
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
------------------------------
    Terms & ConditionsAccessibility statement