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

[Test_Birimi]

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

[RezaRaoofi]

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]

@RezaRaoofi

Excellent solution, thank you very much.

[RezaRaoofi]

@Test_Birimi you’re welcome!