[TIPS] How to check if filter result is null or vacant

 [TIPS] How to check if filter result is null or vacant

Use "IsBlank" to check if got nothing after filtering.

For example,

If(IsBlank( First(Filter('Daily Notes', Date = Today()))), 
      NewForm(fm_Note), 
      EditForm(fm_Note))

No comments:

Post a Comment