Forum Discussion

DanteTognoli's avatar
DanteTognoli
Qrew Captain
5 years ago

formula for text-multiple choice?

Is there a way to apply a formula to a text-multiple choice field?

------------------------------
Dante Tognoli
------------------------------
Relationships
Tables and fields
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    Can you give an example of what you mean?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • DanteTognoli's avatar
      DanteTognoli
      Qrew Captain
      5 years ago
      I am using a text-mulitple choice field to pull a list of names from another field. I would like to filter the list by using a formula but I don't see any way to do that using the field properties. I can't think of another way to do it from a formula-text field that gives me a list I can choose from.

      ------------------------------
      Dante Tognoli
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        5 years ago
        You will need to have a table for the choices and have a relationship.  Then you can filter the drop down choices.  Multiple choices fields are not flexible and are best when there are are limit number of choices. 

        Relationships require a bit more setup but have a lot more flexibility.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------