Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 6 and 7 Forum

Notes/Domino 6 and 7 Forum

  

PreviousPrevious NextNext


~Ned Prehipilyoni 2.Dec.03 04:23 PM Lotus Notes
Domino Designer All Releases All Platforms


Sometimes there are those things where the choices of Lotus to me are one big mystery and this is one of those:
@DocChildren only works in a column or Title Formula nowwhere else... Why?
I needed this function to make an @If statements that prevents more than 1 response being made to a document. There are however no other @formula's available for use in a formula to check the number of responses. So I created a view with @DocChildren in it and use a @DBLookup to get the value from the view. However @DBLookup skips columns with only @DocChildren (and the other alternatives) in it. WHY?
So I gave the row a value where I use a Field in my document like @DocChildren+UserNA. I create a field on my form where I do a @DBLookup for this value and get to see nicely: 1Martijn. So I finally found a number I can work with in a formula? NO! In the document properties I find that even though Notes shows the correct number, it saves: C0 Martijn. And that's independent of the amount of responses. How did you guys do that, but more importantly: WHY?






The @DocChildren mess... Lotus... W... (~Mario Fezniynd... 2.Dec.03)
. . This is why... (~Hank Quetamarn... 2.Dec.03)
. . . . ...and here's a way to do what you ... (~Hank Quetamarn... 2.Dec.03)
. . RE: The @DocChildren mess... Lotus.... (~Naomi Deskrote... 2.Dec.03)
. . . . RE: The @DocChildren mess... Lotus.... (~Ned Prehipilyo... 2.Dec.03)
. . . . . . RE: The @DocChildren mess... Lotus.... (~Justin Minlute... 2.Dec.03)
. . . . . . . . Thanks a lot! (~Mario Fezniynd... 3.Dec.03)
. . . . . . RE: The @DocChildren mess... Lotus.... (~Tate Quetgerob... 2.Dec.03)





  Document options
Print this pagePrint this page

 Search this forum

  Forum views and search
Date (threaded)
Date (flat)
With excerpt
Category
Platform
Release
Advanced search

 RSS feedsRSS
All forum posts RSS
All main topics RSS