Hi All,Iam writing a hide when formula for my new changes that are done on my form not to be shown in old documents that have been created by the same form.I have a field called ‘Created’ in my documents.So as i have tried using @if(Created<@Date(2015;06;12).This is working fine now.Here i just dont want to hard code my date value.So i have created a keyword doc and by using lookup iam fetching that key value.Can i use @Dbllokup in hide when ?
I am trying in this way…X=@Dblookup(“”;“”------).Iam getting the value in to ‘X’.and i have appended one more formula in the hide when --@created<@Date(X).
My hide when is not working.Am i doing anything wrong?Can anyone suggest?
Subject: How to write the hide when formula
Look at the help for @Date.Are you feeding ‘x’ in as the proper set of values (year;month;day or [dateValue]) or are you just dropping in the string you get from the date lookup?
Read the help
Practice with a sample field on a form to make sure you understand how it works and don’t try to do the hide when until you can prove to yourself that you understand how to convert your lookup into a date.
FYI, I’m not giving you a full solution because it really helps to work through the design on your own. You may also want to start your own ‘tips’ database so you can keep track of lessons learned. Mine has saved me hours of debugging…
Subject: Also…please stop…
Please stop posting the same question 15 times - this adds to clutter in the forum and doesn’t help anybody. I appreciate your desire to solve your problem but just repeating the same question 10 times is really not helpful to you (people will start ignoring your posts) or the forum.
Subject: RE: Also…please stop…
Hi Finner,Sorry for that. At the last moment my requirement has been changed and I was trying solution for that but couldn’t get through… So I have to post with a new requirement.
I have a field ‘created’ in my docs. Earlier while writing the hide when I have written as @if(created< @date(2015;6;26). Now Iam creating a keyword document for the date instead of harcoding the value. For that I have created a hidden field ‘Test’ of type text and computed when composed field. I have written lookup to fetch the value of ‘Test’ from keyword document. The value is ‘2015;06;28’. My formula for hide when is written as ‘@if(created<@Date(Test))’. Iam getting error as incorrect datatype date/ time expected. I tried changing my hidden field to type date/time and executed. But no result. So I have to repost this as a new thread.
Subject: Doug is right
People will start to ignore you when you basically post the same question multiple times.
Subject: RE: Also…please stop…
“So I have to post with a new requirement.”“So I have to repost this as a new thread.”
No, you could have continued the same thread, as it (for all purposes) is the same question.
And as a programmer you must be able to take partial solutions and build on top of that yourself. This is not a forum for others to write all the code for you exactly the way you need it in your application, it is to ask for help or tips.
It seems like you are new to Notes/Domino. I suggest that (if you have a hard time using the online help to learn the development platform) to take a course in Notes development. That will help. If you have an actual programming background you should learn it quickly.