Solved

Comparing and finding list of defaulters who have not submitted a form

Posted on 2004-04-05
8
208 Views
Last Modified: 2013-12-18
I have designed a database in which user can submit its responses through a form. Now I want to design a button which can compare a master database which is also part of the same database entered through separate form and visible in a “User Master” view with the “response view” and show the list of users who have not yet submitted there responses. I also want a facility in which we can send a reminder mail to the defaulter from the same view.

0
Comment
Question by:Prashantbhatnagar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
8 Comments
 
LVL 14

Expert Comment

by:p_partha
ID: 10759313
UPdate the parent document with the username whenever a response document is submitted, Now from the master list do a replacesubstring to get hte list of pppl who have not submitted

Partha
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 10760124
Say you have two views I column listing the user names.. then this how you compare the list

resp := @DBColumn("Notes":"NoCache"; @DBName; "response view"; 1);
mast := @DBColumn("Notes":"NoCache"; @DBName; "User Master"; 1);
@IF( @ISError(resp) | @Iserror(Mast); @Return([ok]; "Error"; "Error encountered during lookup")); 1);
@Trim(@Replace( resp; mast; ""))


To send reminder.. Create agent with simple action to run on the master view and select Send Mail Message as an option.. and select To field to point to the field name of the user listed in master documents

~Hemanth
0
 
LVL 14

Expert Comment

by:p_partha
ID: 10761357
what i was trying to point out was, in the querysave of teh responsedocument just give this code

      Dim session As New notessession
      Dim db As notesdatabase
      Set db = session.currentdatabase
      
      Set doc = source.document
      Set parentdoc = db.getdocumentbyunid(doc.ParentDocumentUNID)
      Set item = parentdoc.GetFirstItem( "<submittedlist>" ) ' replace the submitted list with the field name
      Call item.AppendToTextList( "<your responsedentsname> ") ' replace the respondents name
      Call parentdoc.Save( False, True )
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Prashantbhatnagar
ID: 10763814
I think I might not able to explain you properly my requirement -
If suppose I'm comparing View A with View B where View B is user master record, the difference between the list should appear in a window or should get highlighted in the master record.

Also entry in the view A is date wise (Like same set of users enter same form every fortnight) and in the above solution I should have facility of selection of documents date wise for comparison.

I want this whole thing in a action button
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 10765779
Create two views sorted on Usernames and use my code in a dialog list formula selection..
0
 

Author Comment

by:Prashantbhatnagar
ID: 10766753
I have tried your formula in dialog list but it's giving error
Too many arguments after "Error"

One more thing how can I incorporate selection by date in it?
0
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 250 total points
ID: 10768324
oops.. I left out the prompt

resp := @DBColumn("Notes":"NoCache"; @DBName; "response view"; 1);
mast := @DBColumn("Notes":"NoCache"; @DBName; "User Master"; 1);
@IF( @ISError(resp) | @Iserror(Mast); @Return(@Prompt([ok]; "Error"; "Error encountered during lookup")); 1);
@Trim(@Replace( resp; mast; ""))
0
 

Author Comment

by:Prashantbhatnagar
ID: 10776409
Hi Hemantha..It worked thanks a lot for your tip...
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Need a tweak in Column code (in Notes view) 5 65
Lotus Notes transfer mail box problem 6 109
ESXCLI upgrade command 1 139
DNS error assumed 8 87
For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question