In the same principle as the conditional select (list of another table), the conditional text is a column whose fields are formatted to receive the entry of a column of a selected table, automatically.
To use this function in a table, the table must already have a column of type Select (list from another table).
A Conditional Text column will allow you to create a second level of condition. Based on a column of type Select column, you will have the choice of an existing column on which the Selection column is based.
I first select my column of Selection type , then the column of the table from which I want to retrieve data.
Then, after validating, the conditional text field is filled with the data of the Status column compared to the values of the Selection column.