A dropdown that turns off not available options?

AppSheet AppSheet Q&A
,
1

Hi. I am trying to make an app for my job at a paint mixing facility. I work with a line of 14 main colors, but when a costumer wants a color not included, then I have to combine 2 or more (most of the time 3 or 4) basic colors to form a new one going by a recipe-like system of formulas with amounts in grams, using a weight scale for the mixing procedure.

The thing is I have a dropdown list with all the 14 basic colors where I would Iike to see only the ones I need for that particular recipe (i. e. no need for yellow colors in a purple mix or blue colors in a brown mix). HOwever, if I pass with one of the colors and taking off is not an option, a “recalculate” button should appear and allow to have a second round of pour-ins with the other colors (except for the one passed) being available again.

is it possible? Or am I dreaming high? Thanx in advance

CH

Is it possible to reduce the options depending on the particular recipe I select? Also, I*d like to have the options disaapear once I add each color. For instance, if I make a light purple, with blue, red and white, I start with a dropdown list of only 3 colors. After i have the needed amount of blue ready, the dropdown reduces to only 2, and after the last one the “status” changes to finished and the list resets for a new bucket of mix.

2

Subtract values from a list - AppSheet Help

3

NOT sure if it helps.

4

You need at least two referenced tables,

Please leave here names of the tables and fields you need, the rest is not necessary

5

CorneliusH_1-1716576942593.png
CorneliusH_1-1716576942593.png874×470 26.4 KB

Table 1 “Colbas” maning Basic Colors.

CorneliusH_2-1716577137783.png
CorneliusH_2-1716577137783.png929×643 44 KB

Table 2, Formulas, having a long series of “Basic Colors” from 5-15

CorneliusH_0-1716576831520.png
CorneliusH_0-1716576831520.png888×667 39 KB

table 3 “Pedidos” meaning “orders”

CorneliusH_3-1716577278686.png
CorneliusH_3-1716577278686.png892×659 48.3 KB

Table 4, “buckets” having the same long list of colors but only visible if >0 in Formulas.

CorneliusH_4-1716577460586.png
CorneliusH_4-1716577460586.png971×835 61.1 KB

Table 5: Detail_Buckets. MIx refers to the new color being made; Color refers to the basic colors from Table 1, where it is a Dropdown list showing all the basic catalog, where I only need the 4 that the formula calls for.

6

Mira el gif de este hilo, haber si es lo que buscas
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/How-can-I-copy-all-the-records-at-once-with-filter-ID/m-p/755320#M244737

por ejemplo en este caso al seleccionar un estudiante con un grado Kinder, solo muestra los registros de la tabla maestra de kinder, y segun valla agregando esta lista al estudiante, estos ya no se van mostrando porque ya se agregaron