Skip to main content
Question

Thinning the Multi-Select Text choice pool

  • February 4, 2021
  • 0 replies
  • 40 views

I've seen similar posts on the boards, but not one worded quite like this... :

Is it possible to utilize several MST fields to thin out an available options in a "master" formula-MST?

Imagine the following scenario...

A small "New Hire" app is requested by HR to easily initiate a mountain-sized pile of  tasks to be done by filling out a few fields in a form and pressing save, but can't be bothered to keep a list of active company extensions anywhere. The app is to be fed a list of  company contacts from another table.  The HR rep wants to only be able to select available available internal company extensions to avoid having to reprint Business Cards.  

Master MST pool : {401-449}
Department Summary Pools: 
Billing: {410-429}
Sales: {401-409}
Repair: {430-439}

Already-assigned Extensions include : 409, 412, 431, 433, 402, 413, 417, 404, 401

Our derived summary Pools then look like this:
sales_pool   :  401,404,402,409
billing_pool : 412,413,417
repair_pool : 431, 433

Is there a native method to remove the items in the summary pools from the master MST?  I already plan to break up the comparison based on their departments (for less computing).  What can I do natively to accomplish a list of selectable,  extensions  still available in the repair pool?

------------------------------
Doug Hines | dhines@tritonnet.com
Learning it As I Go | Tier II Support | Systems
------------------------------
This topic has been closed for replies.

  • Quickbase Alumni
  • February 4, 2021
Is there any particular reason you're wanting to use Multi-Select Text fields instead of having these Extensions on their own table and using a relationship to connect them to a Contact record?

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------