Base Design

Could you help us customize the width and length of the input form fields / boxes on this form? Airtable

I'm re-inventing the wheel and mine is currently square. Is there anyone here who can help on how best to map product availability?My use case is translation rights -  where a manuscript which can be sold across territories (~60), languages (~50) and formats (~5) e.g. 'BOOKTITLE' sold to North American ex Canada, English, Print or perhaps World-German-Audio. Can be re-sold on expiry.What is the best way to capture this without bloat? Currently just listing what is sold, on understanding if not listed, then not sold. Could anyone point to product sales approaches which I could take a look at and learn from?Thank you Current ideas:'Right Table' with all variations for each manuscript. Run a script: for each manuscript, loop through all territories and languages adjusting with a bit of publishing industry-specific logic and create a record for each? On sale, terms and details attached to tha

Hi there,I'm working on a Table where I input weekly sales figures and each Monday of every week. The columns are as follows: Sales > Shows (Linked Records to another Table) > Date.Ideally, I'd like an automation to run to create say 30 new records with the date and Shows populated. This format stays the same every week, it's just that I want to remove the need to copy and paste, creating these from scratch every Monday, so all I need to do is enter the sales figures.Any help would be greatly appreciated 🙂

I have a view of all the tasks assigned this week grouped by the main assignee. I have now added a another user field called support and I'm looking for a way to group by if the person is the main assignee or the support so I can see all the tasks they need to be working on, not just the ones they are the main POC on.Is there a way to do this? I figure it's with a formula but I can't figure it out. I know I could do this with individual views filtered by if assignee is X person OR support is X person, but I want to be able to see all the tasks for all the people in 1 view.

Hello, I am trying to collect two types of survey responses through Fillout parent & child form that are linked to two separate Airtable tables.1) I am using the record picker option on Fillout to let respondents create new records. Currently, only child form responses are updated on Airtable and the parent form responses do not get updated on Airtable even though they are integrated correctly. What could be the issue with this problem?2) Is there a way to set titles to the new records created by respondents? Currently the new selected record appears as a blank. 3) Even though I have integrated the respondent identifiers for both parent and child form, the unique link to log or identifier (name) columns do not get updated on Airtable. Is there a solution for this? Any help will be appreciated. Thank you in advance! 

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