cancel
Showing results for 
Search instead for 
Did you mean: 

Script or soultion to allow data input on condition.

patryksawicki
Member
0 Kudos
165

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

Accepted Solutions (0)

Answers (1)

Answers (1)

N1kh1l
Active Contributor
0 Kudos

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