+44(0)1908 545 770
YOUR EXPERT RPA PARTNER

Team up with our RPA strategy and tech specialists for maximum automation impact

Find out more
Harness the power of UiPath in your business.
WATCH NOW

Save money and spend more time on priority work.

Book consultation
READY, SET, AUTOMATE

Let's choose, design and deploy a process automation solution for your business.

Find out more
TRANSFORM YOUR BUSINESS

Let's analyse your business to discover opportunities for innovation and automation.

Find out more

Begin your business transformation journey

Book consultation
AUTOMATE EVERY FUNCTION

Automate where it matters most. Scale to solve challenges in every area

Find out more
GIVE EVERY TEAM THE TOOLS FOR SUCCESS

Equip people with user-friendly solutions that save time and make work easier

Find out more

Which business problem
can we solve first?

Book consultation
06 February 2018

Dynamic Mini Calendar using K2 and SQL

K2 smartforms and the K2 community controls do not have a lightweight mini calendar control for the dynamic presentation of dates, in a colorful format.  For example, you might have a requirement to highlight a particular date, using a colour, which varies on the event type. Conditional formatting in smartforms can be used to achieve something similar, but not within a calendar control.

K2 Automated Testing Software

rnBenchQA allows full test automation of K2, including fully automated K2 SmartForms and K2 Workflow testing. It promotes test driven development for K2 and ensures continued quality assurance for K2 solutions. Easily apply changes to test cases to accommodate changes to K2 apps and ensure all apps are regression tested to avoid defects and assure continuous quality.

Free K2 Five Upgrade Review

Solution

We can easily achieve this by using HTML 5 generated by a database query that transforms the results into HTML. This is made available using a K2 smartobject. It’s a sophisticated way to represent all the important dates visually, instead of showing them in a list view. Performance is also improved because the calendar is rendered client side.

Watch our short demo to learn how this can be done.

Need further technical advice or support?