I have tried alot of different methods to ammend this but nothing seems to work unfortunately.
The problem being faced is that alot of my fields are calculated based upon tick boxes to return the date and a users prefered name, all of these are fine:
The items are ticked "Recalculate formula on new mode" and "Recalculate formula on edit mode".
This unfortuantely leaves me in a dilemma as I would like for certain fields in the form to be calculated later on as these forms will be loaded over the course of a few weeks and by multiple different users but their names and dates keep updating as a result of the rule being "not(Workflow == "")".
Is there anyway to prevent the rule depending on "Previous Value" or only if the true false status on a check box changes?
Thanks in advance.
@car17 ...In this case why don't you use 2 calculated field for each date and username?
I've taken your idea and tried:
@car17 .....Could you please tell us:
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:
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......."?