Link to home
Start Free TrialLog in
Avatar of jaggernat
jaggernat

asked on

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
Avatar of madheeswar
madheeswar
Flag of Singapore image

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

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
Avatar of Zvonko
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



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
Sjef, my answer was no guess ;-)
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")

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")

Avatar of jaggernat
jaggernat

ASKER

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
 
ASKER CERTIFIED SOLUTION
Avatar of Zvonko
Zvonko
Flag of North Macedonia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
bingo !  tried and worked ...full points to you sir.

thanks,
J

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?

ok ...i m in the US .and its 6.pm now ... we can do the redirection tomorrow...

thanks zvonko...

I am jay.

Good night..

Good night jay. See you tomorrow.
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!
Munich, of course.
Thank you :-)

-J
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 :-)