Base Design

Hello,My sister operates a bakery from her home, and I want to make things easier for her by creating a system in Airtable where she can take orders for her products.As a bonus I'd like to be able to track repeat orders from customers as a way to determine customer preferences, habits, trends, etc.There are a few problems I'm finding with this. Airtable has no way for customers to "make an account" so to speak. I'm inclined to create a table for customers, but...Customers would need to complete a separate form if they're a new customer, then come back to the order form, which feels cumbersome.For each customer that already exists in the base, Airtable will reveal all of the names in the customer table whenever a returning customer begins to search for their name, which just doesn't sit right.We could simply request name and phone number each time, but I'm not sure if that will allow me to combine those records based on phone number in order to be able to assess trends based on those or

Hi! Recently I've been encountering a table syncing error ("Last sync failed 1 minute ago (external resource id could not be mapped to a rowJson)"). It's easily resolved by manually syncing the table with the error, but this is obviously inconvenient - we have a LOT of synced tables. I haven't been able to detect a pattern in which tables get this error or when. Has anybody else seen this?

Hello!I need to create a data entry form that will limit dropdown menu choices based on the selection made in another field. I am looking at the possibility of establishing nested lists to define the hierarchy of options, but so far I'm not succeeding in creating an interactive drop down menu.Is nested lists the right approach? If not, is there another way to do this?Here's the example. Imagine I have a table that has 30 birds and 20 fish in the records.In question 1 I want the user to be able to select "bird" or "fish", and then in Question 2 I only want the 30 birds or 20 fish to show in the species selection box, depending on what was chosen for Question 1. (In reality, I have an intermediate grouping level, and many more species than 30 or 20.

Has any headway been made toward the goal of being able to display the results of the survey during live group polling? I remember seeing some community debate about the need for such functionality around a year ago. Still, I haven't seen anything recent that indicates any work being made in that respect. Many thanks!

In my rollup fields (on multiple bases), I don't have the option to add a condition shown in this article: https://support.airtable.com/docs/rollup-field-referenceWhy would that option not be showing up for me? (I have a Pro account)Here's what I'm seeing...Here's what's shown in the article:

I am trying to create a table that is linked to a Box folder where I have hundreds of folders inside the root folder. Those folders contain other sub-folders and tens of thousands of files. (Root Folder>Folder>sub-folders/files). I don't want all the (sub)folders and files to be synched to my table, just the folders. In other words, I want all the information to live inside of box and just have a button/link to click to open the folder where the (sub)folders and files reside. There doesn't seem to be a way to just have the folders synched without it trying to synch all the (sub)folders and files. Needless to say, it quickly hits the 10,000 record limit. Howevere, all the folders I actually want to see are included within the synched table. I can create a filter to weed out the sub-folders and files, but I don't want that information just hanging around burning up records (counting towards my record limit). I hope all that makes sense. Does anyone know a way to just synch the fold

I have several views that show the icons without the words - it's driving me crazy that I can't figure out how to put them back, or how they got this way in the first place.Please send help! And please also don't ever make me have to deal with that truly circular, frustrating and unhelpful bot on the help bubble.

I have a base with two tables. One table is contacts while another is companies. For my contacts, I have a field called location which is a series of metros: NY, SF, DC, London, etc...I'd like my companies' table location field to have the same list of locations. Is there a way to reuse the field, but not have them link to one another?(I dont anticipate wanting to ever connect a contact to a company, and if i do it would be with different data than what i have in my contacts records anyway)

Hi,My problem is I have a team of 3 including me, and I created 3 tables, the problem is when I update the other table for my other team it change the 3 tables including mine and theirs. Anyone can help me here? pls pls pls

When I paste more cells into a table than it has, the expand table message comes up. I click ok and nothing happens. Happening in all bases in my account... JL

copy paste of data to base not working .. had to import 

Hi AllI have a base with 3 tables: Routes, Passengers, and Absences. The Routes table has multiple passenger fields, which are linked record fields to the Passengers table. The Absences table has a passenger field, which is a linked record field to the Passengers table and has a lookup field to the associated route field - as well as a date of absence. When an absence is added to the Absence table, it pulls the route the passenger is on. If a passenger changes route, the linked record lookup field for the route in Absences will change for past absences. This means the data in Absences is no longer historically representative. What is the best way to preserve the original route that is pulled through onto records in the Absences table? Preferably I would avoid: a) having the route name in an extra text field or b) creating a linked record field directly to Routes rather than using a lookup field, but open to all solutions. Thanks in advance for your help!

How do I have a formula based on 2 different multi-select fields, that will add a specified number to the resulting formula, based on how many options were selected for each multi-select field?Remember that each multi-select will be adding on different number.Here is my formula so far.   (IF( {Pull Factors Attract}, LEN({Pull Factors Attract}) - LEN( SUBSTITUTE( {Pull Factors Attract}, ",", "" ) ) ) + 0 ) * 2 + (IF( {Bonus Pull Factors}, LEN({Bonus Pull Factors}) - LEN( SUBSTITUTE( {Bonus Pull Factors}, ",", "" ) ) +0 ) + 2 ) * 1   You can see an example base here. Here is the scores I would like added for each option chosenPull Factors Attract: 2Bonus Pull Factors: 1However it's not quite working with records with an empty field.

HelloI'm testing airtable and I want to make a database with all my trial cases. These are cases that we must check  with some regularity, the idea is that each case generates a record and that once the record is created, it will be assigned to a role of periodic reviews, meaning, each case must be check by my staff every 3 months to update de info of each case an check the task or actions that we need to take with every case.  So  My desire is to create some kind of automation to generate monthly an e- mail to me an my assistant to check those cases that reach the 3 month period and need to be checked for updates.  Also, I already have a lot of existing cases, and my goal is to divide those cases in groups to not overwhelm my assistant with all the cases needing a review at the same time, but I don’t know how to do that.  Hope someone can help me, and sorry if my English is not good, is not my native language

Hi.I have a large table with Approx 110 Fields, 90 Views, 6,500 records and a number of automations etc. The table was created using the Emailed Data Sync as its Source. I need to duplicate this table, delete the records and then start using a fresh set of records. I receive the below error when I go to duplicate, I can only assume due to the size of the Table. It says to contact Airtable if the error continues to occur, which it does. I contacted Airtable, only to get the automated 'Please look at the Help sections' or use the chat function, neither of which have worked for me.I have cleared my Cache as suggested by Airtable, but this doesn't resolve the issue. I can see that I can't toggle off the option to Dulipcate the Records when I go to dup. the table - this isn't an issue from myside, but maybe the number of records is causing it to fail?! Just wondering if anybody has any work around for being able to duplicate an Emailed Data Source table or any idea about the error. I r

Looking for a way to use Conditions to view something like this: Where Lookup Field  matches Linked Field I want to show all the date/times from a lookup field that corolate with the same employee who completed a form. Hopefully, the screenshot below helps explain it better?  

I'm having trouble creating a Form that I can use for Performance Ratings, and having that Form's fields update the Record field for the table. I believe I might have this architected in not the best way. Let me explain below.I have a Table that list Vendor Records. Each Record tracks, names, locations, services, cost, etc.Additionally, these Vendor Records also track 4 Performance Rating Fields.In the Table Table, I created a Form, with the intention that I could provide this form to managers quarterly, and Have them fill in the 4 Ratings fields for the Vendors they manage. The full intent is that I would automate a quarterly email to send to the manager, for each Vendor they manage.When I test the form, I feel like I have set something up incorrectly, because there is no way for me to select a specific Vendor record, or even Default that for the Manager.When I fill in the ratings, nothing updates, and it creates a new Record in the Vendor table - Again, pretty sure because its not co

HelloMy brain is stuck on an operation that doesn't seem so complicated... butI have an "Event" table   and a "Days" table   Is it possible, or how can I achieve this result ("expected" page)?   I have a project in which events are created over time. When I create these events, I don't yet know the day(s) on which they will take place and their quantity (number of days).Would it be possible that when I add 1 day (or more) to a project, it creates a new record on another page ("expected" page)?

Hello,I'm reaching out for ideas for doing an Accounting Forms (like a Check Request form) through Airtable. I love using forms to reduce data entry, however, I haven't been able to find a form that I can use to complete something as "complex" 😂 as a check request, specifically with multiple itemized lines presented in a Grid Format. Among other things, this Check Request Form would need Account Code, Description, and Dollar Amount *for multiple lines*. For example:Check #234 paying a contractor for services, expense reimbursement, and materials.Line 1: Fee for Services: Account: 100 - Description: Services - Amount: $1,000Line 2: Expense Reimbursement: Account: 200 - Description: Lodging - Amount: $350Line 3: Materials: Account: 300 - Description: Widgets - Amount: $500I could do 1 form per line, and compile the invoice from multiple forms, but that is not very helpful.I know exactly what is needed in a sense, but I don't know how to build it so that I can elimi

Hi everyone! Well I’ve been using AirTable to help me organize my inventory and sales orders. But now I’m trying to build a template to help me organize my construction project. In general I’m trying to set up a tab in my table that tells me how much money I have available, so that it takes all of the money we’ve received from the client in different instances and subtracts all of the money given to different contracts and shows us how much is available. Is this possible? Thank you everyone beforehand!

When using linked records, is it possible to apply a value to only the first linked record in a cell?So if I have two tables.Table ATable BWith Table A, I'd like to find a way for the Revenue to only be a logged against the first linked record in the Products column. Is there a way to do this?(I can't do it the other way around - so applying the rollup to the first linked record only in the Sales column on table B, since I do need to be able to sum multiple Sales in this column). Effectively, I need to be able to roll up revenue from sales against each product, but in cases where multiple products are placed against a sale in Table A, I only want the revenue to be assigned to the first product in the list. Hope that makes sense. Thanks.   

Previously, the table was shared and synced, but troubleshooting was done after disabling it.  Once I delete records, it re-generates deleted records back within a few minutes (less than 2 minutes), just like the undoing delete operation. Any ideas about possible scenarios? No automation is relevant to the table.

Hello there! I work with an organization that produces a 50-concert summer festival. We have about 120 Season Pass Holders, about half of whom show up to any given concert. We would like to check them in at each concert and track their overall attendance.Each person receives a physical Season Pass (a 3x5 laminate) that they bring to the concert, so my hope was to include a unique QR code on each pass that corresponds to a unique ID for each pass holder. Then our Front of House staff could scan that QR code via the Airtable app on their phone, and it would create a record of them having checked in for that concert.One thought is that each concert could be its own view, and then any check-ins within that view could be clearly reconciled. Maybe that check-in could just be a timestamp, or it could be that when the staff scans their QR, it gives them an option to toggle a "check-in" switch.Open to any all suggestions, and grateful for your help!

HelloI'm trying to do something like this:Attributes TableNameMin ValueMax ValueHealth-99999999Energy0164000000Potions TableNameDescriptionAttribute ModifiersFooBarHealing Potionheal_pot_descr(Health 50)......Curse Potioncurse_pot_descr(Health -25), (Energy -25)......So is that possible? I.e. referencing the attribute value in the Attributes Table from the Potions Table with an additional value of some type (in this example an integer)?The use case there is pretty simple and straightforward. I was also wondering if that's not possible if we could join then two columns into one? Something like:NameAttributeModifierAttribute ModifierHealing PotionHealth50(Health 50)Curse PotionHealth, Energy-25,-25(Health -25), (Energy -25)This at least allows us to preview the values in the table

upgrading to Airtable's Enterprise plan would remove the base row limits and allow more automations, but as of my knowledge , it is very expensive around 10k$?We have a large dataset that exceeds the 100,000 row limit per Airtable base. We also need more than the 25 automations allowed in the base. Upgrading to Enterprise is not feasible due to high cost.  We're looking for more affordable solutions to handle our large dataset size and automation needs within Airtable's business solutions. Has anyone found creative ways to structure large datasets across multiple linked bases or integrate affordable supplementary tools to overcome Airtable limits?We'd love to hear any cost-effective ideas or solutions that don't involve upgrading to the expensive Enterprise tier.Even partial solutions could give us ideas to explore further. We greatly appreciate any insights the community can offer!