dfox
Forms Fledgling

Disable Calculated Value on Form

I have a form where I have a Calculated Value that populates based on completion of another column.  It is a checklist list with nearly 70 individual items.

 

dfox_0-1595001198376.png

Once Yes or NA is selected it "date" stamps the Calculated Value in the Completed By On section.  This works perfectly with the exception that each time the form is edited then the date and time on the Calculated Value is updated to show the current date/time/user.

dfox_1-1595001257772.png

Is there a way to disable the calculated value once it the Completed column has been finished?

 

If I disable the Recalculate on edit mode then it stops functioning.

dfox_2-1595002317386.png

I have tried various formatting rules on the Calculated value with no available.

 

Any suggestions?  What am I missing?  Should this be handled differently?

 

Thanks.

Devon

 

 

 

 

 

 

 

0 Kudos
Reply
2 Replies
claudiaurbanski
Design Canvas Artiste

Re: Disable Calculated Value on Form

I would add a single line field behind the calculated value and have the workflow update it once the Form is saved with the calculated value. Then hide the calculated value in Edit form and make the single line read only.

0 Kudos
Reply
dfox
Forms Fledgling

Re: Disable Calculated Value on Form

Thanks for the suggestion.  I was trying to avoid having to do this in workflow, but may need to consider it.  There are nearly 70 items to this checklist so I was hoping to make the form do the work for me rather then a lengthy workflow.  I was hoping I was just missing something.

 

Thanks again!!

0 Kudos
Reply