Question Re: Script or soultion to allow data input on condition. in Technology Q&A

Script or soultion to allow data input on condition.

patryksawicki — Mon, 13 Nov 2023 13:24:44 GMT

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

Re: Script or soultion to allow data input on condition.

N1kh1l — Mon, 13 Nov 2023 13:57:33 GMT

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