Show_If expressions

Muhammad_Hamada · 01-16-2021 05:31 AM

Column ‘Category’ is of type ‘enum’. Values for this column are “apartment”, “house”, “shop”, “office”, “residential” and “commercial”.

“Street No.” should be visible if ‘category’ is “apartment”, “house”, “shop”, “office”, “residential plot (Balloted)” or “commercial plot (Balloted)”.

Column ‘Plot Allocation’ of enum type should only be visible if ‘category’ is ‘residential plot’ or ‘commercial plot’. Plot allocation has values “Balloted” and “Un-balloted”.
If “Un-Balloted” is selected column “street no” should not be visible.

The problem arises when a user selects “residential” or “commercial” and further selects “un-balloted” but then changes mind and selects “apartment”, “house”, “shop” or “office”. In this case “street no” is no more visible even now the category is “apartment”, “house”, “shop”, “office”.

LeventK

Try with turning on RESET ON EDIT for each column and see if this behaves differently.

Muhammad_Hamada

I used ‘reset on edit’ condition for the column ‘plot allocation’ to reset it to a blank value using “” as it’s initial value. The condition for ‘reset on edit’ was:
OR
(
([Category] = “Shop”), ([Category] = “Apartment”),([Category] = “House”),([Category] = “Office”)
)

LeventK

Just turn on RESET ON EDIT, don’t use any expression.

Muhammad_Hamada

Tried what you just said but the problem persists, as expected.
Actually I am talking about the scenario where the user changes the value of “category” before pressing the “save” button of the form.
As far as I know ‘Reset on edit’ works when a row is edited.

LeventK

You’re right. I though you are editing an existing record, not creating a new row.

Steve

Plot Allocation

Valid if

IN(
  [category],
  LIST(
    "residential plot",
    "commercial plot"
  )
)

Editable?

OR(
  IN(
    [category],
    LIST(
      "residential plot",
      "commercial plot"
    )
  ),
  ISNOTBLANK([_THIS])
)

Required?

IN(
  [category],
  LIST(
    "residential plot",
    "commercial plot"
  )
)

Street No.

Valid if

NOT(
  AND(
    IN(
      [category],
      LIST(
        "residential plot",
        "commercial plot"
      )
    ),
    ("Un-Balloted" = [Plot Allocation])
  )
)

Editable?

OR(
  IN(
    [category],
    LIST(
      "apartment",
      "house",
      "shop",
      "office"
    )
  ),
  AND(
    IN(
      [category],
      LIST(
        "residential plot",
        "commercial plot"
      )
    ),
    ("Balloted" = [Plot Allocation])
  ),
  ISNOTBLANK([_THIS])
)

Muhammad_Hamada

Moreover, when I initially select ‘category’ other than ‘Residential(Un-Balloted)’ or 'Commercial(Un-Balloted), I am unable to edit ‘Street No.’ if I try to change the category to other than ‘Residential(Un-Balloted)’ or ‘Commercial(Un-Balloted)’ as shown below:

Unable to upload a ‘gif’ !

Basically, an ‘un-balloted plot’ cannot have a 'street no. ’ and ‘plot no.’

@Steve

Muhammad_Hamada

But when I use the above expression I get the following:

Whereas, the following should be shown:

@Steve