Avatar of Michael Carrillo
Michael CarrilloFlag for United States of America asked on

SharePoint Developer Question

I need to develop a form in SharePoint 2007 using a SharePoint list. In addition I am supposed to use only native SharePoint functionality and/or SharePoint Designer. My background is largely SQL Server, VB.NET and ASP.NET.  So I am a little out of my comfort zone using Native SharePoint functionality.

Could you recommend an approach to developing this form?  I already have a SharePoint List that I have created.

General Description of form:

Field1
Field2
Field3(Choice)  <= Determines which fields are visible

Field4(Choice A)
Field5(Choice B)

[Submit Button]  <= Saves changes and activates a workflow
-----------------
Workflow locks fields and emails next person and opens additional
hidden fields.

Field6
Field7

Would you recommend using a document library or can I create the form directly off the list?

Any help is appreciated.
Microsoft SharePointWeb Languages and StandardsWeb Development

Avatar of undefined
Last Comment
svetaye

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
svetaye

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Michael Carrillo

I had already Built a solution in InfoPath, but Leadership did not like the limitations of a browser only InfoPath Solution (not all users have InfoPath installed on their systems).  The solution I need to build is considerably more complex than what I described above. The form I need to build will need to move back and forth between four different groups with permissions applied at different stages of the form completion. As follows:

F1 <=> F2 <=> F3 <=> F4

F1: Form Creation and provide additional information if F2 requires it.
F2: Approves(F3)/Denies(F1) or request additional information from F1
F3: Determines if work can be done(F4) or not(F2) and can request additional information from F2
F4: Provides estimates of work needed to F3 and can request additional information from F3.
livanescu

Try the infopath form that can be opened in a browser or InfoPath (Tools-->Form Options-->Compatibility) and you can publish it to your site (so no need for client-side app; not all the broswers are "nice" - it's 2007!, but it's useable). if you don't use sophisticated data connections it should work like a charm.

You will have a workflow on item creation, to pass it to F2.
You can create multiple workflows based on your same form library (on item change), each one checking a certain field - like a formStatus or like - and if the condition occurs (you would have many different values), the workflow will do one action (usually pass it one step up or down and then close).
Or one giant workflow (on item change!) that checks the condition until it gets a hit and executes an action (like creating a task or sending an email - task is better in my opinion) and then the workflow exits (just to not leave it hanging there forever).
ASKER
Michael Carrillo

livanescu,

Unfortunately, InfoPath is no longer an option for me.  My original solution was built in InfoPath and fulfilled the original requirements. Leadership has decided that they want the application rebuilt using List, native SharePoint functionality and/or SharePoint Designer.

Sometimes it is hard to abandon a working solution. I can only advise the Client, not tell the Client what to do. So, my new assignment is to build a solution using List, native SharePoint functionality and/or SharePoint Designer.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
SOLUTION
svetaye

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question