Hi, I'm new to Airtable and I'm setting up Bases for a company with multiple teams (marketing, sales, project management, asset management & finance). When I set up Bases, is it best to set up separate Bases for each team or to have one Base with mul...
Hi! So I have fieldA that contains a string of numbers & separators, rolled up from another table (e.g. "10|15|22").I then have fieldB that contains an integer.I need to be able to split the string, compare each number to that in fieldB and add the n...
Hello, I am new to airtable and handling our base. The person who built our base left out a column of data that is critical. I need to know how I can import data from an excel file that adds the data needed instead of making all new entries. Thank...
Hi AT communityI once again appeal to you for assistance, please.We are a performing arts company who provide entertainment for events. An event can book one or more performances which can be of the same type or different types. These types are impor...
I have a customer (athlete) table that is one row per customer. And a comms table, that logs when each customer posts something in our community (circle) via Zapier.Then, in the customer table I use a rollup to display the date of each customer's las...
I have a 'customer' table (one row per customer - name, email etc), and I have a 'contact' table that records the date of every instance of a customer contacting us (customer ID, date of contact etc). How would I pull in 'date of contact' into the cu...
Hello all! You guys have been so helpful in the past, I've got a new question to share tonight! I am working on a base to track finances. We categorize all our expenses (and income) and then budget for those categories. I need to assign a categor...
Hello again! I am developing a base for use in tracking personal financial budgets. If it works well, we will probably adapt it for use with our non-profit as well. Here's the general structure:TablesCategories (I call them buckets)TransactionsDes...
Hello All.In table A I have all of my outbound communications listed. In this table there is a field called "Month Sent", this field is used to link table A & table B. Table B contains the aggregations of all the communications sent per month (Month ...
I am a newish user on a pro plan and in the 5 months i've been using Airtable i not only learned a lot but definitely have learned how to make more complicated tables and ways that our organization can use it. However, now that more of our operations...
