The Community will be undergoing maintenance from Friday February 21 - Friday, February 29 and will be "read only" during this time. To learn more, check out our Announcements blog post.
Hey there, Airtable Experts…
I have created a simple task table where I am attempting to use a formula field to automatically categorize individual tasks based on their due dates, i.e., Overdue, Due Today, Due Soon (2 days or less), etc. I have used ...
Jeremy_Oglesby:
This is kind of a round-about, hackey way to do this, but it may serve to verify what’s going on…
Try creating another formula field called “Today” with this formula:
DATETIME_FORMAT(
TODAY(),
'l'
)
And check to see that i...
Thanks, @Jeremy_Oglesby, but I do not see that option in the Formula field anywhere, presumably because the output options for that field are not dates but text (e.g., “2. Today”).
Unfortunately, the only way to get labels from contact data in Airtable is to export a CSV and then load into mail merge (I use the Avery Chrome extension with Google Docs).
One thing I’ve done to handle the issue of mailing to contacts with spouses ...
Great idea, but unfortunately this doesn’t work with Avery labels, as the margins around each label are not uniform, and you can’t control the individual margins when outputting to print in Airtable.