Michael_Morris2 - profile

Michael_Morris2 · Aug 28, 2024

Up until yesterday, when I changed a filtering option, the table would automatically update. Now it doesn't and I have to hit apply to see the changes.I use filtering a lot to test my data - I look at a summation field and check, for example, what is...

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 · Aug 29, 2024

This is it! I had been adding several new fields when this became an issue. You had 491,150 cells (fields * records) and I had 558,108. I deleted a bunch of old fields that I no longer use, getting me down to 486,459 cells, hit refresh, and Apply wen...

Michael_Morris2 · Aug 28, 2024

Thanks Scott. I don't think I have any dependencies on this filter. This seems to be an issue for me on all my tables in this database. If it was a dependency issue, wouldn't it only apply to particular tables? Interestingly, I did check another data...

Michael_Morris2 · Aug 28, 2024

Thanks for your tips. I don't understand how to switch between filtering modes. I looked it up and found things on dynamic filtering, but it looks like it maybe only applies to linked records? This is not my case. I tried a different browser with the...

Michael_Morris2 · Aug 11, 2024

This suggestion deserves a bump. I would also find it very helpful to display a formula field in a form as a way to validate my data. For example, is the first number greater than the second number? Or to be used to show a total.

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.

User Statistics

User Activity

Filtering no longer dynamically updates

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

Re: Filtering no longer dynamically updates

Re: Filtering no longer dynamically updates

Re: Filtering no longer dynamically updates

Re: Allow formula fields to be included in forms

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