Forum Discussion
ChristineWhite
4 years agoQrew Assistant Captain
Also wondering if there might be a way to build a look up table that can act as a filter to display the allowable choices
------------------------------
Christine White
------------------------------
------------------------------
Christine White
------------------------------
MichaelTamoush
4 years agoQrew Captain
I feel like there must be a better way than this, but I think this would work:
You have 1 table with all choices, I'll call it 'Selection' Table. Two fields: 'Letter' and 'Scenario'.
In the selection table, you have A, B, C, D as records, but multiple times.
A list of records would look like this: (Field 1 / Field 2)
1) A / Scenario 1
2) A / Scenario 2
3) A / Scenario 3
4) B / Scenario 1
5) B / Scenario 2
etc....
In your main table you make two formula fields called 'Scenario for Choice 3' and 'Scenario for Choice 4'.
You set up if then statements in those formulas (If choice 1 = A, and Choice 2 = B, "Scenario 1", etc)
The first 2 choices can be simple dropdowns with only A and B as options (or you can make them relationships with filters if you really want, no real reason besides consistency in what the fields look like to the user...which might be nice)
The second 2 choices will each have their own relationship, with their own conditional rule. (Where the value in this table:Scenario for choice 3 = value in foreign table, scenario).
------------------------------
Mike Tamoush
------------------------------
You have 1 table with all choices, I'll call it 'Selection' Table. Two fields: 'Letter' and 'Scenario'.
In the selection table, you have A, B, C, D as records, but multiple times.
A list of records would look like this: (Field 1 / Field 2)
1) A / Scenario 1
2) A / Scenario 2
3) A / Scenario 3
4) B / Scenario 1
5) B / Scenario 2
etc....
In your main table you make two formula fields called 'Scenario for Choice 3' and 'Scenario for Choice 4'.
You set up if then statements in those formulas (If choice 1 = A, and Choice 2 = B, "Scenario 1", etc)
The first 2 choices can be simple dropdowns with only A and B as options (or you can make them relationships with filters if you really want, no real reason besides consistency in what the fields look like to the user...which might be nice)
The second 2 choices will each have their own relationship, with their own conditional rule. (Where the value in this table:Scenario for choice 3 = value in foreign table, scenario).
------------------------------
Mike Tamoush
------------------------------