You’re offline. This is a read only version of the page.
194
Hi All,
I have a combobox that points to an on prem sql database table and I need to, as part of the lookup filter where the column = NULL.
What is the syntax? I've tried the following:
Share
Reportcolumn = "Null"
column = "NULL"
column = null (gives error)
column = Blank()
Edit to clarify, what i'm fully trying to do is have comboboxes to filter down some choices in a lookup table in SQL. So the first combobox shows the type options, from there based on what they select the next combobox should now show me a list of make of that type. However some of them are null and if that is the case i want to hide the combobox and just have an open text field to type in.
The combobox visibility is what i'm trying to do, i want it to show if the first combobox selected does not have a null value for the 'make' column, otherwise hide this combobox:
Visibility =
If(IsBlank(LookUp(Inv_Equipment_Type, EquipmentTypeID = First(Filter(Inv_Equipment_Type, EquipmentType = ComboBox1_1.Selected.Value)).EquipmentTypeID && Make = "Null")), false, true)Essentially if there is no make to choose from hide it so i can give you the open text to type it in, otherwise show it so you can select from the make in the database.
Thanks.
For anyone reading, I figured it out, you have to do IsBlank(COLUMNNAME). Once I changed my code to IsBlank(make) it worked!!!
All responses (
Answers (
