How to pull data and aggregate data from multiple tables?

[pex]

Hello,
I have the following tables:

1. Campaigns
2. General Locations
3. Installations

I have set up an action button that copies the ID from the campaign table to the installation table, but now I need the installations table to fill a couple of others columns from the General locations table base on the copied ID from the campaign table, this ID will be present in one or two columns on the general location table and I need the information of the same row of where this copied id is present.

Example:

Campaign Table
Action bottom copies ID from campaign table (ID column) to (campaign column) on the installation table.

Then:

Installation Table
Based on (Copied ID/campaign column) retries data for columns (a) columns (b) from table General Locations

General Locations
(Column x) (Column e) as the same (Copied ID) but I need information of column (a) and (b) of the same row.

This will be multiple records, as the general location will have multiple rows with the campaign id assigned to it and it I need the installation table to retrieve all this locations with this campaign id assigned to it.

How to build this? the most basic way please.

Hope it make sense.

Thanks!

[Marc_Dillon]

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[pex]

Hello Marc_Dillon,

Tried the below formula and getting this error:
Cannot compare List with Text in (Ubicaciones Fijaciones[FV] = [_THISROW].[CAMPAÑA])

Formula:
SELECT(Ubicaciones Fijaciones[CODIGO], Ubicaciones Fijaciones[FV] = [_THISROW].[CAMPAÑA])

The [FV] columns has the same “id” as [CAMPAÑA] column, and the [FV] is ref to another table where the [CAMPAÑA] ids are created.

Any advice ?

Thanks

[Marc_Dillon · Accepted solution]

Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table Tips & Tricks 💡

Having answered this question about 1 million times now, I guess I should make a tips-and-tricks post about it. Expressions of the form Table[Column] return a List type data value that contains the values in Column for ALL records in the entire Table. Most likely, If I’ve referred you to this post, the answer to your question is simply to change it to just: [Column] One of the most common places I’ve seen new app builders use this, is within SELECT() expression, like: SELECT( Table[Col…

[pex]

Thank you for the in-depth explanation!