June 9, 2023 - u/TheMatchaVibe

Hey there,

I was wondering if anyone knew a way to use Notion formulas to check if a number property contains only whole numbers (i.e. no decimal numbers and no negative numbers)?

Quick answer

<aside> <img src="https://prod-files-secure.s3.us-west-2.amazonaws.com/9210293a-6b0f-4638-8e8d-3c40b40ed42b/b8366055-a446-4861-aa67-1e926814ca74/Invisible.png" alt="https://prod-files-secure.s3.us-west-2.amazonaws.com/9210293a-6b0f-4638-8e8d-3c40b40ed42b/b8366055-a446-4861-aa67-1e926814ca74/Invisible.png" width="40px" />

and(empty(mod(prop("Nombre"), 1)), prop("Nombre") >= 0)

not test(prop("Nombre"), "[^\\d]")

not test(prop("Nombre"), "[\\.-]")

</aside>

Nombre entier ≥ 0

By @Ouinx2 - **Buy me a Beer**