Please help me ergarding this…
Subject: RE: Embedded View not displaying the Documents - Urgent *
The view will have to be categorized.
You should not have a field whose formula is @Text(@DocumentUniqueID)). There are two reasons for this. First, it’s inefficient. You can just as easily put this formula in the single category formula. Second, it introduces extra possibilities for error (for instance, if it’s a regular editable field and this is its Default formula, the value it stores is not really the UNID of the document, because it’s calculated before the document was saved).
Once you have changed the view back to categorized, there are really only a few reasons it could be not working. You have to check to see which of these is the case.
The formula that calculates the single category value is coming up with the right value. You have to do a test, e.g. by having a separate computed for display field that calculates the same value so you can see what it is. This field should go right before the embedded view.
The single category formula is right but the view column formula is wrong. The values must be the same and the datatypes must be the same. Your single category formula calculates a text value. If the column formula is $REF, that’s not a text value, so they don’t match even if they look the same.
Both formulas are correct, but there don’t happen to be any documents that match the key. This could be a problem with the code that creates the documents, that it’s assigning a wrong key value.
You might also want to read this: Dynamic table on a Notes form.
If this doesn’t help, we would need more information – your formulas, code that creates the documents, and so on. If you’re not sure what information to supply, the C R I S P Y document might help you.
- Andre Guirard, IBM/Lotus Development
Useful blog: Best Practice Makes Perfect