How do I create a dependent dropdown thatโs based on a column's auto-populated App Formula?
My app has a โTasksโ table that auto-populates a [Project Number] column via app formula, like so.
Tasks Table
REF column to Work Order Table | The Project Number is auto-populated via app formula: [Work Order ID].[Project Number] |
|
|
Work Order ID | Project Number | Pay Item Number | Quantity |
A23780 | 23-001 | 252.00 Brick Sidewalk | 125 |
A23780 | 23-001 | 265.00 Concrete Sidewalk | 211 |
I want the [Pay Item Number] column to be a dependent dropdown thatโs based on the auto-populated [Project Number] column.
Hereโs an example of the Pay Items table.
Unique ID | Project Number | Pay Items |
0CC359C0 | 23-001 | 252.00 Brick Sidewalk |
47620E24 | 23-001 | 265.00 Concrete Sidewalk |
8F264CAE | 23-001 | 645.00 Catch Basin |
0A729BF3 | 23-200 | 155.00 Granite Curb |
96058835 | 23-200 | 345.00 Manhole |
3FA49DB0 | 23-200 | 525.00 Light Pole |
So, if Iโm working on Project Number 23-001, only those Pay Items specific to 23-001 will be available.
Iโve tried using SELECT expressions but canโt seem to figure out how to make this work. Any and all guidance is appreciated!
Solved! Go to Solution.
The Valid IF of your "Pay Item Number" column would be set the expression:
SELECT(Pay Items[Pay Item Number], [Project Number] = [_THISROW].[Project Number])
The Valid IF of your "Pay Item Number" column would be set the expression:
SELECT(Pay Items[Pay Item Number], [Project Number] = [_THISROW].[Project Number])
Thank you! Worked perfectly.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |