Adam,
You are correct. It is Slack.
In the pipeline for that specific "Date" field to show in Slack without the timestamp zeros, it would be entered like this:
*Date Scheduled:* `{{a.date_scheduled|date_mdy}}`
You must add the |date_mdy after the QuickBase field name and it will display in Slack as mdy format.
Here is a link for the Slack message formats.
https://slack.com/help/articles/202288908-Format-your-messages------------------------------
Darin Wagner
------------------------------
Original Message:
Sent: 07-18-2020 03:20
From: Adam Parker
Subject: Pipelines Slack Channel
Not sure how this worked for you, but Slack did not recognize this formatting for me and spit out the full text, "<ahref" stuff and all.
If you are comfortable with a clickable full link URL being displayed, try this:
1. Make a Formula URL field called [Link to Record for Slack] (or something like that)
2. Make the value:
URLRoot() & "db/" & Dbid() & "?a=dr" &
"&rid=" & [Record ID#]
3. Add this field [Link to Record for Slack] to your pipeline delivery.
My results came out like you see below.
The URL was clickable, because of Slack's URL handling in chats.
-------------------------------------------------
James has created a new job!
Client: Nike
Job Code: NIK_0720_152
Estimated Start Date: 2020-07-22 00:00:00+00:00
----------------------
Link: https://xxxxxx.quickbase.com/db/xxxxxx?a=dr&rid=123
This bold items are fields mapped from the pipeline.
NOW if anyone knows how to get ride of those timestamp zeroes, I'd love to hear it. The field they are pulling from is Date (not time) field, so I think it's Slack.
------------------------------
Adam Parker
Original Message:
Sent: 03-30-2020 12:17
From: Mark Shnier (YQC)
Subject: Pipelines Slack Channel
I don't know much about slack, but assuming that it can accept a hyperlink, then you can make a Formula Rich text field with this syntax.
var text Words = "the words the user would click on";
var text URL = URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#];
"<a href=" & $URL & ">" & $Words & "</a>"
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
Original Message:
Sent: 03-30-2020 12:13
From: Ashley Harris
Subject: Pipelines Slack Channel
I have created a Pipeline between QB and Slack, so that when a Record is Created in QB a message is sent to a Channel in Slack. How do I include a link to the QB Record in the Slack message?
------------------------------
Ashley Harris
------------------------------