How do I set a form to be the homepage?

Posted on 2007-08-05
Last Modified: 2013-12-18
Hi Experts,

I'm creating a database app using Lotus Notes/Domino R7.  The app will collect data from users via a form.  The users will receive an email containing a link to the database.  

At the moment I have set the form to be a frame within a frameset, so when the users clicks on the link within their email the database will launch with the data capture form as the homepage.

Is this the correct way of doing something like this?

Does anyone have a more experienced / better method for data capture using a Notes db?

Question by:shortell
    LVL 63

    Expert Comment

    Is this only for Lotus Noes clients, or for users using inotes or web based mail also.

    If just for lotus Notes clients, then I would design this as a regular form and save the data after data entry.

    Notes client has a very rich set of capabilities, and it seems to be backwards to run it as a wab application if it is not needed.

    Normal method would be to check if the user has already done a form, and if yes, either allow editing or exit with a message. If not, then open a blank form. No framesets needed, no browser needed.

    I hope this helps !

    LVL 46

    Expert Comment

    by:Sjef Bosman
    Hi Shortell,

    Seems to me an excellent way to capture user data.

    Just some things to think of:
    - what happens when they click a second time on the link?
    - are you still able to open the database normally?
    - can they open the database and see data?


    Author Comment

    Hi Guys,

    Thanks for your responses and advice.

    The system will just be solely for a Notes client and not web based.  Where the user clicks on the link more than once was not something I had thought about, so thanks for opening my eyes to that one.

    To detect if the user has already completed a form I'm guessing there would need to be some kind of stamp against their unique reference; maybe in an additional column within the the main view?

    Would it be possible you could give me some suggestions on a general syntax (Formula or LS) for detecting if the user has already completed a form (or point me to a decent tutorial)?

    Thanks again
    LVL 46

    Accepted Solution

    The easiest way would be to store the name of the creator (author) of the document, so you could check in the QueryOpen whether the opener has completed a form before. More or less standard: a field in the form with the name of the FIRST author (make it Computed when Composed), a sorted view with that author field in the first column, and a GetDocumentByKey to find out whether a document already exists or not.

    Suggestion: write your own code, and post it here, if you have time of course.
    LVL 31

    Assisted Solution

    Instead of sending a database link, send a button (you can get fancier with grapics, but a basic button will do).

    Your button code should have the following formula:
    server := "servername";
    database := "path\\filename.nsf -- note the double \\ in paths";
    form := "formname";
    @Command([Compose]; server : database; form)

    Note that the first one is a :colon: and ths second is a ;semicolon;

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    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…
      In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    760 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