How to have a form pull data from another form?

HCL Domino Domino Forum
1

Using formula language, is there a way to open a form and have it check a field(s) on another form and update the open form accordingly?

Thanks, Paul

2

Subject: Not unless it’s been saved as a document

A form is just a display of data, you can get to the underlying data if it has been saved, and you know the document id, or some unique key to lookup against.

Not sure what you’re trying to do, but maybe a dialog using a form would do it for you, see domino designer help.

3

Subject: Data is saved

Thanks for you response…

I create a “top level” form that has dates and other criteria and from this form I launch new forms (via an action button) and in the process, copy some of the data (dates/etc) from the “top level” form. Now if someone updates the dates in the “top level” form, when I open the “spun off” form, I want the dates to update reflecting the updates on the original form. Does this make sense to you? Can it be done easily?

Thanks again for you help, Paul

4

Subject: @dblookup

Let’s clarify some terminology here…it will make things easier in this discussion, and in any others you ever have:Form = graphical user interface to display/update document data

Document = actually stores the data (in some other programming ideologies, this might be a “row”)

View = graphical user interface to display a group of documents, can also be used to programmatically access said documents/data

Now that we have that out of the way…

Read in your Domino Designer Help about the formulas for @dblookup and @dbcolumn. I think these will give you what you need. It sounds like it would be enough if your field on your “child” document would be set up as “computed for display”.

5

Subject: Thanks

Maria,

Thanks for your lesson on the correct terminology, I am all for using the proper/“standard” terms… they make a big difference.

I will look into the commands you mentioned…

Thanks, Paul