Base Design

Hi Airtable Community, I have the following problem:I have a Projects table with columns Assigned Budget 25, Assigned Budget 26 etc.I also have a table “Orders” which is linked to the project table. This means that several purchase orders can be assigned to one project. Each purchase order is also linked to table 3 Financial budget.So there are projects that can have several financial budgets. Each project can have different purchase orders which can also run on different financial budgets.However, the projects are not directly linked to the financial budget.Projects to Orders (1 to n)Orders to financial budgets (1 to 1)Now I would like to have the sum of all assigned budgets for each calendar year in the Financial budgets table. So I need to somehow get the values from the Projects table into the Assigned Budget table.Any ideas?Thanks & bestMirko 

Noob here. Frankly don't know where to start, and my mind is whirling with the results in the community, so let me describe what I'm going for.I've created a form that allows my community to report data in four areas for a health challenge: calories consumed, exercise calories, water consumption, and sleep hours. There's also the date and the person's name in the table.What I want my community to see is a summary of each of the four areas for the current month. I'll embed the view on a web page. Rollups, aggregations, linked records — I'm starting from square one in using Airtable and haven't figured out which and how to make this work. 'Lil help? Thanks!

Hi! New-ish to AirTable and very much appreciate your help and patience!I am trying to create a timeline or calendar view that displays all of our acting clients' working dates for every single film/TV project that our clients are/will be working on. For instance, I need a way to quickly view and edit the statement, "Charlie Chaplin is working on the film MODERN TIMES in NYC on 1/15-1/27, then 2/2, 2/7, 2/9, and again on 2/23-2/28." Additionally, I need to quickly display a client's working dates on a particular project to answer the question, "When is Charlie Chaplin available in Q1 and not filming MODERN TIMES?"  The problem is that I do not love the idea of creating several different start and end date fields for individual days (ex: 2/2, 2/7, 2/9) and short date ranges (ex: 2/23 -2/28). It does not seem like I can just select all the the dates a client works on from the existing date field(s), it only allows me to create a range (start date an

Is there anyway to hide certain tables from certain collaborators? I’m using Airtable for my business and want to link financials to projects. I have employees who I want to update records on my projects but not have access to financial information or client information. Is there anyway to do that? If not, I cannot continue using Airtable in my business…

I have data from an outside program that essentially has 300 questions from form submissions as columns and the rows containing Yes, No or N/A answers. I need to organize this data in a way to be able to get totals for how many yes/no for each question and come up with percentages for how often something is a yes. Thank You

Explore various ways to organize customer details, including grid view, calendar view, gallery view, and form view, giving you easy access to their information. Set up automation to send reminders to customers about upcoming events. Sort, group, and filter data by tags, categories, or fields based on your preferences, ensuring everything is neatly arranged to suit your needs.

Okay I think this might be a tricky one but let me know if you have any answers. Here's the basic concept. I'm producing a summer concert series and I want to create a budget and expense tracker. I want have a couple things I'm trying to accomplish.First, I want to be able to create a budget and allocate an amount of the budget to a certain category (labor, rentals, food, etc.).Next, I want to be able to track how much we are spending on each of those categories for each show. (Show 1: $1,000 on labor, $5,000 on rentals, $150 on food, etc.)Then, I want to link those together. For example, I want the show totals for each major category to then update the overall season long budget (the first item). Ideally, there is an interface with three pages. One is the Overview dashboard which shows the total budget, total spend, and remaining total budget. It would also show each individual category with total budget, spend & remaining. The secon

Is there a way to give a user access to 1 base in a workspace, but not another? Thanks!

What I'm after *should* be easy. I have spreadsheets of information that I manage informally. The rows of each spreadsheet are records that would ought to filled & updated by outsiders. Obviously there's a limit to how much we can do via Google Spreadsheets -- I can't assign ownership to each row.  So it seems like this is where people upgrade to AirTable. So here's the things I need, beyond what I see in the demo tool:It's a fair assumption that the first row is the field name. The second row is my description / help text. Can the import tool support that?Data is often never as primitive as we like. Is a map type supported? This could be edited through the form. I need to broker access to each row. I'd like to click on each row, "assign to group", and then email the owner of that group; they can then manage access for others who would update that row. How would they be charged? I imagine I should have to pay something for that

For a linked field, is there a way to limit record selection to a view based on the user?I have a Task table, with specific tasks for specific users.I have a Time table, where a user selects the taskDepending on who the user is, I want the only the tasks meant to be available.The only way I've been able to figure it out is to create multiple linked Task fields in the Time table. Not ideal.Thanks, David

From my research, I think the answer to this question is, "it can't be done", but I'm hoping I'm missing something.My base has 3 tables:Waiting List - this is the "main" table, listing the people on the waiting list.Events - defines the events for which people may be waitlisted.Site Types - lists the possible site types that could be available to a person on the waiting list.Here's a highly simplified version of the base that illustrates the setup.Each record in the Waiting List table is linked to a single Event Name record in the Events table.Each record in the Events table is linked to one or more Site Types in the Site Types table. This link field defin

I am trying to create a way for people to subscribe to a newsletter. The first form allows them to put in their name and email address. It works fine. I set a field called "Status" to Unconfirmed (as Single select type).I will then have an automation that will email them a link to a form update (with the record_id() etc).  I want the form to just have the Submit button (in which I change the label to "Confirm Email".  I can have the Status field on their for them to select "Confirmed", but I'd rather it be passed in, hidden and changed to "Confirmed", so when they submit the form the status gets set to "Confirmed".So I have the edit form (in fillout), I created the URL id of Status, and I set the formula to "https://forms.fillout.com/t/rBuRDxxxxus?Status=Confirmed&id=" & R

I have a form that is submitted daily by members of our team, and due to how the AirTable base was initially set up, it defaulted to GMT when our company is in EST, so when we default to 'todays' date, after 6pm EST it will jump to the next day. Is there a way to set up everything to use EST without messing up the data in our base?

Hi allI currently use Xero for my accounting (invoicing, billing, credits etc).Airtable is my order management system.I want to be able to create the accounting pipeline (invoices etc) in Airtable and have this upload directly into Xero.If I make an update to any fields in Airtable, I want this to update in Xero where relevant (invoices, bills, credits, contacts).Does anyone have experience with building a Xero equivalent that they could roll out for me? Would want it to link with my bank and handle tax returns etc.Otherwise any links to relevant videos/posts?Xero works well but I want to minimise double data entry and then no need to pay Xero fees.  

I’ve created a survey form and the text for one of the options for a multiple select question gets cut off. Is there anyway to have the form show the full text besides trying to reword the option to something less wordy?

Is there a way that I can have my employees fill out a form that then shows data they are looking for from a base instead that form inputting data into the base? I have created a table that would be very beneficial to my employees but some are reluctant to use it because they are used to an older system. If I could create a form that makes it very easy to find what they need, that would be wonderful. I see there are some paid 3rd party apps like On2Air that would do this. I assume by the presence of these apps, Airtable does not have this functionality but figured I'd ask when my searches on the community yielded no results.  Thank you for all your time 

As of right now the inventory department at my company relies on paper forms and it was recently requested that we digitize the form. I don’t need the form to actually place the order, I just need filled out forms to be sent to the inventory manager. However, as I dove into the process, I hit a wall. Is there a good way to convert the attached form into an airtable form?

I want to create a users table. This will be tied to the users who have access. I already have a projects table which i can easily assign owners via the people who have access to the base, similar with tasks connected to those projects (this works fine), my problem is i cant create a table of team members who are on the base using the information from who has access to the base and then group by owners to show what projects they own.I have done this in a hacky way but it seems it doesn't update when i add new projects so thinking if there's other ways of doing this

Hi all,I'm working on a project and I need to Combine Table A from Base 1 with Table B in Base 2 to create one table, Table C.I've already linked the two original tables to be in the one base, but I can't figure out how I can automatically combine the two.Thanks in advance!

Im trying to use a field related to another table, the field is a date datatype which is in local format (DD/MM/YYYY) but the lookup tries to use another data forma (MM/DD/YYYY) so its not retrieving properly.Fecha de Facturación and Fecha (from another table) are both in local format But the datatype link from one table to the other search in another format so it fails...anyone who has passed through this problem?  

I'm trying to create a simple contact database of names.  When I have several names that happen to be related (ie of the same family), I'd like to link each of them to each other to show those relationships.  I can create a link to other people in the same table ("People") for example John Doe is related to Jane Doe, but when I go to Jane Doe, I don't see the relationship to John Doe.  It doesn't seem to be two-way.  Am I missing something?

Hi there, I am hoping that someone will be able to help me with this interesting little problem. I have a table as a "reference table" which allows me to set fees globally across the base so if a fee for tables goes up I can change it across all records. That same table contains other fees such as fee for square footage used elsewhere.In the table "Bookings", the second table, where the reference field is then used, I would like the ability to auto pull through the value field based on the lookup value. Example below. In "Reference Table" the fee for tables is 12.00 In the "Booking Table" I have the link value as the Reference Field "Table Fee" and the lookup value of "Value"All of this works fine but in the Reference Field, I would like that to be able to populated with the "Table Fee" so that the value pulls through also. Is there a way to do this?The option for pre selecting a value that appears in other fields

Hi Airtable Community - I am fairly new to Airtable.  A couple of months developing. Have a few questions below.  Many thanks in advance for any guidance provided.Q1: Need to merge two bases - what is the way to go?  The chatbot mentioned scripts to bring data over and sharing the tables from one base to another.  I would like to merge the two into one Master one and not lose existing comments in any records, any history or scripting/automation in either.  Is there a way to do this? Q2: How do I see/query the backend table structure in Airtable via  SQL? Is that possible? is there a tool out there that can help with that?Q3: Any companies that offer Airtable development that I can chat with - looking for rapid development so need more Airtable engineers?

Hello friends, how are you?I'm really sure I'm missing something! Something so simple and easy can't be that complicated!I have one table of leadsAnother table of Ad costI want the Ad cost table to sum the number of leads I have on the same date from the leads table and then actually make a formula that will divide the advertising cost by the total leads.I made a Linked record for the leads table and made a filter that will show me only the leads whose "registration date" is the same as the date that appears in the date column.It does show me all of these leads (except for the ones whose date is the day after for some reason) but I don't understand how I can just automatically pull them into my list without using any automation that would make everything complicated!It really seems super simple and super easy to me but I've been wasting too much time on this!!I would really appreciate some help on this topic!Thank you very

Looking to create some kind of form / interface that allows the user to submit multiple records. For context, here is the use case:I'm creating an Ordering/Receiving Inventory Management base to use across staff at a Restaurant for order management. Person 1 does the ordering, they submit what they ordered. (ideally they'd be able to do it by distributor, so for Distributor 1 we ordered 7 cases of X, 2 cases of Y, etc.) This populates to a new table of sorts that Person 2 can reference when they do the receiving of said order. They'll see the 'Qty ordered', the 'Item Ordered', and the 'Distributor'. They theoretically can denote what was received (1 case of Y instead of 2 cases, etc.), as well as attach invoices for easy reference. Not necessarily set on the set up being a 'form' per se, although that makes the most sense to me. However I am getting stuck as I can't find anything about adding multiple records through a form, it seems the form set