How do I...?

'unlock' a calculated field?

I have a date calculate field that needs to be manually changed every now and then, maybe 1 in 10 records don't follow the pattern and need a custom date.

I used the term 'unlock' because there is a small padlock in the top right corner of the box (image attached if you don't know what I'm talking about) so I am hoping there is a way to 'unlock' the field so that I can manually change the date.

If you need anymore information let me know.

6 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
J Lupin shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • J Lupin commented  ·   ·  Flag as inappropriate

    Hi Alex,

    Not sure how to respond on here but thats for the speedy reply.

    I've had a look through the link you gave and it was very useful but still struggling to get what I need.

    My current formula in my Calculated Data field is something along the lines of -

    If([{Type}="Kitchen", {Date Due Kitchen}, If({Type}="Bath", {Date Due Bath}, ""))

    I tried using coalesce but I feel like I am using it wrong as I can't get it to work, any advice would be greatly appreciated.

  • Alex commented  ·   ·  Flag as inappropriate

    Hi J,

    It is not possible to unlock calculated fields for manual manipulation. If you need a custom date field, add a new date field to your table that can then act as an override to the calculation.

    For example, you can use the coalesce function to reference your override before running the logic that is currently being output by your calculation:

    coalesce({Override Date Field}, [current calculation here])
    Additional information in this function can be found in the Knowledge Base here: https://help.trackvia.com/knowledgebase/articles/243464-how-to-use-calculated-fields-and-formulas

    Regards,

    Alex

Feedback and Knowledge Base