GSSJC_Backpacki - profile

GSSJC_Backpacki · Feb 05, 2017

In an effort to move from Excel to Airtable, I need to see if it is possible for Airtable to calculate grade based on a birthdate. For example, here is my Excel formula (sorry it is a bit nightmarish): =IF(MONTH(A1)<9,IF(MONTH(TODAY())<9,YEAR(TODAY()...

GSSJC_Backpacki · May 17, 2017

I would also like to see date range filtering. The current options are very limited. I need to be able to set to filter results from Jan 1 through June 1, for example.

GSSJC_Backpacki · May 01, 2017

This would be very useful. Not just for the scenario described but to stop a new field from appearing in many views when it was created and only needed in one. I have to always go back through and remember to remove the added field from other views.

GSSJC_Backpacki · Feb 20, 2017

This would be an awesome addition and allow AirTable to get a solid leg up over Google Forms.

GSSJC_Backpacki · Feb 07, 2017

That worked perfect! Thank you so much!

User Statistics

User Activity

Formula to calculate school grade based on birthdate

Re: Date Range Filtering

Re: Completely Hide Fields

Re: [SOLVED] Add Conditional Logic to Form Views

Re: Formula to calculate school grade based on birthdate