View's Column Formula Does not Reflect Expected Value
When creating views, I often do a cut and paste of columns in order to get the proper number of entries. But occasionally, the formula I put in for the column refuses to work. Now I know why... From the KnowledgeBase...
View's Column Formula Does not Reflect Expected Value
Document Number:
1086357
Problem
A view's column formula does not reflect
the expected value. Upon review, you determine that the formula is
without fault. If you re-create the column within a new column, or
new view, it works as expected.
Content
If a column formula is not returning
the expected value, check the Programmatic Use property in the Column properties.
This property defaults to a unique value, but if it is manually changed
to a value which coincides with a field name then the column formula will
evaluate to that field (and ignore the column formula). To reset
the Programmatic Use entry simply delete the current entry, and Notes will
automatically repopulate it with a unique value.
Supporting Information:
The Programmatic Use property is located
on the Propeller tab of the Column Properties.
| Permalink |
Comments
Posted by Duffbert At 17:37:54 On 13/02/2004 | - Website - |
'Tis for this very reason that I discourage allowing the dollar value to stand. A meaningful programmatic name for the column should be used instead. If the name truly is meanngful, then the only way it can conflict with a field name is if there is a field present that already contains the value you wanted to compute.
Posted by Stan Rogers At 15:49:00 On 13/02/2004 | - Website - |
Posted by Ray J. Bilyk (aka The Lion King) At 09:07:32 On 13/02/2004 | - Website - |