on 2023 Nov 13 1:24 PM
Hi,
I have a table with two manual inputs for "Number of nights" and "Number of days" .
I need a solution to prevent users from putting in numbers in "No of nights" greater than there are in "No of days". Logically, it is impossible to have more nights then days on the report. I was thinking about scripting it with code, however I have no experience with scripting. Any tipis?
With regards,
Patryk Sawicki
Request clarification before answering.
patryksawicki
Scripting is one way of thinking about it. Another could be conditional formatting ( based on another measure) where you can set color ( may be red) where No of days is greater than no of night. Its not going to prevent user from entering the value but it will visually flag it for them to notice.
Br.
Nikhil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
30 | |
9 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.