Base Design

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 second page would be a page to edit the cat

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 access, but not $20/month, maybe $1.May

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 defines the subset of Site Types that are available for that particular Event. This data is repeated as "Available Site Types" in the Waiting List table via a lookup field (if it's needed). As I have it set up, one Site Type record can be linked to multiple different Event records, but that's not mandatory--if it helped solve the problem,

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=" & RECORD_ID()But every time the form gets called, the original value from airtable (which is Unconfirmed) stays there, and it doesn't get updated to Confirmed.  Does the pre-fill thi

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 is not available in a linked field.Thanks in advance

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 much! 

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 up is more specifically for fillin

Hello,to simplfy my struggle with reporting in Airtable lets imagine this workflow:I have Employee, Projects, and Timelog tables where employees track the time spent on specific projects. Each employee has their own hourly rate.What I need to achieve is a monthly report for each employee that includes:All projects they worked on in the previous month (show them only if they worked on specific project at least for one hour)The total time spent on each projectThe total cost (calculated based on their hourly rate)apologize if this has been discussed before, but I couldn’t find a solution.I am could achieve this by Pivot table in the dashboard section, but I need to make automations based on this results (adding Payments and so...) Thank you

Hi !I struggle to import data from a bigquery table to another table in Airtable.My connections are fine, but I can’t manage to map the field between bigquery and airtable in Make. Any tutorial or idea ?I just want to import or upsert the data from bigquery to airtable. The fields are the same and ready in airtable.I've tried Skyvia but it make several errors when upserting...Thanks !

Hi,  I'm having trouble understanding how to do what I want to do.I want to create a campaign. Not necessarily send emails from Airtable but structure and track the progress of a campaign.I'm trying to make a "Campaigns" table where each record is a campaign.One of the fields in the "campaign" record is "contacts" where I attach the contacts I want to exchange with.I want to track for each contact whether they've been contacted, by what means, whether they've replied, and notes on these interactions.It looks like a list display, but I can only create levels above each campaign record & not below (see the screenshot below).I'd like to have above the campaign record and below each contact with fields.I can do this architecture in the contact table but in this case the "campaign" is no longer a record in itself but only a field. Which is not desirable either.I suppose the solution should be obvious but I don't see it.How would you do it?   Thank you in advance

Hi.  For the past 1 - 3 days, I've been experiencing immense slowdowns using the web UI interface of Airtable, when loading tables, changing formulas, doing any updates whatsoever.  This used to work pretty fast up till now. As far as I know, nothing drastic has changed from my base size, or design.The Web UI takes ages to load irrespective of table size, I have tables of less than 200 records which take a very long time, and also others of 10,000 records. Tools integrating with Airtable, like Make and some other tools, still work pretty fast and get good response rates.I have no idea where to start to troubleshoot such performance issues, or how to go about this.  Any help would be greatly appreciated.