Solved: Problem Condition IF - Page 2

Francisco1988 · 05-19-2022 10:32 AM

Case:
In my form I have a problem in 3 fields Start Date, End Date and Request Status. 
In the Start Date and End Date fields, there are the following formulas:

Initial Value formula for column Start Date (Date)
IF([Request Status] = In Progress, TODAY(), "")
Initial Value formula for column Data Termination (Date)
IF([Request Status] = Delivered, TODAY(), "")

The Start Date and End Date fields depend on the current state of the Request Status field. 
The Request Status field is of type Enum and contains the following values: “In Progress”, “Delivered”, “To Deliver”.

Problem:
When changing the Request Status field to “Delivered” if the Start Date is filled in, 
the value contained in this field is deleted. The same happens when changing 
the Request Status field to “In Progress”, the value contained in the 
“Termino” field is deleted. It also occurs when changing the 
Request Status field to “To Deliver” values contained in the Start Date and End Date fields are deleted.
I need that once the value entered in the Start Date and End Date fields is no longer changed

Francisco1988

Case:
In my form I have a problem in 3 fields Start Date, End Date and Request Status.
In the Start Data and Term Data fields, there are the following formulas:

Starting value formula for a starting data column (date)
IF([Request Status] = In Progress, TODAY(), "")
Initial value formula for a Data Term (Data) column
IF([Request Status] = Delivered, TODAY(), "")

The Start Date and End Date fields of the Request Status field's current state.
The Request Status field is of type Enum and contains the following values: “In Progress”, “Delivered”, “To Deliver”.

No Reset field in built-in edit
ISBLANK([_THIS])

Problem:
Allows you to edit the Start and End Date fields by the Request Date field only on the first form insertion.
In case of updating the form in the Start Date and End Date fields, it is necessary to edit them manually.
How do I make this edit automatically continue on the Request Date field?

View solution in original post