Strange view behaviour

Posted on 2006-04-25
Last Modified: 2013-11-16
This is a wiev somebody else designed, and I don't know how to get it right. I am very new to Lotus.

Web page display:

Country     Province     City

A lot of other countries


End web page display

Why does not the country Lagos keep it's town's together????

Help me!

Best Regards,

Question by:jansjobe
    LVL 46

    Accepted Solution

    Is it a categorized view? Obviously...

    Most likely there are "Lagos" and " Lagos" in your database (not the space). Do two things:
    - make sure that the form the country is entered on, the Country-field has a translation formula of @Trim(@ThisValue)
    - for the time being, in the view's first and second columns, add a @Trim, .e.g.

    Author Comment

    You were right!
    I'm at a very early stage of learning Lotus, and formulas are really out of my scope at this time...but thanks anyway!

    Can I ask one more question:

    A page is showing an embedded view. If there is no record matching; e.g. if the view is empty, is there a way to display a standard page, view or whatever (I told You, I am very new at this...) that says like "no record found"?
    LVL 46

    Expert Comment

    by:Sjef Bosman
    Piggybacking questions eh...? Not done usually, for several good reasons:
    - many small questions get a larger audience than one large question with many unrelated issues
    - when others are klooking for solutions, they use the title of the question to decide whether to open the question or not

    For this once, you get your free ride :)

    Yes, you can do that, but you need to program that, with hide-when formulas:
    - one line "No records found", hide-when formula:
        x:= @DbColumn("":"NoCache"; ""; "Your embedded viewname"; 1);
        @If(@Iserror(x); @False; @Trim(x)=""; @True; @False)
    - the hide-when of your embedded view must then be set to
        x:= @DbColumn("":"NoCache"; ""; "Your embedded viewname"; 1);
        !@If(@Iserror(x); @False; @Trim(x)=""; @True; @False)
    Note the exclamation mark at the beginning of the last line (it's the logical NOT operator)

    Author Comment

    Sorry for piggybacking...should I make a new question?
    I think I will need a little more guidance with this!

    Author Comment

    The more I look at this, the more I suspect that the person who originally made this database was even less skilled than me...

    - There is one view for each page.
    - The size of this thing is almost 1GB.
    And there is only about 150 documents.

    Also extremely many subforms.

    Oh, maybe I should tell You that it is a database with Hotels, Restaurants, Cottages and other vacation related places adapted for various disabled people.
    The idea is:

    Country -> County -> City -> POI (point of interest)

    At the moment it's like I have to hard code things down to every city; I do think that this seems exceptionally lengthy !!!??
    The web page is also very ugly..

    Maybe You could be hired to restructure things?

    Best regards
    LVL 46

    Expert Comment

    by:Sjef Bosman
    I beg your pardon? 150 documents and 1 Gig? There must be a LOT of photographs in it, to get it that big. Since everything is hard-coded, it probably never happened that a view was empty :)

    If you want me to have a quick look at the code (more is not allowed by EE rules), then
    - make a copy of the database (without the documents!):
        File/Database/New Copy..., select Database design only, on your local disk
    - close Notes
    - zip the database
    - mail it to me, you'll find my address in my EE-profile, somewhere in the middle
    LVL 46

    Expert Comment

    by:Sjef Bosman
    As you already said yourself, the database is poorly designed. Apparently, it's a Web-only database, but on the other hand I see no buttons to update a document from the web. The same form seems to be used in a browser. I suppose that, if the website is indeed for handicapped people, a special design could help them enormously. As you said, a database with 29 * 58 subforms can't be right...

    There is too much to be done on the database to handle in a single question. There are two approaches possible:
    - to attack one problem, convert the database, and attack the next problem
    - complete redesign and conversion of the current database to the new one.

    I'm sorry I don't have better options... :(

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses 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.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    759 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

    11 Experts available now in Live!

    Get 1:1 Help Now