Mike_Buck - profile

Mike_Buck · Jun 17, 2024

Is there anyway to do a sum of averages within a selection using the number boxes?Bottom grey number on the left is what I'm trying to tweak. Over the last 12 months, I've sold 663 units for a total of $4,107,840 (bottom two green #'s). I need to s...

Mike_Buck · Mar 07, 2024

Hard to believe, but iPad quality of life re: Airtable is worse today than it’s ever been? My M1 Air running 17.4 does everything else I need it do, but the app is useless and the website looks ok upon first loading…. But I can’t even switch tables…...

Mike_Buck · Oct 17, 2023

So I'm tracking vehicles in my base(s), and I typically use a formula for my primary field for ease of search for my coworkers: CONCATENATE("Branch #"," ",Location," ",Year," ",Make," ",Model," ",VIN) Ends up yielding something like Branch #123 2022...

Mike_Buck · Aug 29, 2023

I have a formula that works as is today, but I'm trying to add a condition to it and it keeps erroring out? Was hoping to get some extra eyes on it?What we're doing today is taking 3 different date fields, convert them to a #, and then display the m...

Mike_Buck · Apr 25, 2022

So I’ve got a base that I want to run a form out of. The table that the form is within has a link to another table that contains our product inventory, which is selectable within the form. What I’m trying to do is use a second field, a lookup value ...

Mike_Buck · Oct 18, 2023

Thanks Scott. Is it possible to use multiple single selects the same way? Like if I wanted the IF statement to apply to several different of the single select options, not just On Order? IF({Status}="On Order",{Airtable Order ID},CONCATENATE("Branc...

Mike_Buck · Sep 05, 2023

Go into edit mode, and when you see the option to add new layers, if you hover your mouse over the one(s) you want to delete you'll see three dots. Click those dots and delete is an option.Agree its not super intuitive to find.

Mike_Buck · Aug 31, 2023

Thank you!

Mike_Buck · Apr 26, 2022

Its a hassle, but I think the easiest way to do it is to use concatenate to merge product ID and type into a single field “11821 - Soap” and use THAT as the linked value, and then use conditional logic on the text included.

Mike_Buck · Apr 26, 2022

Appreciate the suggestion, but thats what I’m trying to avoid. I don’t want the user to be able to select type - I want it auto selected for them after they choose the product.

User Statistics

User Activity

Field Summary - Sum of Averages?

iPad experience is worse today than previously

IF Statement using Single Select selection

formula to determine the max of multiple date values

Using a lookup value as a conditional step in a form?

Re: IF Statement using Single Select selection

Re: How to delete an interface LAYOUT

Re: formula to determine the max of multiple date values

Re: Using a lookup value as a conditional step in a form?

Re: Using a lookup value as a conditional step in a form?