Base Design

Hi there,I am building a base with 2 tabs: the first one is for data entry and to be linked to the second tab which contains standardized data.  About 5-10% of the data in the second tab updates frequently and the data in tab 1 must reflect the data in tab 2 on the date of entry, meaning the data in tab 1 should maintain the old data and if new data is entered, it will show the most current data from tab 2.How do you counter this problem?  Any insights or help will be appreciated.  Thank you very much! 

Hello there,I am trying to automatically delete records after 1 week. As I am in free plan, I can't run scripts (currently I don't want to upgrade). I set up a field which tags every opportunity with a delete text. Can someone tell me how to solve that with the Search Step in Make (formerly Integromat). The following delete step is not the problem, I guess. Somehow, I just don't find the right formula.Thanks in advance!

Hi there,I've created a base where I track all of the marketing activity for a number of shows, and now wish to track the weekly sales and present them in a line graph, similar to how you would in Excel.At the moment, I have a column in a table called 'Revenue To-Date' where I update the figure. However, this is replacing the data each time rather than tracking it in order to show trends. I'm open to using an app or building out another table but would love a simple way to update this via the interface I have built out.The data itself comes through via an email each day as an Excel spreadsheet, so if there was a way for this to be automated, too, I'd love to learn the best way to configure.Thanks in advance!

Bonjour à tous,c'est mon premier post ici, j'espère être au bon endroit. J'ai déjà cherché les sujets en ligne mais je n'ai pas trouvé de réponses.Je suis débutant sur airtable, je souhaiterais faire des connexions entre deux tables d'une même base de données. Je m'explique, je souhaite créer mon CRM immobilier ou mes produits à vendre qui ont des caractéristiques spécifiques : ville, prix, nombre de pièces, jardin etc... pour être "confronté" aux recherches de mes prospects qui ont les mêmes caractéristiques de recherche.Par exemple, si j'enregistre un nouveau bien avec la caractéristique ville + prix + jardin + nombre de pièces, proposez-moi tous les prospects qui ont cette même recherche (idéalement avec un pourcentage d'erreur sur le prix) et inversement si j'enregistre un nouveau prospect.Je cherche depuis plusieurs jours une solution,

Test

I learned that we can do employee surveys by creating a form view. We’ve got a number of questions added to the forms, but there are other questions I’m considering. I don’t yet want to put them in the form. Is there a way for me to add a sort of note-to-self in a form view to remind that, “hey, here are a couple of additional questions you might want to consider?” If I was looking at a grid view, I’d just type those in a cell.

Hello everyone,I have a complex use case that I would like to implement in Airtable.I have a table “Projects” where projects can be created via a form. Among other things, the form must specify how the project affects our strategic goals. So we have 6 fields with strategic objectives where the user can rate 1-10. “Strategic Objective A”, ‘Strategic Objective B’ etc.Now these strategic objectives can change from year to year. However, I would like to know for each project on the basis of which objectives we defined the prioritization at the start of the project.I would therefore create another table where the objectives are recorded annually and the prioritization of the objectives is recorded in another field.Now I would like my interface (project overview) to display the objectives/priorities for each project that were defined at the start of the project, even if our general strategic objectives have changed in the meantime. How

Hi Airtable Community!Problem: I'm having trouble adding a linked record to multiple records without erasing the data that is already in the cell.ContextI've got one table of studies, and another table of people. Each person can be linked to any number of studies in a "Contacted" field. Sometimes that field is empty, if that person hasn't been contacted yet, and sometimes it has a few linked records (studies) in there already.If I contact 50 people, I want to add the study I contacted them for to their record. If I copy/paste the study to the cell, this overwrites the existing data , so if there were 3 studies in there to start, I'll erase them if I paste in the new study. What I triedI made a field that concatenates the study name I'm adding with the study names already in the "contacted" field, and it comes out as text. If I then paste the text into the "contacted" field, voila, I have all of t

I am in real estate. I started with a Deals table, but now realize I should have a Properties table...so I did the following:duplicated the deals Tableattempted to then link back to DealsBut won't let me copy and pasteHere is a link to a video...please help. Thank you everyone.https://share.zight.com/BluPqq0jBest,Johnjgiordani@gmail.com

Hey all, So, I’m trying to create a good poker league base, to track our friendly poker club results. I’m the only editor and I’m thinking about creating forms to allow other to enlist themselves to tournaments, I’ll create. So far, the base structure is: Players - personal info about the players in the club, such as name, phone number etc… Tournaments - list of the tournaments with date, properties etc… Leaderboard - as the name suggests, a leaderboard. who earned the most Balance - supposed to be a running balance. deposits by players and money sent to winners Results - Name of a tournament and the winners. Bear in mind, ClubGG (the poker platform we use) doesn’t has an API. so, we input everything manually. how would track rebuys in realtime? a form with a “+” button that adds +1 in the “rebuy” column ? What’s the correct way to list the players in each tournament? one line per

Hello, I want to send a form to users to sign up to an activity so the user can provide their contact information and their acknowledgement to have read certain conditions. I know how to configure the basic personal information, but what’s the best way to do the section for reading and acknowledging the conditions? I don’t have a place on the web to put the text to read so I can’t send the reader to an external link. Is there a way to link to a separate field in a base, with very long text ? I would have to do this for three conditions. I was thinking: One of the field has to be a long text “X” to read. The next field would be a single check box “I have read X” Any suggestions? Thank you

I have a contest that has 3 rounds that are dependent on each other to start and stop. Each Customer's contest could have different durations for each of the round. They usually define a start date and a duration.For each contest record I define: Name of contestNominationsStartDuration EndRound 1StartDurationEndRound 2StartDurationEndI would like to use date dependencies to link the three rounds, so if I change the start date or duration of any round, the next rounds dates will shift. I have tried to configure the date dependencies but it looks like I can only set one configuration per record.  Is there any way around this that I am missing? Thanks in advance

Wondering if anybody has the same challenge, or has thought of a solution/workaround to help monitor Interfaces across multiple Bases?My team manages many similar projects that we run for multiple clients, and for confidentiality reasons the data for each project should be stored in its own individual Base. In each Base, we have data to report on overall project status which we currently present in an Interface.Now, our project managers find themselves needing to understand holistically the status of 20+ projects, but now must manually locate and open 20+ Interfaces to view each one. This is something they must do on a daily basis.Does anybody have a solution to bring all the Interfaces one would like to continuously monitor into one singular location? 

Would be great to have a better to navigate across tables - i have a base with more than 50 tables that is difficult to manage

Hello,AirTable introduce AI Feature few months ago but I don"t see Vector Search or Semantic Search.I found this project Ask-Airy that provide a very interesting design a year ago.It create an Embeding for each table's rowIt create a HyDE of Row based on user query to build an EmbedingIt search the results using Cosine Similarity (I'm struggle here)I like the way it is done but I lack of explanations. I think AirTable should provide this kind of feature natively.As a GPT developers I'm looking for RAG applications.Yes I could use a SaaS database like PinecoreYes I could use Azure / OpenAI Search APIsBut what about AirTable ?I have a lot of interesting Data into AirTable, I'd love to simply query AirTable with Semantic or Vector search then get top X results and fill back my LLM tools.Any ideas

Super strange but I have an issue with airtable at the moment. Links are not clickable in the URL field sometimes. This is specifically if the table cell size is small.It renders an entire webpage! How do I make this a normal link again so our users can actually CLICK on the thing?

Is it possible to create a base that pulls in different tables from different bases? For example, if there are 4 different workspaces (brand) with it's own unique base, and each base has a tab called "X" - is there a way to create a net new base or interface that pulls in "X" tabs from the different bases so that this base can see all 4 "X" tabs in one place?If yes, if/when any changes are made in "X" tab in the original base, will it update/sync with the net new base or interface? Trying to find a solution in Airtable that can help with increased team access and visibility across teams that work on different brands to minimize duplicative work and increase cross-sharing, thus improve overall efficiency and productivity. 

Hi everyone,I need some guidance on designing a base to support the following scenario.My product design team is responsible for approximately 30 distinct products, organized into eight groups. We need to provide weekly updates per product to leadership every Friday. The updates will consist of a few bullets per product.I am not sure how to design the base (and subsequent reporting interface) for these weekly time bound updates.Any advice will be appreciated so much! Thanks for taking the time to read my question and thank you in advance if you are able to assist!

The interface makes zero logical sense.  There are no error messages.  The Help documentation is written for a specific example, not understanding of how to use the tool. The Interface is broken and non consistent.I'm a big advocate for Airtable, but this is just atrocious in design and implementation for something that is so simple in concept. 

Hi All,I'm struggling with finding the right way to deal with multiple links between two tables.I have a Base with a People table, and a Milestone table, as well as a Teams table. Milestones have an Owner (link to People), and several teams (link to Teams table). Each team has a link (multiple entries allowed) to the People table. This works great for assigning people to different roles on each milestone and have a singular Owner who is leading/responsible for the milestone.However, I want to be able to go to the People table and have a list of all milestones a person is assigned to, no matter whether the person is the Owner or in a team. I have found a way to use a lookup to get all the milestones a person is assigned as a team member, but I need to add the Owner to this list. I don't want to do a simple formula doing a concatenate, because then I can't filter by People in the interface to show everything a person is working on in the calendar/timel

Hi AllI created a form for my drive team.  The form information has start time, end time, etc.  The form information goes into my master spreadsheet.  The team members do not have a paid AT account - Only I do.Is there a way that the information on the form that goes into my spreadsheet could be automatically emailed to the user that submitted the form to me?

I have two different tables in one data base.Table A has a list of unique topics, and each of them is sorted into 'Categories' (via a single select column), and has linked records (from Table B), which represent unique people (it's a formula column though).Table B has the list of unique people (formula column), and I'd like to create multiple columns, one for each category in Table A, to break up the topics corresponding to each person, by category.When I create a second linked record for Topics in Table B, filtering by value, it's fully independent from my first linking (vs showing a subset of it). See attached.The output I would like is, for row 1 in Table B, to see "Topic A" listed in the `Topic - X Category` column. Is there a way to do that?Thank you so much! 

Hello,I need to create my own view under a task. When I duplicate the original task, any changes I make to the duplicate base affects the original one. How can I create my own task list/view without affecting the original one?

Hello there! Currently we use Google forms to gather registration information from clients. Is there a way of creating a registration form on Airtable, from which the answers would go automatically to our Airtable base please? I am trying to avoid copying and pasting… Although I am sure there is a better way of importing this data too. thanks, Reeta

Did Airtable ever implement any type of Captcha with forms?