I have a view from which I want to pull info from a form. Basically this is where I am I have simple search choosing using the form and all column’s are just using the field options for display. When I save and close I get a doc link thats sent to me through an @mailsend formula includedin the button action but the Views assotiated with display no info.
Here is my formula included with the save and close button thanks.
@Command( [EditDocument]; “1”);
FIELD Status:=Status;
@PostedCommand([FileSave]);
@MailSend(“Group”; “”; “”; "CAR Alert ->Final Response Due in 3 days " : responsibility: " " : partnum; “”; "CAR # " : carnumber : " was assigned to " : AssignedTo : " and the Final Response is due in 3 days. " : @NewLine : @NewLine : “Click here to see the CAR ->”; [IncludeDoclink]);
@PostedCommand([FileCloseWindow])
Subject: Newbie can’t get info to show in view.
Andre,
I cleared my selection statement to no avail. I then added select @all and still nothing so I have started from scratch copying fields and formatting form the form/view and now it seems to be working fine I don’t know what happend I’ll investegate and post if I find anything out.
Thanks for your help.
Subject: Newbie can’t get info to show in view.
I don’t think you need to open the document – you certainly don’t need to edit and save it. Just use @MailSend and that should be enough. However, the subject and body text arguments of @Mailsend are not multivalued as you have them in your formula. Use +, not :, to join fields and static text and @Newline together for inclusion in the message. Also, use the Remark argument, not bodyfields, for the static text of your message, if you want to include a doclink (see @Mailsend online help).
@MailSend(“Group”; “”; “”; "CAR Alert ->Final Response Due in 3 days " + responsibility + " " + partnum; "CAR # " + carnumber + " was assigned to " + AssignedTo + " and the Final Response is due in 3 days. " + @NewLine + @NewLine + “Click here to see the CAR ->”; “”; [IncludeDoclink]);
@PostedCommand([FileCloseWindow])
Subject: RE: Newbie can’t get info to show in view.
Thanks for the @mailsend tips that’s good but I still cannot get any info to show up in my Views I don’t understand why it’s so difficult I have never had an issue with this before. Basically my View should show 5 fields included in the doc but nothing shows up.
Thanks for the help Andre.
Subject: RE: Newbie can’t get info to show in view.
If you’re talking about a view in the mail database of these documents you mailed, then no, a Memo document that you create with @MailSend will not contain the same fields as the document that was active when you sent the mail. @MailSend creates memo documents with the From, Recipients, Subject and Body – just like memos always have. When you use @MailSend with arguments, you’re not mailing the actual document with all its fields – you’re creating a memo about the document.
If you want to mail the actual document, you can do it with @MailSend with no arguments. That’ll make your views work better. However, the user can’t open the document and see anything useful unless either there’s a copy of the form in their mail file design, or you store form when you send it (this is an option in the form design). I do not recommend using Store Form in this way, as it’s just a waste of space.
The usual way to send a mail notification, is to send a short message with a doc link, as you have done.
I don’t think it’s a good idea to have specialized mailbox views that show extra fields in certain memos. Where’s the end to that? Each user may potentially be using a different set of applications that would be sending them memos with different sets of fields in them. Are you going to give each user the same set of views, with a special view for each application, so that for any given user there are 75% of the views that they don’t use? Or did you have in mind to individually tailor the design of each user’s mail file? And then there’s the problem that people will be editing the information in the application, so that the info in the mail files get out of date. No thanks!
If the user is going to have to go to a special place to see a view of “their” information, it shouldn’t be a mail file view. Instead use a view in the the application that contains the documents. To show only documents of interest to the user, you could use a single-category view embedded in a form or page, as has been extensively discussed in the Notes 4/5 forum.
Subject: RE: Newbie can’t get info to show in view.
I think my lack of knowledge here has given the wrong impression.I actually never wanted them to see a special view in a memo.
I just want views created in my database to show the info gathered from the form. For some reason it doesn’t. I created the views in the application completely by using fields for the display options in the columns. What gets me is even though I can pick the fields from the form well creating the view after I enter info in the form no info is shown in the views. However my mailed doc provides a fully functional link.
Thanks again! hope I made it clearer.
Subject: RE: Newbie can’t get info to show in view.
Ah. So really mentioning @MailSend was something of a red herring. What you meant to convey was that the documents do exist because the mail message contains a link to them, but that you’re not seeing the document information in the views.
I’m still not sure what you mean about info not showing in a view. Are you saying that the view has no documents in in, or that the documents are in the view but the columns display blank values (in other words you can open a document from the view, you just can’t tell anything about the document until you open it)? I suspect it’s the former. I.e. the problem is not with your view column formulas, but with the view selection formula, which excludes all documents from the view.
Subject: RE: Newbie can’t get info to show in view.
I think you are right but I am not sure how to tell if the view contains DOC’s but isn’t showing the info in the assotiated with them in thecolumn’s. What would I have or haven’t put in the selection formaula that would exclude the docs from view?
Thanks again Andre.
Subject: RE: Newbie can’t get info to show in view.
My previous message might have been a clue that you should post the selection formula. There are so many ways that you could exclude all documents from the view that it would be pointless for me to give examples.
To tell whether there are any documents in the view, double-click on the empty space where the first document should appear and see whether a document opens. See whether you can move the document highlight around. Do Edit / Select All and see whether you get checkmarks in the margin.
I ask you to be very certain also that you have no fancy formulas in the view columns. In particular I want to make sure you’re not using @Return anywhere.
Subject: RE: Newbie can’t get info to show in view.
I tried to select all and no checksmarks for the documents showed up. My View main selection is simple search with
“uses non-conformity note form” listed in the programmers pane which is the name of my form.
All my columns just use fields to select the data to be displayed.
Subject: RE: Newbie can’t get info to show in view.
I can think of two possibilities:
Are these response documents? If so, the problem is that the view is set to show response documents in a hierarchy. In that case you can’t see the response document unless the parent document is also in the view – which it’s not, because your selection formula excludes it. Check the view properties dialog.
Otherwise, the document is getting saved with a Form value that’s different from the actual name of the form. This could happen if you have a Form field on the form – it can replace the form name that the system assigns by default with a different string of your choice. In that case, I suggest you remove the selection criteria altogether so that the view will display all documents.