?
Solved

Retrieving field values from documents on forms.

Posted on 2004-08-22
17
Medium Priority
?
209 Views
Last Modified: 2013-12-18
hi,

i want to retrieve a field value from a stored document to a form automatically when it is opened in a browser.

Any ideas appreciated.


thanks,
J
0
Comment
Question by:jaggernat
[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
  • 8
  • 4
  • 3
  • +2
17 Comments
 
LVL 19

Expert Comment

by:madheeswar
ID: 11867194
Use Query_String and Query_Decoded fields

Pass the required parameter to the URL after ?openform&parameter=urparameneter

Check help for more info on this fields

0
 
LVL 15

Expert Comment

by:Bozzie4
ID: 11867627
Use

- @dblookup
- @getdocfield

depending on how you know which document's data to retrieve (if you know the documentuniqueid, and the data to retrieve is in the same database, use @getdocfield)

cheers,

Tom
0
 
LVL 63

Expert Comment

by:Zvonko
ID: 11869008
Hello J,
beside that you have to check the Form property "FormulaInheritValuesFromSelectedDocument" you have also to use a @formula on the Form where your stored document is displayed.
The formula to open the new form is this:
@Command([Compose];"";"ApplyJobs")

And your ApplyJobs Form needs in the destination Field a DefaultValue formula.
The formula is the name of the Filed from where the old value needs to be inherited.
So your "Subject" Field on the ApplyJobs Form needs this DefaultValue formula: company



0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 11869176
Hi Jaggernat,

Your question is too vague to allow proper answers, that's why you get a lot of guessed responses. Could you be more precise as to what you want?

Sjef
0
 
LVL 63

Expert Comment

by:Zvonko
ID: 11869230
Sjef, my answer was no guess ;-)
0
 
LVL 63

Expert Comment

by:Zvonko
ID: 11869314
Hello J, your Form "JobPosting" still has not the @formula for the ApplyForThisJobPosition.jpg
To put my formula behind the image you have to define a rectangle over the image.
And for that HotspotRectangle can have this Formula: @Command([Compose];"";"ApplyJobs")

0
 
LVL 63

Expert Comment

by:Zvonko
ID: 11869871
Sorry, the Compose formula needs to be this in a web application (even when it worked in my web test with the upper formula):
@Command([Compose];"ApplyJobs")

0
 
LVL 10

Author Comment

by:jaggernat
ID: 11875972
What do you mean by defining rectangle???? i selected  the ApplyForThisJobPosition.jpg image first and then: create hotspot -> link hotspot ->named element ->  form-> apply jobs..


IS that what you meant?

thanks,
J
 
0
 
LVL 63

Accepted Solution

by:
Zvonko earned 1000 total points
ID: 11876021
The method like you open the form does NOT pass to the ApplyJobs form the parent document id.
Do it with the AddHotspotRectangle option like I proposed and you will see that parent document values are inherited.

You get the AddHotspotRectangle when you riht click with your mouse on the image. The option is then in the popup context menu.


0
 
LVL 10

Author Comment

by:jaggernat
ID: 11876028
bingo !  tried and worked ...full points to you sir.

thanks,
J

0
 
LVL 63

Expert Comment

by:Zvonko
ID: 11876064
Thanks for points.

What timezone are you in? I am located in Munich and has now to go to bed :)
Can we do your user profile redirection tomorrow?

0
 
LVL 10

Author Comment

by:jaggernat
ID: 11876106
ok ...i m in the US .and its 6.pm now ... we can do the redirection tomorrow...

thanks zvonko...

I am jay.

Good night..

0
 
LVL 63

Expert Comment

by:Zvonko
ID: 11876126
Good night jay. See you tomorrow.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 11882845
Hi Zvonko, I should not have reacted before reading the other questions by Jay. There's a history in every question, I suppose. I just came back from my holiday, saw the first question and coudn't resist replying to it. Won't happen again. Hopefully ;)

Had a nice drop of rain in Munch? Donnerwetter!
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 11882854
Munich, of course.
0
 
LVL 10

Author Comment

by:jaggernat
ID: 11883189
Thank you :-)

-J
0
 
LVL 63

Expert Comment

by:Zvonko
ID: 11884290
Hey, Donnerwetter! Cool! But unfortunately you are right: Last year we had more then perfect summer, so now this year we got NO summer, only Donnerwetter :-)
0

Featured Post

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!

Question has a verified solution.

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

Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

764 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