Ask the Community

Trying to link some fields and I keep getting this message - “No available sources to look up. Add a lookup source, then try to configure your lookup again.” I do have some fields linked but have run into this on others

I am using the event planning template and have entered my tasks. I am trying to create an interface of the tasks but my event is not showing up in the drop down. Is there a way to fix this?  

My table includes three date fields: Joined, Separated, and Date Rejoined, along with two formula fields: Prior Years and Total Years of Service.I’ve now added two additional fields: Date Separated 2 and Prior Years 2, to account for members who have separated and rejoined more than once. Some members join, then separate, later rejoin, and eventually separate again. I need to accurately track their total time as active members, excluding any periods when they were separated.The original formula for Total Years of Service worked well—until I had to include a second separation date.Here is the formula that worked originally but now I need to take into account the second separated date.If anyone can rewrite this for me, I would be grateful. I am not good at formulas. IF(AND({Date Rejoined}, {Separated}, {Joined}), DATETIME_DIFF({Separated}, {Joined}, 'days') + DATETIME_DIFF(TODAY(), {Date Rejoined}, 'days'), IF(AND({Joined}, {Separated}), DATETIME_DIFF({Separated}, {Joined}, 'days'), IF({

I’m currently experiencing a service issue where scripts are just showing “In Progress...” and not completing.  Other automations are working fine.  I have two scripts that call external services, I’ve verified that both services are working properly.  I’ve restarted the automation.  Ive re-ran a run that was successful earlier today, and that one is in progress.  There seems to be an issue on the Airtable side...

For some reason, ALL of my automations across ALL of my bases are stalling on the Scripting Block step and I don’t know why… I’m pretty sure this is an Airtable outage issue, but I’m curious if others are also seeing the same thing.  I’ve tried contacting Airtable support and it seems to go nowhere… super frustrated...

Hi there!I've been playing with the Utilization summary grouped by Assignee in the Project Management template and am trying to figure out if there is a task that is assigned to multiple users show up in each users field and have the time spilt evenly.I see that you can have the time split evenly in the properties settings but when a task has multiple users it shows as a task in whatever the combination of users is because I've grouped by User. I'd rather see the task in both users individual grouping with time split equal.Any one run into this and have a solution?

Anyone else seeing this? On the simplest scripts, like ```console.log(‘hello world’);```I’m getting a “Running...” in tests until it times out, no errors or console logs whatsoever. Scripts that have been working for years are all of a sudden not functioning.

The persistent comments panel on the right side of the Interface Designer can be distracting and takes up valuable screen space—especially when working with detailed layouts or limited screen real estate. It would be great to have the option to collapse or hide this panel to improve focus and design flexibility without needing to disable the feature.Would love to see this added to enhance the usability of the interface builder.Thanks!

I don’t see anything anywhere that says it can, however, I wonder if someone has figured it out.

Hey all, I am building a base for live event production and I have run into a road block. In the interface I have a button to upload csv files for client info and needs. The button just goes to the URL for the extension in full screen. Because of the computer literacy of some of my co workers I need to make things as simple as possible. When duplicating the base for a new event, is there an automation or script that can update the new URL. I have a table called URLs that feeds the button. Thank you  

I am currently on the Team Plan. The first day I created my webhook trigger automations they worked fine. Now they will only work and create a new record if I manually click on “Run Test”. Automation is turned on and webhook is triggering. Am I missing a setting?

Is there a way to create an automation to update the comment bar in a record?As in, triggering something to automatically leave a comment. 

Does anyone know of a way to create an automation where when a new recording is created, it uses the GPT chat API as the first column for text input and the second column to get the output response from the GPT chat? For example, column 1 (input) = Hi, how are you? and column 2 (response) = Hi, I'm doing great!The native GPT chat in Airtable is quite expensive.

Hola a todos, estoy creando formularios de ingreso de datos sin embargo me encuentro con el problema de que las celdas multivariables y los links records no son capaces de por ejemplo asociar 5 profesores a 5 roles y 5 asignaturas.Estoy intentando hacerlo a través de scripts y automatizaciones sin embargo no he podido lograrlo, alguién tiene alguna sugerencia de como abarcar este problema? La idea es ahorrarle tiempo al digitador de datos, y para esto lo mas optimo que he encontrado es generar un formulario que contenga toda la información correspondiente y con automatizaciones completar las demás tablas, pero cuando hay que agregar varios registros al mismo tiempo y estos deben asociarse a otras variables no he podido lograrlo. Por otro lado tampoco quiero generar 100 columnas en caso de tener que inscribir a 100 personas. Saludos,  

I would love to see the overview interface be able to be shared publicly.  I have a base with multiple tables.  I use the data to share different information with clients in a read only format.  Currently I have to create an interface for each table and share that each one individually.  I would love to use the overview interface be available for public sharing so I can link each tables interface page to that and just share that one page.

Hi there, I’m watching an airtable demo from November that says field-level coloring has been added but I don’t see any options and they don’t explain how it’s done! I’m on the enterprise plan.

I have created a gallery style interface with research data I share with read-only collaborators.  The base includes a URL field with links to source information. This link is included in the interface, but is not visible to my collaborators.  I’ve tried converting it to a single line text and to a formula and removed the https:\\ so it is no longer a link.    I’m using the free plan.  Any help greatly appreciated. 

Bonjour la Communauté, J’ai crée une appli pour un club sportif en prenant garde à choisir des interfaces “Ordinateurs” et “Mobiles” notamment au niveau des interfaces de types Galerie.Big problème : les boutons de mon interface ne s’affiche pas sur les mobiles alors qu’ils sont sur les navigateurs web.Aucun paramètres ne permet de corriger ce problème à ma connaissance.Donc je viens chercher des infos et de l’aide.Vue depuis le navigateur web vs Vue Mobile  Donc comment faire pour voir mon bouton ????Je n’ai pas de solution de contournement car dans ce bouton je pointe sur l’url d’un formulaire public adressé à des utilisateurs “Visiteurs” qui n’ont donc pas accès à la base mais peuvent grâce à ce formulaire retourner des données pour l’alimenter.Merci pour votre aide 

Hi - I have a project management and resource tracker AirTable built. I’d like to be able to look at how many hours someone worked in a previous week. Currently I have a rollup from “time entries” to “team” filtered by a formula within time entries that calculates if a time entry was within the last 7 days. But, leadership would like to review this information on (mostly) Thursdays for the previous calendar week. I’m not able to simply adjust the number of days as leadership may look at this information on a Wednesday or Friday.  Is there a way to calculate this information?  Thanks!

We are using Airtable to manage specific deliverables across many different projects. There are separate teams working on different projects and each project has its own Base. Let's call the bases Project A, Project B, and Project C. We created a shared Base that pulls in records from Projects A, B, and C in Grid and Calendar views. But I can't figure out, in Grid view, how to also include the name of the Base (where the record is coming from) in that shared Base. Anyone have the answer?

Hi, I am creating an interface and I Airtable just dropped me into a view of the interface designer where I could easily duplicate and rearrange user filters. However, now I can’t find that particular view anymore. Where can I easily duplicate user filters. Reason why I want this is because I want to add a tab for every month. And otherwise I have to manually add each tab with 2 filters in it. 

I would appreciate any input for such task:I need to determine if TODAY() falls within a date range, say from March 1st to October 31st, regardless of the year.So I need to compare TODAY() with start date and end date without the year, but only with day and month.I cannot figure out how to do it.Thanks for any thoughts

Hi there, I am trying to output text that is taking the text from the lookup field "Name" and taking it away from a field called "Conversations" Currently, I am trying to do this in a formula but for some reason it keeps saying #ERROR!    

En la vista Kaban. Me muestra campos que no quiero que aparezcan. Y no tengo opción de sacarlos, solamente en la edición me deja ponerlos en el encabezado o ponerlos en el cuerpo. Pero no me da la opción de no ponerlos.

Hi Dear community I'm new on airtable and looking for how to control my stockInventory management  Need your help or if you have sample database Most welcome