I have two forms. Once a document is filled out from Form1, I want users to click a button and open a document from Form2. One field's contents from Form1 needs to pass to Form2.
Then Form1 needs to close.
Form2 needs to be open in edit mode
Two more fields are filled out on Form2.
I want the user to click a button on Form2 that saves that document, closes it, and opens another document from Form2, and so on, until they are done, then there's another button that saves and exits.
I understand these are two pieces of code and thats ok, but they should be very similar, just a little different on buttons on both forms.
I have tried both formula language and lotusscript but my problem is making it work so that multiple tabs aren't left open. I want Form1 to close after it's filled out - nothing more required here. However there could be several documents from Form2 before they are done and I don't want the user left with that.
I thought maybe I could do it with user input via a dialog box, because the user really doesn't have to see the Form2 documents, they just need to populate those two fields.
Here is the formula language I have so far - but it keeps the wrong documents open, and I don't know how to tell how many @command([FileCloseWindow]) s to put because the number of form2 documents will vary.
This is in the Form1 Button
tmpFedEx := FedExNo;
'this is the field that needs to pass to Form2
'these next statements set several flags
Can this be done cleanly with formula language?