Script or soultion to allow data input on condition.

[patryksawicki]

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

[N1kh1l]

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