确保为表单上每个字段设置了数据类型、公式和其他属性。
Be sure to set the data type, formula, and other properties for each field on the form.
该字段包含此处所展示的公式。
查看每一个列公式,在一张纸上写下公式中引用的一个或多个字段。
On a piece of paper, look at each column formula and write down the field(s) referenced in the formulas.
重点:SQL查询公式的选择语句必须包括视图列中引用的全部字段。
Important: the Select statement of the SQL Query formula must include all the fields referenced in the view's columns.
使用按钮的优点在于:可让您从字段中删除查找公式。
The advantage to using a button is that it lets you remove the lookup formulas from your field.
因此我们使用Post -Open公式计算出来的LookupValue字段,通过单个查找来读取九个字段。
So we use the LookupValue field calculated by the Post-Open formula to read nine fields with a single lookup.
另一种导致执行不必要的查找的错误是:比如,一个computed字段在以下情形时计算查找公式。
Another kind of mistake that causes unnecessary lookups is to have, for example, a computed field that has a lookup formula that computes when.
ContactName字段公式将类似于清单7所示的代码。
The ContactName field formula would look like the code shown in listing 7.
而ContactPhone字段公式将类似于清单8所示的代码。
And the ContactPhone field formula would look like the code shown in listing 8.
现在对于ContactName字段,其公式可能如清单11所示。
Now for the ContactName field, your formula might be the one shown in listing 11.
首先,在下拉列表字段的公式中,使用以下公式。
First, in the formula of your drop-down field, use this formula.
这些绑定执行Subtotal和Totalprice字段的计算公式(参见图15)。
These binds perform the calculations for the Subtotal and Totalprice fields (see figure 15).
我们没有修改存储在该字段中的数据,而是使用“为显示而计算”的公式先操作再显示XML 显示表单中的abstract 字段。
Rather than modify the data stored in the field, we used a computed-for-display formula to first manipulate, then display, the abstract field in the XML display form.
这个公式引用的不是ID字段,而是活动文档的Post - open公式中定义的keywords字段。
The formula refers not to the ID field, but to the Keywords field defined in the Post-Open formula of the activity document.
h_Vars特殊公式不仅生成在文档中显示的非系统字段(不以 “$” 开头的字段),而且生成由NotesVar和NotesField 定义指定的字段。
This h_Vars special formula produces not only the non-system fields (ones that don’t begin with a “$”) present in the document, but also those specified by NotesVar and NotesField definitions.
在这种情况下,FieldName是此公式所在字段的名称。
In this case, FieldName is the name of the field in which we have this formula.
在这种情况下,FieldName是此公式所在字段的名称。
In this case, FieldName is the name of the field in which we have this formula.
应用推荐