Hi! I am unsure if it is possible to create a formula to make this work for my school, please help!I have a base created to track all applicants. We offer 5 trade classes each held 3 times a year that have a minimum age requirement; age 16yrs and 8mt...
We have a database of transactions that is monthly via csv import. This contains information like transaction id, amount, duration.Most transactions are simple one-time occurrences; however, some transactions happen over the span of months.For these ...
Hi there, i'm having issues with letters' case in my filterByFormula text and API call.I'm trying to do a searching box where user can give an input of what they are looking for, and Airtable fetches from a big database. Right now if i'm looking for ...
I have a table linked to itselfA Lookup field type still works fineBut a Count field type always returns the value 1 when in some cases it should be more than 1
I have a field where people can enter a birthdate. I want that to show up on a calendar view in Airtable. Unless the year is the current year, it's not showing up on the calendar. I tried using a formula field but then I can't get the formula field t...
I'm a bit stuck. The end goal is that I can determine how much everyone should be paying in a house depending on the conditions of the room, the minimum price of payment, and the number of people within a room. --Information: I have 1 airtable with ...
Hey,Something super basic to do in any excel, python script etc. but how to get in in Airtable?I want to create some kind of ID for each customer. First customer has number 900100, and each new one (this is a child table) should get the number +100, ...
Looking for some help regarding a formula. Here's a little context of what I am trying to do. I am working on importing my teams marketing budget plans into Airtable, and so far everything is working well. As a final step, and in order to avoid have ...
I have a rollup cell that is pulling a range of data from another sheet. Is there a way to:1) Format these so it's easier to read : MM/DD/YY-MM/DD/YY 2) Format these so I can create a calendar view that would show these dates in a row on the calenda...
Apologies in advance if this was answered elsewhere, I did try to find it.I have a lookup cell that is pulling information from another sheet. In that other sheet, the cells all share an attribute called “Daily Flow.” I’m wondering if there’s a way ...
