Hi All,My requirement is to effect the changes that are made to the newly created documents only.Old docs should not effect with the changes.For that i have created a field ‘Date’ with Computed when composed type and given a value as ‘06\22\2015’
and the section or text hidden formula is (@Created>Date).Is this formula correct.Does it work accurately.Can anyone suggest ?
Subject: Changes apply for new documents
Did you try it and see if it worked? We’re developers…we live on the edge, we throw caution to the wind and just do stuff!
So you’re adding some new design element to a form and you want it to show up only on docs added after . It sounds like you’re adding a section to the form.
If that’s about right, you don’t need to add a field with the date (adding a computed when composed field with a fixed date is a bit redundant, just make it computed and set the date). And you don’t actually need the date, just change your hide/when formula to @Created > @Date(…).
You’ll also want to make sure that any fields in the section don’t have values that compute to some value (hidden fields still exist on forms) otherwise they could show up in views or when you run agents and give you unexpected results.
Subject: RE: Changes apply for new documents
Hi Finner,Thank you for your suggestion.Actually,i need this fuctinality not to be effected to existing old documents.This change should be applicable to only newly created documents.For that i have created a field 'Date ’ with comuted as composed and given the default value as ‘06/21/2015’. I need entire table to be hidden for existing documents,so i am writing hiden when formula for the entire table(@Created<Date).So it should hide the nwly implemented chnges for old documnets.I tested ,but its not working.I tried the way you have suggested.But it toodidnt work as well.
Subject: What do you mean ‘didn’t work’?
Are you saying that your hide/when formula isn’t working?
Do your old docs A) Have the field ‘Date’ in them and B) Have it set?
My point is you don’t need the ‘date’ field in your hide when, just set the hide/when to be @Create < @Date(WhateverDateYouWantHere), that way you don’t need to run an agent to set Date = yourDate.
Subject: RE: What do you mean ‘didn’t work’?
Hi Finner,Sorry for asking for more clarity in that as iam new to this technology.I have a field called ‘CreationDate’ in my old docs.Now for hiding the new changes in the old docs,iam writing the hide when formula as @create<CreationDate(06/23/2015).Is my understanding correct?I have tried that way.But iam getting error.Can you please where i should give the date value?
I have tried the other way as well,i created a field ‘Date’,given a default value and given the hide when as CreationDate<Date.
Subject: RE: What do you mean ‘didn’t work’?
Hi Finner,I got the solution.Thank you very much buddy for your help.
Subject: And your solution would be…
What?
It’s kind of good form to close out a thread with the fix to the problem so others can learn.
Subject: RE: And your solution would be…
I will follow that from now…Sorry for not providing the solution.I have a field called ‘Created’ field in my old documents.I have written a hide when formula saying that @if(@Created<@Date(2015;6;15)).By specifying the formula i was able to hide my new content in old documents.
Subject: You mean…
Notice the bit about using @Date(…)…
Glad you got it working and thanks for posting your final solution. These forums are for helping others; when you learn something new, let people know. If an offered solution works, thank the person for helping.
Subject: RE: You mean…
Hi Finner,The solution that i have tried has worked.But when i was testing the old documents,its promting to enter validation for newly added fields which are hidden.How can i restrict that?Can you please give an idea abou that?How should i add a condition for that not to prompt?