Hey!
Is it possible to make a selection of values from a dropdown list based on data from another table:
1 - for use when entering data?
2 - when choosing conditions for data slice?
https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if
https://help.appsheet.com/en/articles/961554-dependent-dropdown
2 Likes
Hi! Many thanks for helping!
I have 2 tables. Clients and Orders.
Table CLIENTS have: clientUID, Name
Table ORDERS: orderUID, clientUID, goods_index (like “flowers” - text), Goods_desc (long text), good_price.
I need a new list where will be list of all clients, and if client ordered any time (goods_index=“flowers”) - mark “F”. Tables related together. Clients may have many other orders, or they many times ordered flowers or never. I need in new table only 2 columns - Client, and column “F” - where will be 1 (client had order flowers, or 2 - never not ordered flowers).
How it better to organize?
Your description is quite rough to understand but you want to know if a certain client has ever orderer flowers?
You could add a virtual column to your Clients table called [Flowers?].
This may be a simple Y/N column.
You should have a [Related ORDERS] VC there also.
Your [Flowers?] column would need this AppFormula:
IN("Flowers", [Related ORDERS][goods_index])
Hello! No. I need a table with 2 columns. The first column will be a list of ALL my clients, and the second column will be a “yes” if the client has ever ordered flowers. And “no” - if the client did not order flowers 
Well, that’s what I was talking about.
Why would you duplicate all of your clients on another table?
Just add a column to the clients one.
If you MUST have just two columns on a dataset, use a slice