Profile Pictures ()
Here’s an idea I wanted to try, and I’m so stoked it worked.
How the Profile pictures work
For MAXIMUM compatibility, we’re using Gravatar to fetch a profile pic for each user based on their email address. In that URL we specify a “fallback image” in case there isn’t a profile picture loaded for that specific email address. We use the Clearbit logo (the logo of the company the user works for) as the fallback image for Gravatar.
Clearbit logo
Clearbit is a logo image service. You supply a company’s primary URL and it returns an image of the company’s logo. Format of logo:
spotify.com The domain name of the company whose logo you want to fetch Gravatar Logo
Gravatar is a “profile picture” service that’s plugged into WordPress (I think they’re maybe from the same people. It’s used to link an email address to a profile picture. The original idea is that some poor people will be admins of multiple WordPress sites, so instead of forcing them to upload a picture for each admin panel, rather do it once and we’ll attach that image to their email address from now on Because it’s kinda the defacto standard, a lot of email addresses are linked to a profile pic on Gravatar. If you want to link yours, head over to and upload your own (you’ll need to verify you’re the owner of that email address) Format of profile pic:
3fa8c...e43 An MD5 hash of the user’s email address 200 The size of the image to retrun https://website...image.jpg A URL to an image that will be used as the “fallback image” if the user doesn’t have a Gravatar image loaded for their email address
Pre-Meeting People to Discuss
This interface is an interface proposal for selecting people to discuss.
The Filter Bar allows the user to select between:
All. All people in the org’s list Mine. Only people who the user is responsible for Last Week. The people the user selected last week
User can click on Discuss and it’ll change to SELECTED
Conditional formatting switches to green.
The cards display the user’s profile pic (or company logo) and the look of the text is stylized with
Card Face
The card face is generated using a template from . Card(
Image(
thisRow.[Gravatar],
70, 70
),
" ",
Format(
@TEMPLATE H1+h3.[Template],
thisRow.[First],
thisRow.[Last]
)
)
Card() renders each parameter as a cell in a horizontal table
First cell:
Image() renders the gravatar image at 70x70 pixels
Second cell:
" " blank string adds space between image and name
Third cell
Format() renders a template, replacing placeholders with actual text. In this case, we just add the FIRST and LAST name.