Solved

SharePoint online in office 365 development

Posted on 2013-11-20
12
427 Views
Last Modified: 2014-01-20
Hi,
2 questions- on SharePoint online (Office365-E3).
1st-
 I want to create some business form.
 My user wants some validation rules, which will do validate value before submit happens to list/library .
Like...if users has Total limit of 300 Dollar,
So user1, submits 200 dollar in 1st time, but ,
 say..he is again submitting for 200 dollar (which he shouldn't) in 2nd time,
So,can he be validated for the value on list items that his total (200+200=400 exceeds allowed value of 300) ?

2nd
- which is correct approach for doing this-Infopath or by developing Apps.
 
Rgds/-
0
Comment
Question by:sharepointDepot
  • 7
  • 5
12 Comments
 
LVL 28

Expert Comment

by:clayfox
ID: 39662608
This certainly can be done with Infopath, since you can query previous submissions by user and date.

just need to plan out your design, etc

www.servbus.com provides hosted forms in the cloud if needed.
0
 

Author Comment

by:sharepointDepot
ID: 39665003
Hi,
My concern is - i am using sharepoint online , an office 365 subcriptions.
so I must use codeless solutions only, so I can validate on data present there itself on form.
but...
for piece of data  present already on a list, how can i validate the form before submission.

the other product I will check for other project.
Rgds/-
0
 
LVL 28

Expert Comment

by:clayfox
ID: 39665604
Yah no code is needed.  Both are compatible with O365.  You create a data connection to the list and query and filter to check for existing values.
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 

Author Comment

by:sharepointDepot
ID: 39665759
Hi,
 I know-with SharePoint lists: you can bind to views based on lists.
 http://littletalk.wordpress.com/2010/08/20/infopath-data-connection-to-sharepoint-list-view/
 
but need 1 suggestion here-
 On my form, there are 4 person fields...    Employee, Manager-1,Manager-2 ,Manager-3,
 Now all these 4 guys opens the form sequentially...
 ..so whoever opens the form,I want to show items related to Employee only ?

Thnx
0
 
LVL 28

Accepted Solution

by:
clayfox earned 200 total points
ID: 39665799
Best practice is to have fields in your form schema that tracks the state, or possible who last updated the form.

Then have rule on form load that look at the state and switch the view or hide sections based upon who is reviewing or what stage the process is in.
0
 

Author Comment

by:sharepointDepot
ID: 39665944
Hi,
yes i have requiredfields in form schema,
i have rule that wsitch the view,
but all the participants required to review the same list items,
sorry to elaborate..
 if user1 loogins to sharepoint site, and opens IP form,
he see his data--all correct.
what problem i faced is-
if user2 logins then also user1 data is displayed.
 
Rgds/-
0
 
LVL 28

Expert Comment

by:clayfox
ID: 39666046
The issue is that you need to create separate views or setup sections to hide based on the user so that each gets the experience you want.
0
 

Author Comment

by:sharepointDepot
ID: 39666101
Hi,
No there is if extra data, then I can hide it.
But for 2nd user, there is no data created by 1st user, whuch the other users are reviewing.
Rgds/-
0
 

Author Comment

by:sharepointDepot
ID: 39666898
You want to dynamically pull all the invoices for a specific customer into a single form
http://blogs.msdn.com/b/infopath/archive/2010/06/03/how-to-pass-querystring-data-into-an-infopath-form.aspx
Rgds/-
0
 

Author Comment

by:sharepointDepot
ID: 39678719
Hi,
I want to query or filter a sharepoint list data based on a textfield on the form.
thnks
0
 
LVL 28

Expert Comment

by:clayfox
ID: 39678771
You can add formatting rules to the controls or sections and make them conditional on the values of fields. Then the action is hide.

so when condition is true, the control will be hidden.
0
 

Author Comment

by:sharepointDepot
ID: 39796177
Hi,
I was looking for query data for initiator of form, i was able to show this particulat users data on forms previously also.
Now, I used set Field value in the Query part-and this I used for my all Form Load queries.

So at all views,I am able to show the initiators data.
Rgds/-
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Email Headers 5 57
Office 365 and Outlook 2010 4 42
Access 2016 importing text files 13 21
Importing contacts into Office 365 Outlook 12 30
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Read this checklist to learn more about the 15 things you should never include in an email signature.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

776 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