Hi, I want to make a manual record if condit...

(Test Birimi) #1

Hi,

I want to make a manual record if conditional data records are not required, is this possible? (if and ifs)

Example:

=IF(NOT(OR([Test1]=“abc”, [test1]=“def”)), [temperature]=25, “manuel entry”)

I will enter the manually if the condition is not met

Thanks

(Reza Raoofi) #2

I believe you could do that in two steps:

  1. Use a conditional expression in Editable_If, so only when a particular condition is met it will allow data entry in that column.

  2. Enter an IF() expression in Initial Value, to automatically fill the column’s value with a default you wish for cases that the above condition in step 1 is not met and user is not supposed to do manual entry.

(Test Birimi) #3

@RezaRaoofi

Excellent solution, thank you very much.

(Reza Raoofi) #4

@Test_Birimi you’re welcome!