Action Only If Condition not taking effect

AppSheet AppSheet Q&A
1

I have a create record action with the below only if condition. When I test the expression in a virtual column without the NOT() it returns Y (OR true) meaning the queried data has been found in the table as expected. I want the action to trigger only if the data is NOT in the table so I added the NOT() but it doesn’t respond and continues to create records. This after over 10 variations of the expression. Does anyone have any ideas?

image
image1379×647 34.6 KB

NOT(
IN(
[_THISROW].[route_source_key],
SELECT(
Route References[route_source_key],
AND(
[route_source_key]=[_THISROW].[route_source_key],
[image_source]=“Site Not Serviced”,
[image]=[_THISROW].[missed_image]
)
)
)
)

2

This row will always have the value you’re looking for, so SELECT() should only target rows that aren’t this row. “What other rows have this route source key?”

NOT(
  IN(
    [route_source_key],
    SELECT(
      Route References[route_source_key],
      AND(
        [route_source_key]=[_THISROW].[route_source_key],
        [_ROWNUMBER] <> [_THISROW].[_ROWNUMBER],
        [image_source]=“Site Not Serviced”,
        [image]=[_THISROW].[missed_image]
      )
    )
  )
)
3

Thanks Steve, I updated the expression and added [_ROWNUMBER] <> [_THISROW].[_ROWNUMBER],and no luck - it still creates the record

4

Hi @Daisy_Ramirez

Do you mean like this?.

20260221_073022
20260221_0730221280×637 99.3 KB

If yes . I use VALID IF with this formula :

LOOKUP([_THISROW].[NO REFF],“PAYMENT”,“NO REFF”,“PAYMENT STATUS”)<>“PAID”

then in the invalid value error section fill in according to “Paid”.

You can adjust it to your data for the formula.

5

How about this one then?

COUNT(FILTER("Route References", AND([route_source_key] = [_THISROW].[route_source_key], [image_source] = “Site Not Serviced”, [image] = [_THISROW].[missed_image]))) = 0

6

If you REMOVE the NOT() in your expression, is the row NOT written in that use case or is it duplicated? If it still is written or you get dup rows, then that means something else is adding rows. In the case of dup rows, it means your expression is actually working but something else is also adding rows.

If above does not identify anything new, I see nothing wrong with this expression. Since you have tried 10 different variations (and we know you have been building apps for a long while now and know what you’re doing), It is likely NOT the expression that is the problem.

Double check the logic you are using and inspect the physical data.

For example, does [image_source] have any extra spaces in it? Is “Site Not Serviced” spelled exactly the same? How is [route_source_key] being assigned - anything that might change as the app runs?

Image columns record the path to the image - make sure [image] and [missed_image] are recording identical paths in the column raw data.

I hope this helps!

7

ISBLANK(
SELECT(
Route References[route_source_key],
AND(
[route_source_key] = [_THISROW].[route_source_key],
[image_source] = “Site Not Serviced”,
[image] = [_THISROW].[missed_image]
)
)
)

8

Thanks for the ideas everyone, we’re missing a key parameter in the table to accomplish this as the client requests so we’re rethinking the functionality. Again thanks for the help!

9

Hi @Daisy_Ramirez

Is your goal to display the image, if the condition does not match, if yes, in the image column [missed_image] in SHOW IF use the formula example [category]= “your criteria that you want”. so just give the formula to show if. Likewise on the button enum (stack) you can use show if to show and hide.

But it is different if [category] = “check out” two buttons appear while if [category] <> “check out” three buttons appear. of course not in show if but in VALID IF, for example the formula IF ([category] = “check out”, LIST (“BUTON_A”,“BUTTON_B”), LIST (“BUTON_A”,“BUTTON_B”,“BUTTON_C”)). delete the value and check list allow of.

Hopefully this can help you

10

I noticed that if an expression is using a VC value coming from a read only table,or a rarely refreshed table (delta sync,server cahed,and those other appsheet options activated), the value is usually wrong or not updated.

Also the values in this cases in the emulator and app are many times different.

I try not to use VC from read only or server cahed tables. And if I have to, i make for the moment the table writable, disable all those cache options, make a manual change in the table to change the last update timestamp, set my expression than put it all back as it was.

11

True!