Wayne_Olson - profile

Wayne_Olson · Oct 22, 2018

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 ...

Wayne_Olson · Oct 23, 2018

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...

Wayne_Olson · Oct 23, 2018

There’s no option, and I believe that option is only available if the output from the formula is a date.

Wayne_Olson · Oct 22, 2018

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”).

Wayne_Olson · Oct 22, 2018

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 ...

Wayne_Olson · Oct 22, 2018

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.

User Statistics

User Activity

DATETIME_DIFF() and Incorrect Timezone

Re: DATETIME_DIFF() and Incorrect Timezone

Re: DATETIME_DIFF() and Incorrect Timezone

Re: DATETIME_DIFF() and Incorrect Timezone

Re: Printing address labels

Re: Printing address labels