Hello everyone,
I have a form with some field and besides a text field for remarks/clarification, along with a submit button.
Wen the test-remarks field is filled and submit button clicked, it should fill and save a form in Another database, purposely created for this purpose. How can i can i compose form in another database . Have already created form in the Remarks Database.
Plz msg back if any further clarification is needed. Greatly appreciate help…
Ashutosh
Subject: Creating and saving form in another Database.
Assuming the other database is a notes database- a submit button can create a document using a form w/ out much difficulty. My question would be do you want the saved documents in both databases? If so, why? What is the “creator’s” access to the other database? If this is for the purpose of security, make the second database a mail-in database- lots of choices depending on what your needs are.
Subject: RE: Creating and saving form in another Database.
Thnx for response Andre and Thomas…
Do not need to save the form in both the DBs - both are Lotus Notes DB… I just need the form to be saved in the 2nd DB specially made for this purpose alone…
I got :
@Command([Compose]; server : database ; form ; width : height)
but this creates a blank form, not the one with filled up data…
Subject: RE: Creating and saving form in another Database.
Yes, the inherit values for formulas thing doesn’t work across databases. Go back and re-read my earlier message.
Subject: RE: Creating and saving form in another Database.
Got hte thing to work… had given the server address wrong and thus the form was not opening…
Thnx to everyone…
Subject: RE: Creating and saving form in another Database.
It’s generally easier to put the form you want to compose in the database you want to compose it in. All the languages’ commands for composing documents let you specify in which database. If you need to supply some default values, use LotusScript, compose the document using NotesUIWorkspace.Compose, save the NotesUIDocument it returns into a variable, and set the fields you want to set.
Otherwise, you can have your submit button (or Querysave code, in case the user presses Ctrl+S) create a document in the other database using the back-end methods and copy over everything from the current document with CopyAllItems (you’ll have to use Refresh method first if you have any rich text fields). But this gets you into complications. What if they save twice using Ctrl+S? Do you want to create a second document? Or do you want to exit the instant they try to save? You’ll have to do some extra work to make your form behave like a “normal” Notes form, and you could avoid that extra work by just using a normal form in a normal way.