Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

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.
0
Faraj1969
Asked:
Faraj1969
  • 3
  • 2
  • 2
2 Solutions
 
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
 
Faraj1969Author 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
Faraj1969Author 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
 
Sjef BosmanGroupware ConsultantCommented:
You're welcome :)
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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