You can access fields within tables exactly in the same way as you would access them outside tables. In this scenario, you would probably give each field a telling name like cell11, cell21, etc. I'm not sure how you are getting the value of the status field, but if it is something a user inputs, you could put code on the Exiting event of that field to do something like the following. If you only wanted to create a document conditionally on crossing multiple items, that would be additional code, but the gist of what I think you need is below.
Dim uiws As New NotesUIWorkspace, rowNum As String, i As Integer, s As New NotesSession Dim uidoc As NotesUIDocument, doc As NotesDocument,db As notesdatabase Set uidoc = uiws.CurrentDocument rowNum = Inputbox$("Which Row do you want to calculate?","Row Calcs",1) Set db = s.CurrentDatabase Set doc = db.CreateDocument() For i = 1 To 3 ' (where 3 is the number of columns in a particular row) Call doc.ReplaceItemValue("cell" + Cstr(i), uidoc.FieldGetText("cell" + rowNum + Cstr(i))) Next doc.Form = "Form" + rowNum Call doc.ReplaceItemValue("outsideF1", uidoc.FieldGetText("outsideF1")) Call doc.ReplaceItemValue("outsideF2", uidoc.FieldGetText("outsideF2")) Call doc.save(True,False)
Dig Deeper on LotusScript
Related Q&A from Maureen Leland
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.