Select() feature request

[Apper]

Hi everyone,

Is it possible to make SELECT() feature to be able to work with multiple referenced tables? I have many tables from where I’d like to gather values, but the feature itself works only with one referenced table.

I was thinking maybe there would be a possibility to design it in conditional way. For example, if there is value in column of the table 01 with SELECT() feature, it would gather records from table 01, if there is value 02, it’d respectively collect records from table 02 and so on.

If there is mistakes in my technical jargon here, sorry about that. I’m still very new to this.

Thanks

[1minManager]

Normally what you’d do is to create 2 Select formulas & add the lists together e.g.

Select(Table1[ColumnA],TRUE)
+
Select(Table2[ColumnA],TRUE)

help.appsheet.com

List Addition

Add lists together to produce another containing all items in the originals.

then maybe use

help.appsheet.com

List Functions

Create lists using functions.

or

help.appsheet.com

List Expressions

List expressions use and/or produce lists of values.