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