Share
Report
38Hi All,
I have a form with 6 data cards, three of these data cars are dates with the following titles: DateIMClar1, DateIMClar2 & DateIMClar3 which we will call Form 2.
I also have another form where you can amend various bits of data which will we call Form 1, from Form 1 you can click a button which takes you to Form 2.
So, what I need is when I amend the Status in Form 1 to IM clarification, I need the column DateIMClar 1 to amend to the date that it is amended, if for whatever reason the status changes to another status and is then changed back to IM Clarification, I need the DateIMClar 2 to amend to the date it is changed back to IM Clarification and again the same for DateIMClar 3.
I have figured how to do this for the first Data card DateIMClar 1 by using the following formula If(And(IsBlank(ThisItem.DateIMClar1), ThisItem.Status.Value="IM Clarification"), Today(),Parent.Default).
I have tried doing something similar for the others, but they change date when it is first changed which is not what I want. I am just wondering how to approach this, perhaps setting a variable which changes when I amend the IM clarification status, not sure how that would work though or some condition which would block the DateIMClar2 and DateIMClar3 from amending when it is first changed for the former and changed the second time for the latter.
Any help with this would be greatly appreciated!
All responses (
Answers (
