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

(Test Birimi) #1


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


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

I will enter the manually if the condition is not met


(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


Excellent solution, thank you very much.

(Reza Raoofi) #4

@Test_Birimi you’re welcome!