I would like to know how to set a complex condition to delete a record

Help & How To
#1

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.

#2

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 :wink:

#3

As Uzo mentioned, you would need multiple if-then-else columns.

  • First column:
    – If not cond1, then empty
    – If not cond2, then empty
    – Else true
  • Second column:
    – If not cond3, then empty
    – If not cond4, then empty
    – Else true
  • 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.

2 Likes
#4

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.