Michael_Morris2 - profile

Michael_Morris2 · Jun 07, 2024

How can I do a negative filter? Let's say I have a multiple select field with letters A-E. I can easily filter to show all records that contain all of D, E, and F. But I want to filter OUT all records that contain all of D, E, and F. Just D is fine, ...

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 · Jun 07, 2024

I figured it out. My brain hurts trying to figure out why it works, but it works. I grouped: "has none of D or has none of E or has none of F." Thanks for talking me through it.

Michael_Morris2 · Jun 07, 2024

Thanks Dan for the quick reply. I don't think that would work for my situation. I want to say "Don't use any record with ALL of D, E, and F."Using "any of" would not allow for records with just D or just D and E.Using "contains" I believe would have ...

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

User Statistics

User Activity

Filter: Does NOT have all of...

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

Re: Filter: Does NOT have all of...

Re: Filter: Does NOT have all of...

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