Discussions

Expand all | Collapse all

formula for text-multiple choice?

  • 1.  formula for text-multiple choice?

    Posted 08-13-2020 15:12
    Is there a way to apply a formula to a text-multiple choice field?

    ------------------------------
    Dante Tognoli
    ------------------------------


  • 2.  RE: formula for text-multiple choice?

    Posted 08-13-2020 15:17
    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
    ------------------------------



  • 3.  RE: formula for text-multiple choice?

    Posted 08-13-2020 15:26
    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
    ------------------------------



  • 4.  RE: formula for text-multiple choice?

    Posted 08-13-2020 15:39
    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
    ------------------------------



  • 5.  RE: formula for text-multiple choice?

    Posted 08-13-2020 15:43
    Ok, I'll give it a shot, thanks!

    ------------------------------
    Dante Tognoli
    ------------------------------