Problem with edit mode and calculating fields

@car17 .....can you provide more details on what exactly you're trying to achieve here?

I am creating a form and currently I have two calculated fields for Date and Username. I am trying to update the name and date only when the "Completed" yes/no box is equal to true. The problem I have is when I edit the document again it will update the LAN ID and Date again with my name. I have quite alot of calculated fields that still need to be recalculated in edit mode but was hoping there was a way to prevent it recalculating through Javascript or a workflow?

@car17 ...In this case why don't you use 2 calculated field for each date and username?

1. First pair will calculates date and username in all 3 views
2. For second pair do the following:
   1. Don't calculate in any views
   2. Using If statement fill the values i.e. If check box is checked then use date and username from above pair or else leave blank.
   3. The only cavaier is if someone checks and un-check the box then it might re-calculate so maybe u can use some logic to make sure it's checked once or what ever is your process

@kunalpatel 

I've taken your idea and tried:

• Added two calculated values that recalculate in all 3 views
  • CurrentUser - userProfileLookup(Current User, "PreferredName")
  • CurrentDate - formatDate(Current Date, "dd/MM/yyyy"

• I've then unticked recalculate on all 3 views for the following Dates and UserName value fields and used if formulas for selection of the "completed" tickbox and they won't run.
• The if statement used for the:
  • Dates - If(not(BMok1 == "") , CurrentDate , "")
  • Username - If(not(BMok1== ""), CurrentUser , "")
• If recalculate is turned on the formulas work but I need this to run on multiple different versions of the documents as there will be multiple users working on the document as there are 7 sections with a total of 98 questions for all levels of the process.
• Just to cover off all points for #3 I have rules to disable the complete box once the section has been signed off by a manager.

@car17 .....Could you please tell us:

1. How you decide for which users the field needs to be updated?
2. Is this in a repeating section or in sepearate panels? Since we don't know the exact form design it's little confusing !!!

@kunalpatel 

The form concept is for a checklist. Whenever the user has completed a tick section (the completed tick box) it will populate with their name and date for audit purposes. It is within a panel.

This checklist will be used by quite alot of different users accross different departments, happy to attach the form in a secured place for you to have a look at so you can understand.

@car17 .....Your form has different sections (panels) and when each section is complete you need some kind of acknowledgement and for each section you have different acknowledgement, am I correct?

Assuming your answer is yes, then for each section you're using a check box, instead of getting current user and date in calculated field why don't you run a workflow which will trigger conditionally i.e. if the check box is checked yes and get the date and time when workflow is executed or you can use modified date and time, and get who modified the item and using build string update the field where you want to add entry for audit. Instead of overwriting in build string, I'll also include item property of that item to append. After updating the column for audit, reset the check box for other user(s).

If my above assumption is wrong then could you please tell me the complete process so that I can understand your exact requirement?

@kunalpatel I will try this now.

There are 45 checkboxes in the form. Is the best practice to have a workflow with all 45 checkboxes to populate:

1. Two calculated fields
2. A date field and a Single line of Text field

on the condition Tickbox == true? 

@car17 ...only 1 user can modify and save the changes at any given time.....considering this, do you really need your users to check respective check boxes multiple time, can't you just put a panel called acknowledgement and put a statement "I <current user's name> understand these changes made and I acknowledges it......."?

@kunalpatel ... This unfortunately is something we're unable to do, each item needs to be recorded for reporting purposes with our time management software.

I need to have each individual section, whom and when completed to be stamped. I have a concept now that works from your recommendatios which is great!

For the build string item is there a way you can get only the date (not the time) and remove the "i:0#.w|ent""

@kunalpatel ... memory blank I worked this out now - thanks for your patiences.

@car17 ....In calculated control there is a function called format date (use MM/dd/yyyy) and for user you can use userprofilelookup function to get preferred name.