Monday app with automations released

basdebruin · July 9, 2020, 5:47pm

Two monday partners Excellent Team by @basdebruin and YvPM by @PedroM joined forces and developed a monday app with several integrations / automations. We get our inspirations to build these from feature request we often see in this community.

The current automations are:

Vote to Group, this moves an item to a specified group when it reaches a specified number of votes. It is great for gathering ideas and to automatically put the top voted ideas into a separate group in your board.

image1236×126 10.8 KB
AutoID column. A feature request we often see is to have a unique number for each item on a board (not being the itemid). This automation does exactly that: you can specify the number layout, the starting number and the preceding text and the automation creates the unique id. Great for numbering invoices (INV-1001) or ideas (IDEA-001) or anything else you can think of.

image1233×137 16.1 KB

The frontend of these apps are created with monday apps and the necessary backend is developed in NodeJS and runs on a dedicated webserver.

The features of this app are detailed in our shop at https://excellent-team.nl/solutions/ and soon you will also find small videos how these automations work. On the same site you well find the share link to add the app into your own monday.com account,

By default all automations has a free trial period of 10 days. As an introduction we currently offer a 30 days free trial period.

If you have any ideas for likewise automations, just let us know by:

Create a post at https://excellent-team.nl/boards/general-qa/
Send an email to mailto:info@excellent-team.nl

rob · July 9, 2020, 10:04pm

Great job, @basdebruin!

basdebruin · July 10, 2020, 6:48pm

Another automation feature is added to the app. Simply change a status and the Start and End dates will be converted to a Timeline column.

basdebruin · July 17, 2020, 4:00pm

Today we released two brand new features in our Excellent Team app. Here are the configuration sentences.

Both features are designed for scenarios where you have a master board (1 item describing the detailed (project) board) and any number of detailed boards. This add master - detail relationship to monday.com.

The Detailed boards contains a [MatchID] in the board title and the master board contains a column holding the MatchID’s for the detailed boards. The recipe(s) are added and configured to the detailed boards. When a change occurs on either a status or a number column in the detailed board the recipe sends (depending on which recipe you configured):

The % of status (e.g. Done) within the selected group of the detailed board
The average number of a column within the selected group of the detailed board

Use cases: get an overview of the % of completion (status) or get the average satisfaction for a project when the project manager sends a satisfaction survey form to his stakeholders. You can achieve the same kind of functionality with dashboards views, but is some cases building a dashboard is too much or you hit the maximum number of boards in a dashboard.

If you come up with more columns that can be reported to a master you get a 50% discount on the next feature

Happy detailing

amir · August 22, 2020, 10:30am

Hi Bas,

We are starting to collect app nominations for the upcoming beta phase of the marketplace - let me know if this is of interest to you.

Best,
Amir.

basdebruin · August 22, 2020, 11:41am

Hi @amir

Thank your for the notice. Indeed I saw the announcement and I would be very keen to enter the beta phase of the marketplace. However, I promised my users a new version of my apps on August 28th and that is stiil the plan. Due to a confirmed bug in monday.com my app will be limited in functionality until this gets resolved. With that uncertainty it would be better for all of us if I do not enter the beta phase yet. Hope to join you soon when the “multiple custom field in one recipe” bug is solved.

amir · August 22, 2020, 12:22pm

Hi @basdebruin - got your point and sent you an email to discuss.

Best,
Amir.

Cait · October 9, 2020, 1:08am

Hi, this sounds really neat! I’ve added the app from the marketplace, and then I found the integration. Do I need both activated to use this automation?

basdebruin · October 9, 2020, 7:05am

hi @Cait
Please DM me with an email address so I can walk you through the setup

basdebruin · November 11, 2020, 10:10am

With the release of the fantastic marketplace we discussed out apps with the monday marketplace team. Our apps are now available in the marketplace as separate apps as opposed to our first idea to put all integrations in one app.

Therefore the single app as mentioned here will be replaced.

When you already use the single app which contains all recipes, you can change to the separate apps by deleting the single app and install the separate apps from the marketplace. Of course your purchase history is maintained. Somewhere in Q4 2020 we will unpublish the single app and it can’t be used. The list op apps is extending and can be found in the marketplace, on our website at https://excellent-team.nl/solutions/ or through these links:

AutoID Column: https://auth.monday.com/oauth2/authorize?client_id=1b56a65b7fd999693e15d39973646c21&response_type=install
Start + End = Timeline (now bidirectional and soon with full sync): https://auth.monday.com/oauth2/authorize?client_id=eb5077efff67bdb6b593d09d0b0b6889&response_type=install
Status Controlled Groups (NEW): https://auth.monday.com/oauth2/authorize?client_id=3e0ff4cd36411bc717afede35a2e3fbe&response_type=install
Vote To Group: https://auth.monday.com/oauth2/authorize?client_id=bd73ed6414c5ab6a7137c7dbdd169d14&response_type=install

The Master-Detail app is undergoing a major redesign to make it easier to use and to allow different templates for detailed boards. The new version will be release before the end of 2020.

@amir @Ben

basdebruin · December 11, 2020, 4:51pm

The above mentioned apps:

AutoID Column
Start + End = Timeline
Status Controlled Groups
Vote To Group

are all available in the monday.com marketplace. The apps have been updated to use seamless authorization which makes the configuration faster and adds to the security level as the app does not store access tokens anymore.

The predecessor of the Master-Detail app will be available on the marketplace soon. This app is called Rollup Multiple Boards and you can read more about it here: https://excellent-team.nl/solutions/rollup-multiple-boards/

basdebruin · December 23, 2020, 11:13pm

Happy holiday season (and please stay healty). Happy to announce some new apps and enhancements.

Rollup Multiple Boards - is now moving out of Beta and is available through the https://excellent-team.nl website. The RMB app is currently in review for the marketplace.

Date Controlled Groups - this app in now entering Beta phase and is available on the same website. With Date Controlled Groups your items are reordered at the specified schedule and moved to groups based on the “time left until deadline”. The move will only take place at the time(s) set in the scheduler recipe. With this you can easily transform your groups to buckets with specified priorities.

AutoID Column - is just enhanced, see below.

NEW: From now on you can enter fields in the text box (this text) in between curly brackets {}. Supported fields are:

{year} – the current year in 4-digit notation
{quarter} - the current quarter
{month} - the current month in 2-digit notation
{id} – the generated ID

When {id} is omitted the generated ID is appended to the end of the string specified in this text. This is the original behavior.

The field {columnid} can be used to replace this part of the string with the value found in the column with the entered columnid.

Warning : {columnid} needs to be the id of a text column (not the name of the column). You can find the columnids by activating Developer mode in monday.com. (Avatar > monday.labs > Developer mode > Activate).

Warning : the {columnid} field only works when the newly created item has a value in the specified column. This can be achieved with: using monday.com forms, using “Item default values” or by duplicating an existing item. When there is no value found in the specified column the field {columnid} will be ignored.

basdebruin · April 18, 2021, 9:58pm

The Rollup Multiple Boards has been updated. It now support adding existing boards to the solution as well as adding columns to templates and all connected board in one go. Check it out at 20|Rollup Multiple Boards | Excellent Team

When combined with our app Filter multiple Boards (found here 25|Filter Multiple Boards | Excellent Team) you can build almost any master - detail board setup you can dream of.