user changing field value calculated by formula?

[humidor]

If I have fields setup to calculate based on a formula, is there a way to allow the field value to be overridden by a user? For example I may have a field where a default date is calculated by formula based on a submitted date. But I would like to allow users to be able to change that date if needed.

[Mathilda]

46 minutes ago, humidor said:

If I have fields setup to calculate based on a formula, is there a way to allow the field value to be overridden by a user? For example I may have a field where a default date is calculated by formula based on a submitted date. But I would like to allow users to be able to change that date if needed.

Formula field cannot be edited because value is calculated using other fields. However you may use the following workaround.

Add a separate field where customer will be able to enter preferable date and update your formula with additional condition, like 

CASE 
WHEN Len([@field:customer_date])>0
THEN [@field:customer_date]
ELSE write your formula
END

Insert your current formula instead of "write your formula"

Cheers

[humidor]

OK great. There is no way though, on the initial form/data page to see the dates (read only) that are calculated though? so the user can decide if they want to enter a preferable date into the separate field?

[BaySunshine]

Hello humidor,

Yes, you can do this by following the steps below:

1. Make the formula field as 'display only'.

2. Add a virtual field of checkbox type.

3. Use 'Rules' to hide the separate field based on the value of a checkbox.

4. If the user chooses to change the date, they enable the checkbox and the separate field shows up.

5. User can enter the data and hit 'Submit'.

Hope this helps.

Regards,