Automatic pickup of view values

Posted on 2004-11-02
Last Modified: 2013-12-18
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.

Question by:Faraj1969
    LVL 19

    Expert Comment

    Yeah, its possible.

    Create one view where it stores all the values.  In the last column, add all the values like this:

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


    Author Comment

    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 ?

    LVL 19

    Expert Comment

    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


    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.
    LVL 46

    Assisted Solution

    by:Sjef Bosman
    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.

    Author Comment


    Hi again.

    Sorry madheeswar if my question wasn't clear enough.

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

    Cheers all..
    LVL 19

    Accepted Solution

    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.
    LVL 46

    Expert Comment

    by:Sjef Bosman
    You're welcome :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Suggested Solutions

    For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
      In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now