I can’t believe I finally found what could be the solution we are looking for. I’m seeking help from a Monday.com expert please.
We send automated emails staff (Monday.com item owner) when items are due for action. We populate an automated email from Monday.com to the item owner and include item/column details etc. But, we’ve never been able to work out how to add a hyperlink in the email, to take the staff member immediately back to the specific item in Monday.com.
(As is, today, the staff member copies and pastes item ID from their email, and then searches for it in Monday.com to show the item. We want to skip this copy+paste+search step if we can).
However, coding is not my thing. The solution above uses the concatenate formula.
Whilst I understand the concatenate feature in XLS and the concept of using it to build a URL.But, I come unstuck adding the components. e.g. My board is called “Xiangpai Pipeline”, the board number is “6128766440”, our Monday URL is “smithandsmithlighting.monday.com”, but I dont know how to add this into the concatenate formula, nor where to obtain the “viewsid”, “pulses” or “itemID” info/fields.
I hoping so much someone online may be able to offer me assistance to solve our long sought after goal please.
If you’d be using the Advanced Formula Booster app, you’d be able to dynamically create the url for each item using this function without adding an Id column.
The first 2 lines are not absolutely necessary. You could use the GETBOARDID and GETITEMID functions (one of the many custom functions the app adds to monday) directly in the CONCATENATE function.
Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.
Create formulas without using the Formula column (and avoid its limitations)
Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
In one formula, update multiple columns from multiple items.
So every board has it’s own board ID and url. Open an item on the board you need the link for. Copy the whole url, up to and including the last ‘/’. When creating your automation, paste that portion of the link and put the Item ID (you might need to add the item ID column), right at the end of the automation. Example below.
Hey Desiree, thank you so much for taking your time to reply.
We set our automations up at a board level, so the url/link to back to the item needs to be dynamic. i.e. we dont create automations for each item we create. Does that make sense?
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
6
Hi Gavin,
Remove the = sign in front.
What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.
