SharePoint components - business processes without development, InfoPath, SharePoint Designer or workflows. SharePoint Services, SharePoint Foundation & SharePoint Server 2010-2016.

September 2016
Current page:
 

SharePoint Automation From the Browser

By: Garrett Curtis | Comments [0] | Category: General | 9/25/2016

With the recent announcement that both SharePoint Designer 2013 and Infopath 2013 will be the final versions of the software going forward, many of you are no doubt concerned about the future of SharePoint customization. Thankfully, rather than having to resort to custom solutions from Visual Studio, a must more efficient option is available with Infowise Ultimate Forms.  

Using this toolset, you can create very powerful business automation tools right from the browser itself, with no code! Have a look at this 30-minute presentation detailing some of the features of Infowise Ultimate Forms as well as a look at the process of customization from the browser.

If you are interested to hear more about what can be achieved with this toolset, please don’t hesitate to reach out to me at gcurtis@infowisesolutions.com.

 

 

Permissions through a lookup column

By: Vladi Gubler | Comments [0] | Category: Products | 9/8/2016

Hi,

We added a new feature to the app version, that was already present in the on-premises version for quite some time, but I'm not sure many people were aware of. It's an extremely powerful feature that helps create sophisticated application in virtually no time.

Consider the following scenario. I'm creating a vacation request form. I'm filling in my details, start and end date of the vacation and the department I belong to. The Department field is a lookup to the list of departments. Once submitted, the form needs to be approved by the department head, who is different for each department. The approval is done through a second tab, that is only opened for editing for the appropriate department head. How can we do it easily with Ultimate Forms.

You can use permissions rules based on lookup columns. In the source list of the lookup we will add a Person or Group column, in our case Manager column in the Departments list. In that column we will specify the manager for each department. We will then create a Write permission rule and assign it to the column Department. As it's a lookup column, our product will show a selector for the secondary, Person column from the source list of the lookup, in our case, Departments. Select our Manager column there and that's it! The correct manager only will be allowed to approve the request.

And of course, pictures are worth 1000 words.

The Departments list will look like this:

Now, we set permissions on our Approval tab in the Vacation Requests list:

Now we are ready to see some results. When I open a request for a department where I am the manager:

As you can see, I can edit the approval status. But what happens when I edit a request where I am not the department manager:

The tab is now locked down and I can't edit it. Pretty cool, right? :)