Computed for Display? Not Always...
Category Development
I don't know if it has always been like this or if something changed in the Notes Client, I'm using 8.0.2, but I had a pretty frustrating couple of hours working with Computed for Display (CFD) fields of all things.
I was pretty much minding my own business and adding some CFD's to do some calculations like difference and percent difference, and when I would look at the form with data in it, my expected results did NOT appear. Ok, these were in a table and the cells must have been hidden right? Wrong. Nothing was hidden they just wouldn't display. I added text around the fields and saw the text - but not the field. I moved the field around on the form and that didn't fix it either. I was pulling my hair out. Then I tried renaming the field from "pct_ob_revenue" to pctOBrevenue and all of a sudden it displayed!?! At first I thought that there might be an issue with the underscore. I've seen Notes try and "drop" underscores before in view names and whatnot. But interestingly it wasn't the underscore in the field name.
The problem was that somehow there was an existing field in the saved backend document with the same name that I was trying to use. The field existed but there was no value in the field.
It appears that if there's a field in the backend document with the same name as the computed for display field then the client will IGNORE the formula in the CFD field and simply display the value in the backend document. OUCH! I don't know if that's a bug or not but I would think that could cause some problems if there's a way to get around formula calculation...
Anyway - I've never stumbled on this before so I wanted to pass this along.
I don't know if it has always been like this or if something changed in the Notes Client, I'm using 8.0.2, but I had a pretty frustrating couple of hours working with Computed for Display (CFD) fields of all things.
I was pretty much minding my own business and adding some CFD's to do some calculations like difference and percent difference, and when I would look at the form with data in it, my expected results did NOT appear. Ok, these were in a table and the cells must have been hidden right? Wrong. Nothing was hidden they just wouldn't display. I added text around the fields and saw the text - but not the field. I moved the field around on the form and that didn't fix it either. I was pulling my hair out. Then I tried renaming the field from "pct_ob_revenue" to pctOBrevenue and all of a sudden it displayed!?! At first I thought that there might be an issue with the underscore. I've seen Notes try and "drop" underscores before in view names and whatnot. But interestingly it wasn't the underscore in the field name.
The problem was that somehow there was an existing field in the saved backend document with the same name that I was trying to use. The field existed but there was no value in the field.
It appears that if there's a field in the backend document with the same name as the computed for display field then the client will IGNORE the formula in the CFD field and simply display the value in the backend document. OUCH! I don't know if that's a bug or not but I would think that could cause some problems if there's a way to get around formula calculation...
Anyway - I've never stumbled on this before so I wanted to pass this along.
- 


Comments
I wasn't really converting existing computed fields... I created a bunch of new fields on a form and initially didn't set them all to CFD. Then as I was testing, the values got saved in my test document and the rest was history.
I can't believe this isn't a bigger issue... I would just think there could be some security issues what with the availability of the all purpose smart icon's that can change fields on the backend document... I'd think that the savvy user being able to "override" computed for display fields could have some fun... Who would even think to "validate" CFD fields in query save...
Oh well...
I've seen the Ytria stuff. Looks cool. I really want to get the ActionBar one to help me mass change the look over various form and view action bars.... I'm going to Lotusphere this year (first time) and hope they have a booth there to see all that they offer.
Thanks for the information!
Posted by David Leedy At 08:03:11 AM On 12/03/2008 | - Website - |
Posted by Kevin S Pettitt At 05:51:11 PM On 12/03/2008 | - Website - |
"Gee, these fields here are listed as computed but we really don't need to store these values in the backend and take up all the extra disk space. I'll just flip them to CFD and pat myself on the back."
Of course, this only gets noticed when the resulting value is something that's likely to change over time on a document that predated this stroke of genius.
So, for the record, if anyone reading this ever gets it in their head to try a stunt like this after an application has been used to create real production data, please finish the job by cleaning up the existing documents. A little cleanup agent like:
FIELD xyz := @Deletefield;
FIELD abc := @Deletefield;
will work, but I would highly recommend Ytria's ScanEZ tool { Link } because:
1) It will quickly highlight fields that exist on only some documents (use the "Diff" function), which is a red flag for fields that might have flipped to CFD at some point (especially helpful for cleaning up the "previous developer's" mistakes where no one remembers what fields were involved).
2) You can delete a given field out of an entire collection of documents quickly and without writing yet another throwaway agent.
3) et. al. [too tired to think of more reasons right now, but I'm sure there are more]
And since this already sounds like a commercial, I might as well mention that you can get a 10% discount (and yes earn me a small commission) on all Ytria tools using my coupon code: YTRIACOUPON_KEVINPETTITT
You will thank me...really.
Posted by Kevin Pettitt At 10:23:12 PM On 12/02/2008 | - Website - |
By the way (Sales pitch warning) - Teamstudio Validator will find this and other issues in your database like broken doc links, orphan documents, rep/save conflicts, etc. end of sales pitch.
Posted by John Kingsley At 04:18:29 PM On 12/03/2008 | - Website - |
Posted by cost of composite decking At 05:05:22 AM On 10/04/2011 | - Website - |
With regards to shoe shopping, oftentimes I feel missing. Flat footed. Adrift in an ocean of heel heights and calf widths, not knowing exactly where to show. <h1><a href="{ Link } bailey button triplet</a><h1> is when I flip to my Chicago bestie, Luvvie <h1><a href="{ Link } bailey button triplet</a><h1>. You might currently know her as the humor blogger of AwesomelyLuvvie.com or the co-founder from the Red Pump Challenge; the creator of DumbestTweets.com or the web designer extraordinaire who produces internet sites such as the a single you will be studying appropriate now. Aside from undertaking and being all of those points, <h1><a href="{ Link } bailey button triplet</a><h1> can also be a thing of a shoe legend. When asked about this she responded, I don not know much bout science guides or geography, but I do know <h1><a href="{ Link } bailey button triplet</a><h1>. Hence her other blog for <h1><a href="{ Link } boots sale uk</a><h1>, How numerous sites can 1 person have? I believed I understood. And then I met <h1><a href="{ Link } for cheap</a><h1>.
Such as this post? Study the full story: 5 Awesomely Adorable & Affordable <h1><a href="{ Link } ugg boots</a><h1>
Wintertime is approaching, and when you live in a city like <h1><a href="{ Link } sheepskin cuff</a><h1>, it is essential that you are prepared for your <h1><a href="{ Link } sheepskin cuff</a><h1>. And not just prepared in <h1><a href="{ Link } boots sale uk</a><h1>. I also believe <h1><a href="{ Link } boots sale</a><h1> is really important to maintain some degree of adorable while getting warm. This is doable, even on a budget. Here are my top five picks of awesomely adorable AND affordable <h1><a href="{ Link } sheepskin cuff</a><h1>!
As most folks know <h1><a href="{ Link } on sale</a><h1>, <h1><a href="{ Link } north face</a><h1> is THE brand for cold weather accessories and apparel so they really do not disappoint in what they offer <h1><a href="{ Link } boots clearance</a><h1>. Put on a North Face jacket that is thick enough and see <h1><a href="{ Link } boots outlet</a><h1> if you do not sweat in the dead of winter for <h1><a href="{ Link } boots clearance</a><h1>. In a harsh winter like the one that is being predicted for us this year, this will come in handy.
These <h1><a href="{ Link } vuitton speedy</a><h1> are cute and add a spin for the common winter <h1><a href="{ Link } vuitton</a><h1> new collection with these black panels. Plus they're shiny in <h1><a href="{ Link } vuitton outlet</a><h1>. The inside with the boots have faux fur along with <h1><a href="{ Link } north face outlet</a><h1>'s PrimaLoft? Eco insulation. Your toes will be good and toasty in these. They may be $170, so they may be not undesirable price-wise. You are going to thank them if you can really feel your toes even in ten degree weather. Get them at <h1><a href="{ Link } boots clearance</a><h1>
Posted by uggs outlet At 04:25:06 AM On 10/15/2011 | - Website - |
Posted by Nike Air Max At 02:48:19 AM On 10/18/2011 | - Website - |
In moderating, not satisfying, desires, lies peace.
Posted by Cheap Air Jordan At 11:51:32 PM On 10/18/2011 | - Website - |
In prosperity caution, in adversity patience.
Posted by Nike Shox At 11:54:45 PM On 10/18/2011 | - Website - |
GOOD
Posted by Air Jordan 2011 At 09:20:34 PM On 10/19/2011 | - Website - |
Nike Air Jordan is one of the biggest and first,
Posted by Nike Air Max At 09:38:18 PM On 10/19/2011 | - Website - |
thanks
Posted by Cheap UGG Boots At 09:39:26 PM On 10/19/2011 | - Website - |
Posted by UGG Boots 5163 At 07:09:51 AM On 11/14/2011 | - Website - |
Posted by Coach Outlet Online At 01:59:36 AM On 11/18/2011 | - Website - |
{ Link } Coach Factory Store
{ Link } Coach Outlet
{ Link } Coach Outlet
{ Link } Coach Outlet Online
{ Link } Coach Outlet
{ Link } Coach Outlet Online
{ Link } Chanel Outlet
{ Link } Chanel Outlet
{ Link } Louis Vuitton Outlet
{ Link } Coach Factory Store
{ Link } Chanel Handbags
{ Link } Coach Outlet
{ Link } Louis Vuitton
{ Link } LV Outlet
{ Link } Coach Outlet
{ Link } Coach Outlet
{ Link } Coach Outlet
{ Link } Chanel Bags
{ Link } Coach Outlet
Posted by Coach Outlet At 03:51:53 AM On 11/18/2011 | - Website - |
Posted by Coach Factory Outlet Online At 09:49:01 PM On 12/02/2011 | - Website - |
Posted by Coach Outlet Store Online At 08:50:43 PM On 12/06/2011 | - Website - |
Posted by Coach Factory Outlet At 10:19:15 PM On 12/06/2011 | - Website - |
Posted by Coach Factory Online At 06:41:36 AM On 12/08/2011 | - Website - |
Mulberry outlet
{ Link }
Mulberry Daria
{ Link }
Mulberry outlet store
{ Link }
Mulberry Purses
{ Link }
Mulberry bags
{ Link }
Mulberry Roxanne
{ Link }
{ Link }
Coach outlet
{ Link }
Coach factory outlet
{ Link }
Coach outlet online
{ Link }
Coach outlet Canada
{ Link }
{ Link }
Canada goose
{ Link }
Canada goose jackets
{ Link }
Canada goose jacket
{ Link }
Canada goose outlet
{ Link }
Posted by yirui1210 At 01:40:50 AM On 12/10/2011 | - Website - |
Mulberry outlet
{ Link }
Mulberry Daria
{ Link }
Mulberry outlet store
{ Link }
Mulberry Purses
{ Link }
Mulberry bags
{ Link }
Mulberry Roxanne
{ Link }
{ Link }
Coach outlet
{ Link }
Coach factory outlet
{ Link }
Coach outlet online
{ Link }
Coach outlet Canada
{ Link }
{ Link }
Canada goose
{ Link }
Canada goose jackets
{ Link }
Canada goose jacket
{ Link }
Canada goose outlet
{ Link }
Posted by yirui1210 At 01:48:57 AM On 12/10/2011 | - Website - |
Posted by Coach Factory Outlet At 01:03:30 AM On 12/12/2011 | - Website - |
{ Link }
{ Link }
{ Link }
{ Link }
{ Link }
{ Link }
{ Link }
{ Link }
{ Link }
Posted by Pandora bracelets At 10:08:37 PM On 12/13/2011 | - Website - |
I find the real [url={ Link } Vuitton Online Store[/url] finally ,and i bought a lot LV items with high quality on the website, it is so beautiful and cheap ,i will buy more in the furture.
Posted by sdfds At 10:09:07 PM On 12/18/2011 | - Website - |
Posted by Coach Factory At 08:35:42 PM On 12/20/2011 | - Website - |
Posted by Coach Factory At 08:36:15 PM On 12/20/2011 | - Website - |
coach outlet online
store, the goods will be sent out within 24 hours after confirming your payment and arrive to your door within 7 work days.No one can deny the shopping at the
coach factory outlet
is satisfactory. For the low prices and good quality.
{ Link }
Posted by coach outlet online At 04:00:42 AM On 01/29/2012 | - Website - |
handbags You can not just save your cash but also your time inside a convenient way to obtain the exact same bags product and do not be concerned the shippment of one's products.The
coach outlet store online
are utilized for formal event in company area that will display your excellent taste.Not only does a briefcase make is easier to carry things.
{ Link }
Posted by coach outlet At 04:11:25 AM On 01/29/2012 | - Website - |
Posted by coach factory outlet At 07:42:35 PM On 01/29/2012 | - Website - |
Posted by louis vuitton uk At 07:44:32 PM On 01/29/2012 | - Website - |
coach outlet
.You will easily notice the unfold zippers of this
coach outlet store online
. That is the decoration. There are some inside pockets for you as well. They are easy to match your clothes and to carry.
Posted by coach outlet At 08:08:01 PM On 01/29/2012 | - Website - |
louis vuitton sale { Link }
everywhere.Looking for a
louis vuitton outlet { Link }
and don't know where they are? The easiest way is to enter here. That simple and you definitely will never be disappointed.
Posted by louis vuitton sale At 08:12:52 PM On 01/29/2012 | - Website - |
has a big heart and a healthy appetite, and a wicked swing with a chainsaw. After a knee injury ended his career as a defensive lineman in college, Coach salvaged his Physical Education degree(barely)and landed a job teaching health at the local high school in his hometown of Savannah.
coach factory online { Link }
are loved by many people, when you walk in the street, you could see many people take coach styles.
Posted by coach factory outlet At 08:20:13 PM On 01/29/2012 | - Website - |
{ Link }
Posted by coach outlet store At 09:29:23 PM On 01/29/2012 | - Website - |
{ Link }
Posted by coach outlet online At 09:30:29 PM On 01/29/2012 | - Website - |
coach outlet online
Store sells many series. The Coach shoulder bags are always the best popular series because they are very practical and beautiful.customers are not only interested in handbags and purses, but also fond of?shoes and jewelry which is sold at the
coach outlet
.
Posted by coach outlet online At 10:41:44 PM On 01/29/2012 | - Website - |
louis vuitton uk
as we can imagine are a little expensive but are of good quality like the brand Coach. It's really a good choice to shopping in Louis Vuitton outlet.If you want to catch up to the latest vogue, having
louis vuitton
Handbags of the latest styles can absolutely satisfy you.Just visit LV outlet webpage and select the most suitable products for yourself.
Posted by louis vuitton uk At 12:26:24 AM On 01/30/2012 | - Website - |