Michael_Morris2 - profile

Michael_Morris2 · Feb 27, 2023

Seems like it should be easy. I want to display the "Ending Balance" field from my most recent record. The summary type for monetary records doesn't have an option for most recent record. But the date record does have that option. So I can display th...

Michael_Morris2 · Jan 18, 2023

I have a field of numbers somewhere between 1-100, I'll call the field "MAX" and sort high-low. I want to be able to count the total number of records in this field, and pick the lowest numeric record of a certain percent, let's say 80%.For an exampl...

Michael_Morris2 · Aug 02, 2020

I have lots of tables and views. I’d love to see maybe a drop down at the top of the base to select favorite views for ones I go to frequently.

Michael_Morris2 · Jun 29, 2020

I have created a formula referencing key dates that returns the values of “Past”, “Present”, or “Future”. I would like to filter a view showing only “Present” or “Future” records. I also want to filter out any record where the status is “Rejected” I ...

Michael_Morris2 · May 24, 2020

I didn’t know how to say this concisely in the subject line. It’s nice that groups have the options for sum, average, etc of that group. However, I’d like to be able to change the calculation of the entire view separately from the groups. Let me give...

Michael_Morris2 · Mar 13, 2023

I think I responded too soon. I see that all I have to do is add to the "Rollup" each time from the main table. Yeah, I think that will work. Thank you!

Michael_Morris2 · Mar 13, 2023

Thank you for your response. I am getting it to work, but do you need to manually add each date to the rollup? Seems like it would be easy on AirTable's end just to add a "Most Recent" to the summary field options!

Michael_Morris2 · Oct 07, 2020

Hi Zac, Shoot. I had typed out the solution (below) then realized it won’t work for you. Maybe somebody else can chime in? My work around works for me because I was sorting by a single date (start date) associated with each project whereas you want t...

Michael_Morris2 · Aug 02, 2020

Yes, please on wrappable column titles

Michael_Morris2 · Jun 29, 2020

Thanks so much for your help! It took me awhile to find that you have an extra comma after the “NOT” line, but I figured it out. This is a little more cumbersome than using the filter settings, but your solution does exactly what I wanted!

User Statistics

User Activity

in Interface, how do I show my current $ balance?

Can I return a specific record (like Record #6) from a field?

Favorite Views suggestion

How to filter view by multiple text strings

Grouped items suggestion

Re: in Interface, how do I show my current $ balance?

Re: in Interface, how do I show my current $ balance?

Re: When grouping records, be able to sort by summary fields

Re: Wrappable Column Titles

Re: How to filter view by multiple text strings