Show if: Field in latest record on another table with matching ID is blank

AppSheet AppSheet Q&A
1

I’m getting a little confused with the documentation and how to use all the commands together to reach this conclusion. can anyone help?

In the Show If I just want to check if the time field of the last (newest) record on a different table containing their ID is blank.

any help would be appreciated, thanks.

2

Please try below

  1. Create a slice called say “LastRow_Time” on the “Other Table” with a slice filter expression something like [Other Table Key Column]= MAXROW("Other Table, “_ROWNUMBER”)

  2. In the show_if of the column, please try

ISBLANK(LastRow_Time[Time Column in the other table])

Please replace table, column names with the actual column names you have. Please note this approach could once in a while fail in a multi user environment, if two users add rows to the other table simultaneously.