[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference iosg::all-in-1_v30

Title:	OLD ALL-IN-1 (tm) Support Conference
Notice:	Closed - See Note 4331.l to move to IOSG::ALL-IN-1
Moderator:	IOSG::PYE

Created:	Thu Jan 30 1992
Last Modified:	Tue Jan 23 1996
Last Successful Update:	Fri Jun 06 1997
Number of topics:	4343
Total number of notes:	18308

2726.0. "TO: additional field display" by ANGLIN::HARRISA (user vicious) Tue May 18 1993 21:28

    I'm changing our EMHEAD form to include the phone number of users then
    their names are entered at the TO: or CC: prompts.
    
    the code ofEMHEAD is
    
    
    ;;TO;;
    
    /PRE='GET #CASE = 1'
    /OPTIONAL/SCROLL=,,,MAIL$SCL_FUNCTION:TO
    /RSE_RECOG=OA$MAIL_ADD_ADDR WITH .USER = TO;GET TO =
    OA$SEL_BINARY_ADDRESS
    /SHOW='.USER:30 " 2 ".PHONE:15 "  ( " .FULNAM:35 " )"'
    /USE_FORM=EMSREC
    
    when i enter a name in the TO: field, the phone number doesn't display.
    and yes, Andrew, there is a value in the phone field of the profil.
    what's missing?
    
    	ann

T.R	Title	User	Personal Name	Date	Lines
2726.1	a pharmacuitical way of life	ANGLIN::HARRISA	user vicious	`Tue May 18 1993 21:29`	1
	the 2 in the /SHOW is a typo!
2726.2	Lost me already	AIMTEC::WICKS_A	Alphatraz - Coming Summer 93	`Tue May 18 1993 21:45`	8
	ANN, What version of ALL-IN-1? when did phone become a field in OA$MAIL_ADD_ADDR he says bemused. Regards, Andrew.D.Wicks
2726.3	No phone number in OA$MAIL_ADD_ADDR	SCOTTC::MARSHALL	Spitfire Drivers Do It Topless	`Wed May 19 1993 10:55`	16
	To start with, the /SHOW qualifier only affects what is displayed in the list of addressees you get when pressing FIND; it doesn't affect what gets put in the TO or CC fields. Secondly, as Andrew points out, I don't think OA$MAIL_ADD_ADDR has a phone number field. The only way I think you can do this is to add some field post-processing which: - extracts the relevant part of the address (the bit in parentheses) - looks it up in PROFIL to get the phone-number - re-formats the TO field to add the phone number But note this would only work for PROFIL records and I'm not even sure it will work right for them! Scott
2726.4		ANGLIN::HARRISA	user vicious	`Wed May 19 1993 15:38`	11
	soory - i guess i didn't think it thru before iwrote the note. i'll try again... the original request was to have have the division name, mail stop and phone number displayed when a user presses FIND at the TO; and/or CC: prompts when creating a mail message. ann ALl-IN-1 2.4 soon to be 3.0
2726.5	Still wondering how you're going to do it	AIMTEC::WICKS_A	Alphatraz - Coming Summer 93	`Wed May 19 1993 15:59`	7
	Ann, When you get it to work please tell us how you did it! Regards, Andrew.D.Wicks
2726.6	Suggestion: /USE_FORM and lots of patience!	SCOTTC::MARSHALL	Spitfire Drivers Do It Topless	`Thu May 20 1993 11:39`	16
	Hi, Here's a suggestion: As well as /SHOW, put a /USE_FORM on the field. Then, create a suitable form for the /USE_FORM, with all the fields you want. ALL-IN-1 should populate the fields specified in the /SHOW (you may need /ALIAS somewhere as well). You can then add some clever named data to the other fields to go and get phone numbers, etc, based on the info ALL-IN-1's put on the form. In my experience, most things like this are possible in ALL-IN-1, but you need lots of patience to experiment until it works! Sorry that I don't have the time to prototype it and send you a working form, but I'll be interested to see the result if you can do it. Scott
2726.7	And for my next trick...	IOSG::CHINNICK	gone walkabout	`Thu May 20 1993 12:22`	21
	Hi... Really this is kids stuff... just use "@": /SHOW='.USER:30 @"PROFIL.PHONE:15[.USER]" "( " .FULNAM:35 " )"' ^^^^^^^^^^^^^^^^^^^^^^^^^ The marvellous "@" operator can also be used for other party tricks: @"OA$FUNCTION='command-list'" doesn't give a useful value (gives 'command-list'), but does perform a very useful function in a squeeze. Enjoy, Paul.
2726.8	THANKS!	ANGLIN::HARRISA	user vicious	`Fri May 21 1993 21:48`	1