Hi, I would like to know how to set a complex condition to delete a record, but that has the following structure to validate the deletion: if ((cond1 and cond2) or (cond3 and cond4)), currently it only allows me to set if cond1 and cond2 and cond3 … and the same if I want to do it with the “or”, but it does not allow me to do a combination of the “and” and the “or”. thanks in advance for the help you can give me.
if-else column do not have that combination, you have to create additional columns to get that logic to work… a little bit of brain exercise
As Uzo mentioned, you would need multiple if-then-else columns.
- First column:
– If not cond1, then empty
– If not cond2, then empty
- Second column:
– If not cond3, then empty
– If not cond4, then empty
- Third column (optional)
– If first column is true, then true
– If second column is true, then true
The 3rd column would be optional, just depends on how it’s being used and personal preference.
Thanks for your comments, but I have already solved it, seeing that the information shown in the tab is per record, so I added other calculated columns to the table with the basic information.