Solved

Using browse button to get file folder.

Posted on 2004-04-14
16
478 Views
Last Modified: 2013-12-18
Is there a way to use a hotspot button having a browse button just like using attachments but in this scenario you will be able to get an EX: C:/test/hotspots/expert.doc --- this will be displayed in your field instead of the usual.
Thank you.
0
Comment
Question by:cyle
  • 6
  • 6
  • 3
  • +1
16 Comments
 
LVL 31

Expert Comment

by:qwaletee
ID: 10826508
@Prompt([LocalBrowse]; .... ) returns a filename.  You can assign the return value to a field.
0
 

Author Comment

by:cyle
ID: 10826741
I created a hotspot button and formula @Prompt([LocalBrowse]; "Select a to open"; "0". Had it at 0 and 1 to test. I will not be opening any nsf file. I can open it but it will not display, my field is text and editable (changed it to computed to test) and value is the fieldname.
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 10827018
Try this

FIELD FieldName :=  @Prompt([LOCALBROWSE]; "Select a database to open"; "1");
""

~Hemanth
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 3

Expert Comment

by:xp_commander
ID: 10827034
Add this formula in your browse button :-

FIELD fpath := fpath ; (where fpath is your file path field)
file := @Prompt([LocalBrowse]; "Select a database to open"; "1");
@If(file = ""; @Return(1); "");
@SetField("fpath";file);
@Command([ViewRefreshFields])
0
 

Author Comment

by:cyle
ID: 10827189
Commander Sir,
  It is giving me "Cannot execute specified command".
0
 
LVL 3

Expert Comment

by:xp_commander
ID: 10827235
This was for ure information only , please remove it ---> (where fpath is your file path field)

Copy this and In this change the fpath to your fieldname

FIELD fpath := fpath ;
file := @Prompt([LocalBrowse]; "Select a database to open"; "1");
@If(file = ""; @Return(1); "");
@SetField("fpath";file);
@Command([ViewRefreshFields])
0
 

Author Comment

by:cyle
ID: 10827262
Yes, I did removed that part.
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 10827272
Notes Ver ?

This command is available form 4.6 only !!
0
 

Author Comment

by:cyle
ID: 10827283
Sorry, I am using 6.5
0
 
LVL 3

Expert Comment

by:xp_commander
ID: 10827290
I assume you running this on Notes Client ? , Can you paste the portion of your code , is there anything else in formula besides this code ?
I just created a test form , two elements , one is Browse button , second is editable text field called fpath , it worked like charm. Are we missing something here ?
0
 
LVL 3

Expert Comment

by:xp_commander
ID: 10827335
Hemant ,

Did you meant from 4.6 only or FOR 4.6 only ?

As I am on Release 6.0.3 September 26,  2003  and it worked great, I agree you don't need the FIELD declaration after R6 release, but just copied the code  from an existing application I worked on. Believe me it works on R6 and above.

From Help files :-
"With Release 6, you no longer need to declare the field receiving the assignment prior to setting its value with @SetField. For R5 or earlier clients, declare the field at the beginning of the formula, as follows:
FIELD Fieldname:=Fieldname; "
0
 

Author Comment

by:cyle
ID: 10827353
Two elements:
 1. field with name fld_filelocation property text & editable value is fld_filelocation
 2. a button
 
FIELD fpath := fld_filelocation ;
file := @Prompt([LocalBrowse]; "Select a database to open"; "1");
@If(file = ""; @Return(1); "");
@SetField("fpath";file);
@Command([ViewRefreshFields])
0
 
LVL 3

Assisted Solution

by:xp_commander
xp_commander earned 125 total points
ID: 10827421
Change this ---> FIELD fpath := fld_filelocation ;
To
FIELD fld_filelocation := fld_filelocation ;


AND

Change this ---> @SetField("fpath";file);
To
Change this ---> @SetField("fld_filelocation";file);


0
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 125 total points
ID: 10827445
Why do you comlicate it soooo much ??


FIELD fld_filelocation := @Prompt([LocalBrowse]; "Select a database to open"; "1");
""

Will do !!!!


I meant from not form..... fat finger ;-)
0
 
LVL 3

Expert Comment

by:xp_commander
ID: 10827546
B'cuz I am very complicated person..... :p (Just Kidding)

Hey I know , that would work too , it just i had already paste the code at same time  , and was supporting my code, lol.

Cyle , the above code would work too, without any complications ;) , mine just have added lines to check the file is not empty @If thing.





0
 

Author Comment

by:cyle
ID: 10827615
Thank you both your help!!!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Migrating Exchange 2003 organization to new 2010 organization 12 77
Missing Rules 1 307
NT Kernel & System Process CPU Usage Maxin out 8 57
lotus notes, exchange 7 111
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used.

791 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