Automatic pickup of view values

Hi all

I have a view that lists On Board staff members. Now each staff have a contract and its renewed every year.

How can I let my new form to pickup the values stored in selected view row and store in the new form I'm creating. To make it more clear, the view lists ID #, Last Name, First Name for each staff on board. The view have a button called CREATE NEW CONTRACT, now the user will select a staff name, then click that button, the new form ( Contract ) should take ID #, Last Name, First Name and store them in its fields.

I saw it in some datababases, so I know it's possible.

Any help would be appreciated.

Cheers.
Faraj1969System AdministratorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

madheeswarCommented:
Yeah, its possible.

Create one view where it stores all the values.  In the last column, add all the values like this:
@text(id)+"~"+lastname+"~"+"firstname"

Now, use picklist in formula or script to retreive these values.

0
Faraj1969System AdministratorAuthor Commented:
Thank you for the answer madheeswar.

But I'm sorry to say, I didn't understand.

About the column, thats fine, but the picklist formula where should I write it ? and how would it look like ?

Cheers
0
madheeswarCommented:
u can give a prompt to select respected doc from a view in dialogbox.

@Picklist--see help

And else, since the data is stored and once the user creates new form, they need to type some info like id#.
since u have key as id#, u can fetch remaining values using @DBlookup

res:=@Dblookup("":"Nocache";"";"YourVIEWName";@text(id);2);
@If(@Iserro(res);"";res)

Second column in the view will have last name and 3rd column will have first name.

Use the above formula for first name and change the column no.
place the code in respected fields and make it computed.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Sjef BosmanGroupware ConsultantCommented:
Do you mean to copy field values from the currently selected document in the view to a new form? Go to the form properties, 2nd tab (Advanced), and select Formulas inherit values from selected documents. In the fields of the form that have to receive the values, in the default field value, enter the name of the field or a formula referring to fieldnames of the document the values will be copied from.
0
Faraj1969System AdministratorAuthor Commented:

Hi again.

Sorry madheeswar if my question wasn't clear enough.

many thanks sjef_bosman.... thats exactly what I wanted....


Cheers all..
0
madheeswarCommented:
IF you are looking for that solution, the here it goes.

In the Form properties, enable the option, Inherit values from selected docs.. Say FormB

And in the field values of formB, where u want the data to be displayed, enter the field names of formA to the corresponding fields.

Save and close the form. And not, try to select one doc and click on the Action button to create formB(or from Menu: Creat->FormB)

Now, this should inherit the data.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sjef BosmanGroupware ConsultantCommented:
You're welcome :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.

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.