Jump to content
  • 0

user changing field value calculated by formula?


humidor

Question

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.

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0
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 :)

Link to comment
Share on other sites

  • 0

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,

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...