?
Solved

Using browse button to get file folder.

Posted on 2004-04-14
16
Medium Priority
?
483 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 500 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 500 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: 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.

Question has a verified solution.

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

For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

752 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