• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

Retrieving field values from documents on forms.

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
jaggernat
Asked:
jaggernat
  • 8
  • 4
  • 3
  • +2
1 Solution
 
madheeswarCommented:
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
 
Bozzie4Commented:
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
 
ZvonkoSystems architectCommented:
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
2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

 
Sjef BosmanGroupware ConsultantCommented:
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
 
ZvonkoSystems architectCommented:
Sjef, my answer was no guess ;-)
0
 
ZvonkoSystems architectCommented:
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
 
ZvonkoSystems architectCommented:
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
 
jaggernatAuthor Commented:
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
 
ZvonkoSystems architectCommented:
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
 
jaggernatAuthor Commented:
bingo !  tried and worked ...full points to you sir.

thanks,
J

0
 
ZvonkoSystems architectCommented:
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
 
jaggernatAuthor Commented:
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
 
ZvonkoSystems architectCommented:
Good night jay. See you tomorrow.
0
 
Sjef BosmanGroupware ConsultantCommented:
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
 
Sjef BosmanGroupware ConsultantCommented:
Munich, of course.
0
 
jaggernatAuthor Commented:
Thank you :-)

-J
0
 
ZvonkoSystems architectCommented:
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

Get your problem seen by more experts

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

  • 8
  • 4
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now