Base Design

I have a base used to track conservation information about media in different formats. Each format has its own table. The tables are: Film, Video, and Computer Media.Across the tables, each record is an individual item. The fields for each table differ, as the conservation data in those fields is different depending on the media. (For example, Computer Media like a floppy disk does not have a film gauge of 35mm, 16mm, etc.)I want to create a fourth table that pulls in select records from all three tables. I want to pull in only records that have "reformatting candidate" checkbox field selected.I know this could possibly work by having all the records in a single table, but the amount of fields would grow quite large and would require multiple different views with various fields left empty and hidden. It is also more user friendly for us to have each table be delineated by media type.So, is there a way to pull select records from multiple tables into anoth

Hi there,We have acquired another company that also uses Airtable. Both we and the new company have our own client lists in Airtable and we would like to combine these, as we have some shared clients already, without (at this stage) merging the Airtable bases in their entirety.We would like people from both sides of the business to see each other's clients in one place, so that:1. we can see which clients are shared2. we don't create records for clients that already exist in one of the basesNew clients added in one base should be updated in the other base too.Ideally, clients should be able to be created in the existing 2 bases and update across, rather than created in a new 3rd base, but if that's not possible then that's fine.The clients will be linked to other tables in the respective bases and these linked fields should be displayed (via plain text if needed) in all bases.Does anyone have any ideas how we can do this? We've c

Hi. I've a simple contact us form and that form also records date and time of a new entry. Is there a way for a new record to show up automatically on top of the base as opposed to bottom?

Hi guys, Just trying to achieve the following. No luck so far. It’s a way to reduce inventory numbers of products based on the available qty of the parts that make up that product. I’d like for this to be nested. So if we have a wheel that is made of [tyre,tube,rim] and a bike that is made of [2 x wheel,1 frame etc], if we increase the qty of tyres, we will increase the qty of the wheels which will increase the quantity of the bikes buildable.eg. Table 1. (Products) Tyre Tube Rim Wheel Frame Seat Handlebars Bike Table 2 (Bill of Materials) Wheel - 1 x tire, 1 x tube, 1 x rim. Bike - 2 x wheels, 1 x frame etc. I can get it to work with one level of BOM. So if I had it as Bike = 2 x tires, 2 x tubes, 2 x rims, 1 x frame etc it works well. I’ve tried countless things to try have it work with nesting but I haven’t solved it yet. Any tips of the method to use would be great. Obviously, it has to

Hello!I am appreciative of any help on this one! I have spend way to many hours of Youtube trying to figure this out. Problem: Cannot import a CSV file to a synced tableScenario: I have a new table that is synced to another base (that part is working perfectly!), but when I try to build out the new table it will not allow me to upload a CSV because the table is being synced. I have 450 columns (fields) that I need to add that have already been mapped out in an excel file. I would LOVE to save hours of manually creating each field and have it upload into the synced file. I'm not worried about it updating the records (rows), I really just don't want to have to manually add each column. Is there any other workaround I can try?!

Hi All,I'm fishing for some ideas on how to structure my Project Tracking Base. Here's what I'm trying to do:I have Projects in a table, with a Project Manager, and Team members assigned from my People table. I do want to keep track of the role of each person on each project. This role can be different for each project they are working on, so assigning them to Departments or Roles in the People Table does not work.I'm hoping to not have to create another table (let's call it Roles for now), since it I think it will complicate the Interface. I want people to simply add team members to the Project in pre-defined roles.The other way of doing it (easier interface) means having a field in the Projects table for each role. Trouble with this approach is that new roles keep on being added (as needed on projects), and I can't be editing fields, forms, interfaces, etc. each time a new role is needed.Any suggestions on a better way to structure my base to acc

Hi. I've got a base in AirTable which I need to be able others to update through a form in fillout. I only want specific fields to be updated by the form. In the case as shown in the screenshot I only want people to change the status and no other fields. When I chose to limit who can edit fields such as name, email etc to nobody but leave the status field as editable by anyone the form doesn't update that field. I only manage to update the status field when all other fields are editable but then it will obviously create an issue that will allow people to edit the base. The idea is that people would report status updates by the form and they would need to see certain fields of the form.  Could anyone point me to some resources on how to accomplish that? Thank you.

Hi everyone,I’m looking for some guidance on creating conditional forms in Airtable. Let me explain:I’ve set up a base for project management where each project has different tasks based on the program type (and there are multiple programs). Ideally, I want to create a form with a predefined task list, allowing Project Managers to fill in details such as start date, assignee, end date, status, etc., without having to manually enter each task name.Is this possible with Airtable’s Teams plan? Any insights or workarounds would be greatly appreciated.Thanks in advance!

Hi everyone, I have some set of records that need to be duplicated. At my surprise, there’s no option to “Duplicate” when more than two records are selected. I cannot duplicate by hand because the base is quite heavy, there’s too many records to duplicate and it could cause a lot of errors. Is there a way to do that (a block, a script, an integromat scenario…) ? Thank you

I have the following tables within a base:ProjectsTimesheets, with each record linked to a single project and a single task type (single select field)Estimates, each linked to a single project and a single task type (single select field)I'd like to be able to compare, ideally in a table and chart (multi series line chart?) in an interface, the amount of hours spent on a particular task type versus the amount estimated for that task type. There may be time spent on a task type that did not have any hours estimated for that task type.What is the most efficient way to do that?I could create conditional rollup fields in the Projects table for each task type, but then I'd be on the hook for creating new conditional rollup fields if I ever create new task types. This is the kind of scaling limitation I'd like to avoid, if it is even possible to avoid it. Any ideas?Thank you!

Hi thereI'm trying to set up a base to record relationships between several data sets, specifically: Segment (eg academia, corporate)Sub-segments (eg lecturers, library, researchers) Use cases (eg data management, author screening)Use case groups (eg planning research, managing research)Products (eg Pear Software, Banana Software)I'm not sure how best to set up the base to show their interconnected relationships. For instance the sub-segment of Lecturers, which is part of the Academia segment, uses Pear Software and Banana Software when they have use case of Author Screening, which is part of the use case group Planning Research. Another sub-segment might use Pear Software and Banana Software for different use cases, or they might have the same use case but Peach Software and Grape Software are better for them. Each segment and sub-s

I wish to use a series of icons to represent the status of a record in a base. How best to do this? If I add a small image in an attachments field it works, but the image becomes a clickable link and opens the image file - not what I want. The icon must be a static element. If I use a "Single Select" field I cannot import my icons.I would appreciate any guidance.

Hi, I love these kind of icons used in table names and fields. How can I find icons like these, especially with this style? Is there a page for icons which Airtable supports?

We have a large team and many tables. Each department has their own table "queue". Obviously someone minding the SMS queue does not want to see the paid social queue first and so on. Is there a way for users to change the tab order based on their personal preferences and not be forced to use the base default tab order of all the tables?

Currently, all rich text formatting is removed in Lookup fields. It would be so helpful if rich text formatting (especially hyperlinks) is carried over into Lookup fields!Airtable, please support this function! 

I've seen iterations on this question, but never an answer that works for my case.I have a base for newsletter management. Two tables in the base (others omitted for clarity), one to track and manage the weekly newsletter (author, topics, etc.) and one for events and holidays in our community.I'd like to put them together into a master calendar. I have been trying to do it at the field/formula level on a new table, but can't figure it out. I only need two fields, the date of the entry, and a subject or name field.I think I could solve this if I could get a calendar view to subscribe to another calendar view's exported iCal URL, but I can't figure out how to do that either.Any help? 

Airtable

yo quiero que poner varias veces "borja" en esa celda

hola necesito saber si puedo cambiar estos datos por otros

after delete attachments for 20 days,it also say over limite

I made a massive mistake when doing some updates to a base, so I figured I'd restore a snap shot. I created a snapshot copy of the base, and deleted the original. This has just compounded my issue because all my data syncing to other bases is totally messed up. This also impacts several automations i've created to work around the fact that my company wont shell out for two way sync features. What a headache. It seems to me this wouldn't be an issue if I were able change the source link to my sync set up to the snapshot base, but alas I get the following error.HELP!!!!

Hi all! I have a two-way sync enabled between two bases. On the source base I have enabled edits from the target base, and I am able to add individual records on the target base and have these show up on the source base. However, the Import CSV extension shows an error that says I cannot create new records in the target base.I am 100% sure it's not a settings problem in the sync because I am able to add individual new records on the target base. Can anyone advise? Is this just a bug on the extension?Thanks in advace!Alex

I manage an instance of SF at a company of 50+ employees. I would like to build an airtable base that generally mirrors it, but is better, and then establish a sync between the base I build and Salesforce. Has anyone done anything like this? Was the documentation helpful enough for me to rely on it to do a project like this?

Hi, I coud use some help on what I think is a relatively simple few concepts.I have a base called "Sales Pipeline" where I am tracking:Deal Name (Acme, Inc)Pipeline Stage (intro, qualified, opportunity etc)Opportunity Status (active, lost, won)Let's say there are 100 total records, each with a Deal Name, a Pipeline Stage and an Opp StatusI'd like to be able to: Calculate the Intro to Qualified conversion % (so if we've had 100 records at the "Intro Stage" and 62 have converted to the "Qualified" stage, then we should show a 62% conversion)Same for Qualified to Opportunity etcSimilarly, I want to be able reflect the Opportunity Status conversion % as well. So for example, if we have 100 records that entered the funnel at the "Intro" Stage, and 62 converted to "Qualified" but since then 32 of those have an Opportunity Status of "Lost", we'd really only want to reflect an Intro > Qualified (A

Hi Everyone,I'm very new to Airtable and anything like it. I am trying to create a base that captures our firm's new clients and tracks their onboarding process. The problem I'm having is that a new client can go through different/multiple processes depending on the service relationship(s). For example, one client can have 3 different service relationships at the same time and all 3 may share multiple onboarding stages but also have stages that are distinct to the service relationship.I would like a base where I can enter in the client's name and select the appropriate service relationship(s). Each service relationship will have it's onboarding stages, with the correct assigned staff to complete the task. Each service will also designate what forms are required. Everyone can see where a new client is in the process for situational awareness and also know when they have a task to complete. As an staff member completes a task it automatically moves to the next stage and