Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Auto-filling a SharePoint form with entries from a previous form

Posted on 2013-02-03
1
303 Views
Last Modified: 2013-03-05
I currently have a SharePoint calendar with a customized form used to enter new calendar items that track projects that my business is working on. That custom form has additions to the standard form, such as:

1. A project ID that the user manually inputs.
2. Any special tools required for the project (a list of tools with a checkbox next to each that I hardcoded into the form)
3. Personnel working on the project (a list of people with a checkbox next to each, also hardcoded into the form).
4. Several other custom properties similar to the tools and personnel ones I mentioned.

Sometimes, projects don’t get finished within the originally scheduled time so folks have to make another calendar item for a later date to track the rest of the project. When the user creates that second calendar item, I’d like him or her to have the following experience:

1. Click the “new” button to create a new calendar item.
2. Enter the project ID from the previous calendar item
3. All of the custom fields (like the tools and personnel field I mentioned above) get automatically filled out using the values from the first calendar item.
4. User clicks “OK” button to save the calendar item.

I’m not a SharePoint expert, we are using http://companyweb from a small business server installation that I migrated to a standalone SharePoint foundation 2010 server a while back. If it’s possible to do this in a simple manner and without custom code, that would be awesome. If not, it would still be great to hear how it’s done and I’ll do my best.

Thanks in advance for your help
0
Comment
Question by:Julian123
1 Comment
 
LVL 7

Accepted Solution

by:
dhawalseth earned 500 total points
ID: 38850077
Dear Julian,

Based on my understanding, I would request you to do the following steps:
1. On your custom form, place two webparts. One webpart will act as search and other will act as a new entry.
2. On first webpart, allow user to enter a project number and then click on search or create an event using javascript which will help you pass value from one webpart to another.
(Need to try this, I haven't tried it) I am sure this is doable, some how we should be able to pass or set new form fields based on the entered project number. The condition being, that data should exist for the project number.

You might need to use the javascript evvents to achieve this.("_spBodyOnLoadFunctionNames.push()"- method)

3. If Successful in step 2, you need to just click on 'submit' on second webpart and your item will be created successfully.

You need to try this solution, it just popped into my head.
Infopath is another solution.
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Microsoft  Partnership 1 88
How to view calendars overlay in list view in SharePoint 2010? 1 104
Exchange 2007 3 47
SBS 2011 Server CPU Utilization 33 32
Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

808 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