Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 493
  • Last Modified:

Using browse button to get file folder.

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
cyle
Asked:
cyle
  • 6
  • 6
  • 3
  • +1
2 Solutions
 
qwaleteeCommented:
@Prompt([LocalBrowse]; .... ) returns a filename.  You can assign the return value to a field.
0
 
cyleAuthor Commented:
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
 
HemanthaKumarCommented:
Try this

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

~Hemanth
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
xp_commanderCommented:
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
 
cyleAuthor Commented:
Commander Sir,
  It is giving me "Cannot execute specified command".
0
 
xp_commanderCommented:
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
 
cyleAuthor Commented:
Yes, I did removed that part.
0
 
HemanthaKumarCommented:
Notes Ver ?

This command is available form 4.6 only !!
0
 
cyleAuthor Commented:
Sorry, I am using 6.5
0
 
xp_commanderCommented:
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
 
xp_commanderCommented:
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
 
cyleAuthor Commented:
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
 
xp_commanderCommented:
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
 
HemanthaKumarCommented:
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
 
xp_commanderCommented:
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
 
cyleAuthor Commented:
Thank you both your help!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

  • 6
  • 6
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now