Before and After values

Expression ‘([_THISROW_BEFORE].[Owner’s Name])<>([_THISROW_AFTER].[Owner’s Name])’ does not seem to produce the desired result. Can anyone comment please?

As if ([_THISROW_BEFORE].[Column Name])<>([_THISROW_AFTER].[Column Name]) is not working properly through out the application.

Try

[_THISROW_BEFORE].[Column Name]<>[Column Name]

1 Like

That’s the Show_If expression. I don’t think you can use [_THISROW_BEFORE/AFTER] with Show_If.

Usually, [_THISROW_BEFORE/AFTER] is used in Workflow conditions. It checks the values before/after a row edit.

Show_If is used to determine if that column should be displayed.


What is it you’re trying to do?

Do you want to hide the Generate PDF column until there’s a value entered for [Owner's Name]?
If so, try this:
Show_If: ISNOTBLANK([Owner's Name])

Thank you so much. So far it seems to be working fine.

As @GreenFlux correctly advised to you, before/after expression is not gonna work in showif constrain.

[_THISROW_BEFORE].[Column Name])<>([_THISROW_AFTER].[Column Name] , which is basic expression and usage of before/after as trigger condition, which would work in workflow setting, but it is not working in other place such as RESET ON EDIT or somewhere other. In those place where the expression does not do the job, remove [_thisrow_after]. operator, then it becomes workable.

Obviously this is a bug, I have pointed out to Appsheet dev team sometime before, but obviously the problem still persists.

1 Like

Thanks @GreenFlux.

@tsuji_koichi Actually I was just testing [_THISROW_BEFORE/AFTER] as the ‘show_if’ expression because [_THISROW_BEFORE/AFTER] was not working properly as a RESETIF condition.
thanks again you both.

Yeah, logically, it wont work in SHOWIF constrain.

But i hope appsheet team will fix this bug sometime soon.

Will see.

yes it should be corrected as soon as possible. otherwise a lot of time can be wasted in figuring out the root cause.

1 Like

Indeed, yeah, i lost plenty of hours before to find this “trick”…

1 Like

AND
(
[_THISROW_BEFORE].[Owner’s Name]<>[_THISROW_AFTER].[Owner’s Name],
[Generate PDF]=“Yes”
)

Before:
image

After:
image

But:

@tsuji_koichi @GreenFlux