Share
Report
48Hi everyone,
We're working on a flow which will combine three tables. But it's a bit tricky.
So, we're having three tables.
- Table 1 has 3 columns (column A-B-C)
- Table 2 has 3 columns (columns D-E)
- Table 3 has 2 columns. ( columns F-G)
Column A from table A has the same information as column D from table 2 (lookupfield of values in column D table 2). However, also table 2 has one specific column with information, namely E.
Now, when the user is filling in the form for Table 1, he fills in column A-B-C. This information needs to be linked to 1 row in Table 3, but with added information based on the columns on Table 2.
So, what we need is that when the form is being entered, column F-G are actually a combination of said above table 1 and 2. Namely: column G should be contain information that can be found in column E, based upon what the user filled in the form for column A (which, as mentioned before, is the same value as in column D from table 2).
So in short:
Table 3:
- Column F = filled in information from column A in table 1
- Column G = information found through what's been filled in column A, but the value of the same record from column E in table 2.
So I don't know where to begin on this, any ideas?
All responses (
Answers (
