Hi everyone!I am trying to find the right approach to calculate the number of consecutive unattended days at course by a same student.I currently have a "participation" table. It is a junction table with: The date (date field) - The Student (link rec...
Context:I have three tables. Customers, subscriptions, and orders. A customer can have multiple subscriptions, and a subscription can have multiple orders. Every time a customer fills out the order form, it is created in the order table. So a 1-month...
I am using the Gantt view. I have 50 tasks. Every 10 tasks has a milestone. And each set of tasks is marked as dependencies for each milestone they come under. I would like the milestone dates to be updated automatically when the end dates for one o...
Hello!I'm hoping you guys can help. I'm a total newb with formulas.I'm trying to build a animal shelter manager and usually we don't have the exact date of birth. Just an approximate age (ie, 2 years, 5 months, 4 days, etc.). Is there a formula that ...
Hey there,I'm new to Airtable and want to count all the checked boxes in one column. Anyone know how to do this? Please help! Thanks in advance.Dorus
Not sure where the correct place to put this one is. I am trying to get a formula or automation to update the period field in the attached screenshot based on the cadence. I have tried using automations, but it essentially circular references itself ...
I import data into a table, and one of the fields is a booking number, which is unique.How can I make this field unique, that the import doesn't import the same ID including all the other data several times? Thank you,
Hi,I use a numeric field and sort my linked records in the Interface Designer based on the numeric field. I have some automations that set the number of new records and users can also manually renumber records. This works well for creating records on...
We are moving student metrics to Airtable and I am trying to create a backlog of attendance records for our students since they started. (we have two campus's with seperate start dates). I have an automation working fine for populating records with e...
What is best practice to sort records for inclusion in a map ? I used a multiple choice checkbox but cant get anything to work. I have a database for dealers for a product and one of the fields is "STATUS" this is a multiple choice field...if it is...
Hi fellow Airtable enthusiasts!Does someone know if there's a way to flag records created or update by the API? Currently, we have a few integrations using the API, that are authorised by a certain user in Airtable. I'd like to flag those using a for...
Is there at the moment any formula, function, working script or any else working solution to deal with a rental activity? (we need do track what is available or not, when it is available or not, who rented what etc. not only checking calendar view, b...
Hi there,I'm trying to get an Airtable and Monday.com integration working with a basic 'if this pulse changes on a board, find the record in Airtable and update'.I'm doing this with Make.com. My first step is a watch trigger that passes items which h...
I created this post a couple of years ago and we're still hitting a wall trying to figure out the best way to accomplish this: Dynamic formula to change output based on username viewing the tableI have started thinking about using an external no-code...
Let me describe my issue with a mock-up.I have a database with two tables: People and Projects. People are linked to Projects (people can be on multiple projects and vice-versa). I want to have an information how many People in common each pair of pr...
How do I know if I submitted a form through Airtable? I received a copy of my responses, but I don’t know if this means my firm was submitted or not since I didn’t get a confirmation. Thank you!
Hi Community,I am pulling information from multiple records in a sync'd base into one record in a new base. By doing this I getting multiple images associated with this record, which I love. However some images are associated with multiple records in...
I have a column {Sentence with Plain Value}, whenever a value that is listed in column {Plain Value} exists, I want it replaced with the value in column {Value with R Ball} and outputted with other initial values in the sentence. For example:I love t...
Hi All,Hope someone can help!In our base we have multiple Proposals (in one table) linked to each single Sales Opportunity (in another table).I would like the proposal's naming convention to be "{Sales Opportunity} - Proposal 1", with any further Pro...
Hi Community,New to Airtable and trying to put together an inventory tracking system. I followed some video's on YouTube and created 4 separate tables. Equipment (i.e. models), Received, Issued, and Disposition. I have a form that will intake when...
