I am currently trying to solve a supposedly very simple problem, but unfortunately I can’t get any further.
I have a table A with my suppliers and in this table I have a column ‘Active’. This column has the type ‘Checkbox’. This means that it returns the values ‘True()’ or ‘False()’ when evaluated.
If I create a formula within table A and evaluate the checkbox (for example within an ‘If function’), the evaluation works.
Now I have a table B and in this table I have linked the entries of table A. Only one entry from table A may be entered in a row of table B in the link. I can use ‘Look-Up’ to display the ‘Active’ column from table A in table B. Everything works so far.
However, if I want to evaluate the value of the table B column for ‘Active’ in table B, I get the error ‘Inconsistent data type’. When I check the data type in table B, ‘Checkbox Array’ is displayed. This means that the data type ‘Checkbox’ is not transferred 1:1 to table B and (probably?) generates the error.
Is there a solution so that I can correctly evaluate a checkbox (true/false) information from a table A in another table B?
Thank you very much for your answer.
I understood the answer to mean that I should already insert an evaluation column in table A. With this column I get a ‘conversion’ of the checkbox into a boolean value. I now have an additional column ‘Evaluation’ in table A and this shows either ‘True’ or ‘False’ depending on the checkbox setting.
If I transfer this evaluation column to table B using the look-up, ‘Boolean value array’ is displayed as the data type.
Unfortunately, I cannot use this transferred Boolean value in formulas in table B because ‘inconsistent data type’ is displayed. But I need the evaluation in table B to use the ‘Yes/No’ decision in other formulas in table B. These analyses cannot be performed in table A, partly because checkboxes are also used in table B. As far as I could see during testing, each data type from table A is converted into the corresponding array type during lookup or insertion by formula and is therefore not usable for further formulas. Is this correct?
Have I not understood the proposed solution correctly?
Thank you for showing the screenshots with the formulas. The problem was actually in the syntax!
As you can see in the screenshots, the syntax is true() in table 1 and ‘True’ in table 2. This was not clear to me. I assumed that a query for Boolean values must always be entered in the syntax true() or false().
By using ‘True’ for a look-up column in table 2, the formula works as intended and without an error message.