Base Design

Hello! Looking for some help organizing a dataset that isn't importing from an Excel file as intended. As you can see in the picture below, the primary fields are spaced out, separated by extra rows made for each "Regulation" data point. For example, all the "Regulation" data points from "FDA Guidance 2001i" to "OECD GLP No. 13iii" should be merged into one multiple select field for the BAV 1.0 record. Similar for BAV 2.0, "21 CFR 320.29" and "FDA Guidance 2001" should not be split into two rows, but merged into the same "Regulation" multiple select field.Looking for a way to automate or at least quickly go through this data set merging these extra records. Thank you!! 

Hi Thanks for taking a look at this. This seems a simple question but I can’t work out the best approach. I want to be able to choose the country where a company is located. More specifically I want a user to be able to choose from a list of companies in a TypeForm and then connect the form to an AT table. Adding 200 countries to a single select field in AT seems not the right way to do it but putting them in a separate table means Typeform will not be able to send the data to AT. [Why do I say this: (1) because I can find no way to copy and paste a list of options into a AT Single Select field (2) the AT-Typeform integration is very pernickety in relation to exact match of options] Thanks

Hello! I am trying to figure out a way to link 1 column of records to multiple tables. For example, I have a master list of students on one table and have additional tables of info that I would like to link to the master list so that when I add or delete a student on the master list, it adds or deletes that record on all of the other tables. Is there a way to do this?

Is it possibel to create automatic base for the user when the new user is added to the table containing user info. Can we create script or any other method which can help us to create automatically based with predefined tables for the new user. 

I am creating a new base by importing an excel sheet. When I select import from the wizard or from table tab carrot menu or from "add or import" button to the right of the table tab, there is no response...ie dialogue box...nothing happens. Thanks all!

Dear AirTable community,I have just been recommended and discovered the amazing Airtable tool. But I am struggling structuring my team individual and transversal To Dos.In my team, each team member has its individual AirTable base "To Do [name]" and each transversal project has its transversal AirTable base "Project [name]". The tasks in individual and transversal tables are structured with similar fields.Let's say I'm Céline : I have my individual base "To Do Céline", in which I have my individual tasks, which are not related to any transversal project and which therefore do not require to involve any other team member. I also have a Kanban view that enable me to visualize my individual tasks by status.I also have the transversal base "Project eCommerce" as I am involved in a few tasks within this transversal project.I would like to find a solution to include these transversal tasks into my Kanban view in my individual base "To Do Celine".&nb

I need assistance in setting up a workflow for a non-profit organization where we help people with food, clothing, rent, utilities etc. I'll do my best to explain my needs. I've watched every video I can find and read all kinds of articles, but I've yet to figure out how to make this work. I would appreciate any help....Thank you.I have a database with all of our clients, addresses, emails, and other demographics.I need a database that will help with all the services we provide for our clients.I need this database to update as new records occur.I also need this database to be able to tell me if a client has reached their limit on available services.               Some of these services are only allowed every 6 months, some are allowed every two weeks, some are conditional situations. I need to be able to see what a client has received over the past 6 months. These records need to

FolksI have created a database with several peoples details. On it, I have also created a view which will take a filter text like this:https://airtable.com/VIEWLINK?filter_FIELD=FIRSTNAME%20LASTNAMEand then send it to the specific FIRSTNAME/LASTNAME person, who does not have any airtable account as a normal shareable link, so they can access their data.The problem I am facing with is that as the controls of the view are available, the view can be filtered with different values and people can see each others details.I see that on the EMBED version of the view, I have the option "viewControls", but it does not work if I use it on a normal share view.Is there a way to prevent a view to be re-filtered? Or to prevent the controls to be available?Thanks in advanceAlfredo Rodrigues

We want our guests to ore-order menu choices by selecting one starter, main and desert from three choices in each category that have been picked from an extensive list of menu items.  I have a table with the menu items.  Another table has the meals with the date, venue and three offerings from the three categories.  Now, for each guest (all guests are in another table) I want to select a starter, main and desert from the three that are being offered by the venue.  From this information the venue will get a list of all guests and their menu choices and and each guest will receive  a confirmation of their selections.  So far I have the three choices in the meal table but can't figure out how to select one of each from the choices in each category for each guest.  I hope the attached diagram illustrates the issue.

Hello all, I have created an AirTable base used for tracking insurance documentation for a construction company. I have set up a date column of when the insurance document in question expires. I was wondering if is possible to set up an automation to send an email to a user that this document is expiring? The issue I run into is that all of the dates are different. I see in the automations you can select "when a record matches conditions" then when selecting a condition when 'insert my expiration column in first field". The next step is where I hit the issue because there is no way to select "date that is listed in the column". Hope this makes sense and there is a different way around it I am just not seeing it. Appreciate anyone who can lend their expertise and I can provide more information if needed. Thank you!😊

Take the example below, imagine you have:Category.ProductsProduct.CategoryA product is linked to multiple categories. When you first create the 'Category' field on Product, this creates the other side on Category, lets call it "Products".  If you delete the column "Products" from the Category, is it possible to re-link them later on?Also, if you do not think one will ever need the "many" side of the relationship - does it slow AirTable down if you keep that many-side Field as well? Or it does not make a difference? 

Hi!I'm creating PDFs with Google Docs and DocsAutomator. When I check the field "generate RMA" AirTable create PDF out of Google Doc and save this PDF to the desired attachent field. Of course the data is from AirTable. And this is easy.Then I came across one problem, which I think I handeled it okay. If I have two choices that I have to decide and check in a checkbox) I simply created formula field.So I had two choices "repair" or "servise modification". And I created checkbox field "repair" and "ervise modification". And then formula field for each of these field with IF() function. If the field if checked, it returns checked box, otherwise it returns empty checkbox. And then I connect these two (formula) fields to the PDF. And It worked.But then I came uppon bigger problem.. if I have many choices to check I don't want to create all these fields p

Hi. I am using Pro plan, which allows syncing between bases.  I've been structuring a lot of parts of our business in one main base.  There is a significant amount of data which needs to be imported from CSVs, for which it is much easier to give direct access to the base to the users, rather than through interfaces, views, etc.  There will also be some sensitive data in the main base, which I do not want to give even view-access to these users.  If you give access to a Base, they automatically get access to all the tables read-only as a minimum. Because of this, I realised it would be better to have a Main Base, and also a base for the Raw Data/CSVs.  I would give any users who need to import bulk data to the Raw Data/CSVs base, and then sync tables from RawData to the MainBase.The issue is that I already have a lot of automations, fields, configuration, etc in Main Base. For example, I have a table called 'Bookings Data'. I would like to

Hey, can anybody think of a way to create a table that consists of a listing of all the records in several other tables in an index format. Something like this: Primary Field Value | Table Name Bob | First Names Goldthwait | Last Names Comedian | Occupations I want to produce a single table like the one above, dynamically and continuously from live data, from a base that contains the following tables: TABLE: First Names RECORDS: 1 Bob TABLE: Last Names RECORDS: 1 Goldthwait TABLE: Occupations RECORDS: 1 Comedian This is just hypothetical data. I know I could this by exporting to a spreadsheet and reimporting but I want it to be automated and real-time. Any ideas?

Hi! We were wondering if Airtable could be used as a Quality Assurance tool to evaluate our customer's representatives? If so, how would you implement it (using forms, reports...)? Thanks!

I have a structure, similar to the below simplified version:EndOfMonthReportsClientIdDatePayoutsEndOfMonthReportIdBookingsEndOfMonthReportId ExpensesEndOfMonthReportIdPayouts, Bookings, Expenses all fit the template whereby they all have a Date, Description and Amount. They all have very distinct fields, so I dont believing merged them all into one table would make sense. Each of these entry in a way effects the client's account balance, either with a positive transaction, or a negative transaction. I would like to be able to generate a report, where one can get an account statement per client, for a particular time period.  What this would do is if you say generate it from Jan 23 - Jun 23, it would get all the end of month reports within that date, and show a list of all these distinct transactions, in the form of:

Hi everyone, I've got two tables in two different bases.calendar of articlestasksI'd like to create a task for each calendar item and only need to update one table. Just looking for ideas on the best way to link these bases. My current idea:is to sync the calendar table into the base with the taskslink each calendar task to the calendar item. Use an automation to update the task status

Hello- I watched this video but it's not clear to me what happens between minute 1:00 and 1;07.  https://youtu.be/ES1RyNPv_KgI am looking to create a sign-up sheet for one day in 5 minute increments between the hours of 12:00 pm - 5:00 pm, and have 4 rooms running at the same time. How do I pre-populate the times?Any help is greatly appreciated.

Hello, I'm using the Timeline view with a data set that has data points starting Aug 1st 2023 and onwards.There are no data points for the time period before Aug 1st (Jan 1- July 31st) yet these dates are available to be scrolled through.I am aware of the date settings allowing you to jump to a certain section in a view, but I am instead looking for a solution to start the entire horizontal axis on a designated date, without having the possibility to scroll to an earlier time frame where there are no data points. Is there any way to hide the empty values, or set the minimum start date of the horizontal time scale of the timeline to start at a specified date? i.e. August 1 2023?

Hi all 🙂I am trying to avoid duplicate entries from making it to my airtable table.Background: I am running multiple webscraping actors collecting entries from public sources multiple times a day. The actor itself can not determine which entries it already has collected, but just get's the 10 latest entries 5x a day. This way i assure that I get all the entries which are posted. However, when I now add the entries to airtable, it will create duplicates. I am currently using the "Datastore" of Make automation, which will automatically "reject" any duplicate entry as i am using the unique URL of the entry as the unique key in the Make datastore. This is desired as each time an actor runs, only the new entries make it to the DB. However, when trying to switch from Make Datastore to Airtable as a DB provider, I realised that airtable doesn't allow me to specify a "key" or "record id" when adding new entries.Question:

Hi.  Is it possible to rollup all values of all the links in a field of type link, combined into a larger array? I'll give an example to illustrate better.I have two tablesReportsExpenseCategoryLinesLinked (Link to ExpenseCategoryLines, many-to-one)ExpenseCategoryLinesReportId (Link to Reports, one-to-many)ExpensesLink (Link to Expenses, many-to-one)Expenses ExpenseCategoryLineLink (Link to ExpenseCategoryLines, one-to-many)The idea is to have a Report.AllExpenses as a rollup, which would combine all the Report.ExpenseCategoryLinesLinked > ExpensesLink into one field, as an actual list of links (not text). I've tried using CONCATENATE or ARRAYJOIN, but it returns the IDs as text. 

Hello AirTable Community,Im somewhat new to Airtable and I am currently facing a challenge in building an effective inventory base in Airtable, specifically when it comes to linking multiple promo products into one product and properly managing the inventory for each line item. I would greatly appreciate your guidance and expertise on this matter.Here's the scenario I'm dealing with: I have different office kits - mini, small, and large - each containing various promotional products such as post-it notes, pens, carabiners, webcam covers, mousepads, and business cards. I want to be able to track the inventory for each individual item as well as the overall inventory for each office kit.The goal is to manage and update the inventory levels for all the components within the office kits. I want to ensure that when one item from a specific office kit is sold or depleted, it automatically reflects in the inventory for that particular kit. Additionally, I need the abil

Hi All,How can I configure different fields in card view and card expansion view?Use case: I want the cards to be smaller and neater, and show 1st tier information only at a glance. Upon card expansion, I would like to show more details.Basically, it should be able to select which fields would be part of the view, and the which fields would go on Card only and which ones on Card expansion.Im afraid I know the answer, because I searched for it. Its just that I cant believe that that functionality, with so much potential, is useless in any case that's not super simple, what a waste of a feature...Any plans from Airtable to improve this feature?Kind regards

Hi community!I have an airtable that tracks VFX shots as they come in from vendors.One sheet (delivery) tracks every shot as it comes in, including the same shot with a different version number due to fixes or changesOn a separate sheet (topsheet) I have a master list of all the VFX shots in the filmOn the delivery sheet, I link each record to the master vfx record on the topsheet. That way I can see every version of a VFX shot delivered and track commentsThe issue I have is that the producer likes to see a list of every shot that is either 'not started', 'has issues' and 'passed quality check'. The issue is, because multiple deliveries are linked to the master shot, the master shot can be both 'has issues' and 'passed quality check' as the old versions are linked. Is there a way to group the 'topsheet' so that one group is all shots 'not started', all shots that have issue but none that have passed qc, and a group that is any shot that has at leas

How would you set this up?Department 1 is in charge of sending contract to customer, receiving contract, sending invoice and receiving invoice for initial payment. Once initial payment is received, Department 2 is notified and now needs to complete a certain number of tasks for 'onboarding that customer'. When those tasks are complete, Department 3 is notified and they have their own number of tasks for that customer, and so on.Thanks for any advice!