如何从 Lotus DB 中的另一个表单或视图计算表单中的字段
我有表格“A”，其中有一个字段需要在由表格“B”组成后进行计算。这些表格位于同一数据库中。我不确定在使用表单“B”的“视图”组成后计算表单“A”字段是否会更好，或者填充字段的最佳方法是什么。
我尝试过@DBlookup，但没有成功。
谢谢你！
I have form "A" which there is a field that I need be computed after composed from Form "B". The forms are in the same database. I am not sure if it would be better to have the Form "A" field compute after composed from a "View" that uses the Form "B" or what would be the best way to get the field populated.
I have tried to do a @DBlookup, with no success.
Thank you!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
表格不包含信息，只有文档包含信息。表单仅代表存储在文档中的信息。
假设您有一个名为“viewName”的视图，它显示一组文档。
此视图的第一个排序列包含键值。
我们希望从该视图中通过键获取字段 someField 的值。
创建一个新表单，创建一个“组合时计算”字段，并设置以下公式作为值：
它将访问当前数据库中的视图“viewName”，通过“keyValue”获取文档并返回名为“someField”的字段值
Forms do not contain information, only documents do. Forms just represent information stored in documents.
Assume you have a view with name: "viewName" and it displays a set of documents.
The first sorted column of this view contains key values.
We want to get value of field someField by key from this view.
Create a new form, create a "Computed when composed" field and set the following formula as value:
It will access view "viewName" in the current database, get a document by "keyValue" and return value of field with name "someField"
嗯，出了什么问题？为什么这不起作用？当您进行
@DbLookup调用时，您需要提供一个视图、一个“键”以及要从匹配文档中提取的字段或视图列。假设您有一个可以链接文档 A 和文档 B 的密钥，则查找应该非常简单。Well, what went wrong? Why didn't this work? When do you a
@DbLookupcall, you need to provide a view, a "key" and the field or view column you want to pull back from the matching document. Assuming you have a key with which you can link document A and document B, the look-up should be pretty straightforward.