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
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
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
- @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
Hello J,
beside that you have to check the Form property "FormulaInheritValuesFromS electedDoc ument" 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];"";"App lyJobs")
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
beside that you have to check the Form property "FormulaInheritValuesFromS
The formula to open the new form is this:
@Command([Compose];"";"App
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
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.jp g
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];"";"App lyJobs")
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];"";"App
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];"ApplyJ obs")
@Command([Compose];"ApplyJ
ASKER
What do you mean by defining rectangle???? i selected the ApplyForThisJobPosition.jp g image first and then: create hotspot -> link hotspot ->named element -> form-> apply jobs..
IS that what you meant?
thanks,
J
IS that what you meant?
thanks,
J
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
bingo ! tried and worked ...full points to you sir.
thanks,
J
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?
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?
ASKER
ok ...i m in the US .and its 6.pm now ... we can do the redirection tomorrow...
thanks zvonko...
I am jay.
Good night..
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!
Had a nice drop of rain in Munch? Donnerwetter!
Munich, of course.
ASKER
Thank you :-)
-J
-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 :-)
Pass the required parameter to the URL after ?openform¶meter=urpara
Check help for more info on this fields