This Blog is about the Combo Box and an alternative way to set them up. We will build or solution from inside to outside and I will guide you step by step through the process.
Step 1 - Filter() The first step is to use the Filter() formula to be able to filter out data source. Here we use a trick which we use a lot in T-SQL to get a first true condition. The formula is like this:
, 1 = 1 // This part is always true
The 1 = 1 is equal to true, which helps us to make a wrapper formula without declaring existing conditions and makes it easy in the future to preform test (for example comment out parts of the filter conditions)
Step 2 - AddColumns() For the second part of our wrapper we take a closer look at the options of the ComboBox. As a option we can pick Single, Double and Person ComboBox, we will build our wrapper on the option with the most features but in a way that it is suitable for all the options. We will use AddColumns() formula to do so. Nice about the AddColumns() formula is that it makes it possible to manipulate the display and output values of our ComboBox, for example we can do a concatenation on the FirstName and SurName columns from the persons in our wrapper function. The formula become like this: