Message for user every 10 registres [COUNT?]

ezuh
New Member

Hello there,

I am creating an app for people access control.

My intention is that after several registrations (for example, every 10 accesses) a message will appear indicating that a Backpack Registration must be carried out.

How could I do it? I had thought of putting a column A, with the record message and that it only appears when it counts 10 records. And then go back into hiding until the next 10. Is it possible? Do you know better in any way?

Thank you very much

Solved Solved
0 4 196
1 ACCEPTED SOLUTION

Correct! I am new and also have no knowledge of code.

I have finally been able to do it thanks to your formula. I have created a virtual column called [reset_rownumber] with the formula

MOD ([_ ROWNUMBER], 10)

And it restarts every time 10 times. Then I have set in the warning message to SHOW_IF

[reset_rownumber] = 1

Thank you very much for your help!

View solution in original post

4 REPLIES 4
Top Labels in this Space