Solved

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

Posted on 2004-04-05
8
203 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
  • 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
 

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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Lotus Notes 6.5.5 6 200
Migration: Lotus Notes to Exchange 2013 10 312
Lotus Domino server 9 7 64
attaching a file lotus notes 4 99
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now