Other Questions

I'm running into a problem. I have a "projects" table and then I have a "tasks" table. In the tasks table. Within the tasks table, certain tasks are subtasks/child tasks. Under each project, the tasks for that project appear. I have nesting enabled. The nesting works for the parent/child task. But the child task appears twice in the same list both as a subtask/child task as well as a parent task (without subtasks). It isn't a duplicate record. It's the same record. When I make changes to the record, the same change is immediately reflected in the alternative record. Not sure why it is doing this.

HiIs there a way to send a record by email (manually not an automation) that does not show the titles of each column if it is an empty field? Even if the column is hidden it still comes through on the email.To explain further, I'll have a meeting to present concepts, each meeting I could show between 2 - 10 concepts and for each concept there is a name, image, description and link. My problem is that I need to set the table up for the max number of concepts shown and then I email the client after the meeting with the record of what was presented and all the info for each concept. If I send the record with just 2 concepts the email also shows the title of each column which is empty making it appear as if there is info missing. i.eConcept 3Concept 3 descriptionConcept 3 link etc etcIf someone could help me please I'd be very grateful. Many thanks 

Greetings all, I am building a non-profit membership tracking system that pulls in new member requests from our Mailchimp list and invoices from our Xero system. I am used to the standard unique key, foreign key database structure and am struggle a bit to understand Airtable’s relationship structure. As of now, our mailchimp list and xero invoices link OK on somene’s primary email address, which is my unique identifier for the Contact table. I realize that if they change / udpate their email address (which happens), that connector will break. It took me a long time to realize that the first column of each is automatically the “unique” ID, even if it allows for multiple identical string entries. So, originally I had full name as the first column, but John Smith and John Smith can exist and are not the same person… which screws up the linked tables. “Name” + “Company” (or any secondary field) doesn’t work well either, as often times people don’t fill out too much in the forms. Phone n

I have a View of records with populated date fields.  Is there a way to change all the times so that all the times are 5:00pm while keeping the same date?  I only want to do this to a view of records in the table, not the entire table.June 4, 2023 12:00amJune 11, 2023 12:00amJune 18, 2023 12:00amJune 25, 2023 12:00amJuly 2, 2023 12:00am

Hello,Does it happen to you that the downloaded setup file to install Airtable app for Windows 10 was blocked by antivirus, saying that it is affected by IDP Generic?The webpage from which I downloaded it from is:https://www.airtable.com/downloadsThe antivirus blocking it is Avast.Thank you,FrancescoZ

Hi there,I'm not a developer but I'm exploring and using various scripting options, but can't seem to mitigate the crash I encounter when to use the script below. Can someone help with this? Thanks in advance!The feature I want to build is a bigger one: it's a vlookup feature with auto categorization based on the intermediate table [personal categorization] - so a script to conditionally link a record.But this is a simplified version without that auto vlookup to focus first on the crash when trying to link a record:Here I choose one record from table [personal expenses] and one from the table [personal categorization].The field [Type] in table [personal categorization] is a linked field with a link to a record in a 3rd table [personal budget].What I want to do in the end, is that the chosen record in [personal expenses] is linked to the record in [personal budget] via the field [tmpLookUpLinks], and that value should be retrieve

Hi,I’m using Airtable for our fundraising Auction database to store items to then upload to our Auction website. We have our items in Airtable and then different image fields for the donation. We have 10 image fields. Each field has its own image. Those images are named by the product ID we assign them.Anyway, the issue I’m wondering about is when I download the CSV of items to then upload to our Auction website, some of the image fields have the image file name which is great, and then a lot of them have the image file name AND then a link to the image in parentheses as well. I’d like it to just have the name of the file without the parentheses and the link, nothing else. Is that possible?Here is an example of an item with two images: Argus BarGrilleArgus BarGrille $30 Gift Certificatechecked3336

Not too bright of me, I know, but I have a number of bases with similar names and versions of the same general content.  I'm trying to figure out how I can determine which one is the most 'up-to-date' without cross-comparing each and every line of all of them.  The Home screen doesn't tell me when a base was last edited, or originally created, it only tells me when a base was last opened--which is utterly not helpful when you're clicking around through old bases trying to find the right one (so they all report being opened within the last hour).Is there some other interface or button I am missing, or a secret 'info menu' to be found somewhere in my account that would give me more detailed stats about the creation and edit history of a particular base?  I'm thinking something like the 'Get Info' option that right clicking a folder gives you on a Mac.Also not too bright of me, I didn't realize I needed to proactively click

I have created a table that we record the time it takes us to carry out specific tasks for clients. I have created a subsequent view for each client and shared with them a private link so they can always see what tasks we are carrying out and how long it takes. However, on the subsequent grid view, I would like a filter to show only the work undertaken this billing period. e.g. from the 1st of the month to today’s date. Is this possible? At the moment I have a filter that is: Date “is on or after” + “exact date” + “1st Dec” However, I have to manually change that date each month. is there another option that would work rather manually changing it each month? Any ideas would be appreciated.

Simple and easy question, I plan on using airtable with a group of 25 for a project. Is it possible that I can allow all of them to edit on the free plan?

Hi! I’m looking for a way to limit the Date field in my form so that the person filling out the form is not able to select the current date, only dates in the future. Is this possible?

I’d like to update the Status column of a record when a specific time listed in that record is passed. This is to create a social media publishing calendar. I add a post time to a record. When it is that time, the records status column is updated to Approval. I then have a separate view filtered by Status=Approval where I’ll review records that need to be approved. I currently have the Status column set as a single select as Queue, Approval, and Posted. If possible, I’d prefer to do this via a formula column but am open to setting it as an automation. Thanks for the help!

Bonjour à tous, J'ai besoin d'aide de la communauté airtable ! 🙏 Je pense être au bon endroit ! 😉J'explique ma requête. Nous travaillons depuis quelques mois sur airtable, nous devons refaire notre site internet, et avons envie de lier airtable à notre site ( que les clients puissent remplir des formulaires et que l'on ai directement les infos sur une nouvelles demande) bref. 🙂L'agence qui refait notre site, voudrait l'accès à "l'interface designer" de nos formulaires. Nous ne voulons pas leur divulguer toutes nos informations, j'aurais juste voulu leur partager la vue "formulaire" mais ils ont besoin d'avoir accès aux fonctionnalités permettant de construire le formulaire en tant que tel. ( voir photo )Comment faire ?  Merci d'avance. 🙏 Camille 

How do I adjust the grid width of a field the mobile (iPhone) app? When I touch the grid header I can slide the column to a new location, but no amount of fiddling seems to affect the width of the field. Thanks!

I have tried wrapping both fields in VALUE(field), ABS(field), etc. How do I get this to behave? What is the reasoning behind this?

How can I use the Gannt Chart feature when our tasks don’t start or end on a specific date? I run a general contracting company and no incoming project starts on the same date. Furthermore, not all projects are the same, so alternative tasks might need to be triggered based on the circumstance. The only dates used are follow-up after X amount of days and schedule dates. Suggestions?

I have a table with Presentations and another table for Speaker Evaluations.  The Presentation Title is a Linked Field in the Speaker Evaluation Table to link the two tables.  I also have a Look-up Field for the Speaker's Name.  I am making a form for the Speaker Evaluations.  The first item is to choose the presentation.  I would like the look-up field for the speaker to show up in the form as non-editable so the evaluator is reminded of who they are evaluating.  The form currently will not show it.  Is there a workaround? 

With the recent introduction of the limit of 100 synced downstream bases per upstream base, we realise that one of our bases has over 200 such downstream synced bases, exceeding the limit. So we receive the error "The source application has reached the maximum allowable number of synced targets". Many of these downstream bases show as unknown, with unknown creators.My question is, how do we remove (not just disconnect, as this reportedly still counts towards the limit) the unknown bases from the upstream base? Bonus points if this can be achieved without breaking the syncs to the wanted downstream bases.

I'm working on base to track hotel room usage for a conference, and would like to set up a dashboard to show nightly occupancy against our contracted number of rooms per night. This is my setup in GSheets which works great, and ideally I'd like to replicate something like this in AirTable:In my base design, I have a reservations table with room type, check-in, and check-out fields. Any ideas?Thanks!

Hello! I'm relatively new to using AirTable and was wondering if there is an extension that will allow me to take Airtable records and show them in a dated vertical timeline that can be printed out? I know there is a new horizontal timeline feature in the pro version, but I need something that goes vertical down the page. I would also prefer it to be accessible in the free version of AirTable as I plan on sharing my base with others in my community for their personal use. Thank you!

is there any way by which we can create base dynamically through our app like mysql

Hello!I am integrating Airtable with my calendar app and using it to schedule meetings. I want to include a link to the zoom room we are using on that meeting but the link is not showing up, even though the label is on. On the calendar app I can only see the name and a link to the task. Can someone help me?

Good afternoon!Task: integration Gitlab and Airtable.Defenition of done:1. Airtable has all the projects from git.2. Airtable has all the tasks from git.3. All new tasks in gitlab (for every project) appear in Airtable automatically4. I can see metrics in Airtable:- velocity- each employee's workload by hours5. I can see charts (diagramms) in Airtable:- gant- burndown- cumulative6. I can create reports in AirtableTask condition:- free version of gitlab is installed- paid version of the gitlab with analytics is not suitable- Airtable is only for management, so I will not moving development work (all tasks continue to be created in gitlab)Question about the task: do I need to create users in Airtable to be able to read the analytics for the transferred tasks (from gitlab to Airtable) to ensure correct in

Hi,I have a base with a "Workorders" table, to that workorder I would like to be able to add parts from my "Spare parts" table by scanning the barcode of that spare part (instead of writing in the search box).Each spare part has a barcode field with their unique barcode.Is this possible? At the moment I can't see any other way to link to a record then to manually type and find the right part.As there are so many parts in play with similar names, being able to find them by their barcode would be great help.Anyone know if this is even possible?

We are setting up Airtable to manage multiple projects and multiple teams. Each project has its own Base, and each Project Base has its own task list. Is there a way to see all tasks across all projects in one place? One of the main problems we are trying to solve is to find a way for each team member to see all of his or her tasks in one place even though they are located in various bases. Thanks for the help and suggestions. Jason