Ask the Community

Hello folks,I have a record picker, and cannot find a way to fix some letters truncation in the name field on the heading of the details pane.(That field comes from the primary field of the underlying table, 'Seasons')The problem is that the value of the field appears misaligned from the area defined to it. This causes tall letters (see "p" and "g" in the image below) to show truncated. If I have a means to specify the vertical alignment as 'centered' then it would show those letters full.When I enter edit mode and select the name field I get this view:    On the right-side pane the properties of the field are displayed:[Data tab]Source: Seasons (Record list)Field : Name[Appearance tab]Size : drop-down list: Default | LargeLabel

Hi everybody,I have the following issue and hope somebody can help me with that!Background:I have setup a form in Webflow and want to push the data to an Airtable table. I created a flow in Webflow (The second step in the webflow form is "Make HTTP request", "Authentication" is set to "None", In this step I added the Hook URL I copied from the Automation in Airtable).The corresponding flow is setup and tested in Workflow and setup and tested in Airtable. I was able to map the colums from Airtable with the actual data from Webflow. When I run a test in Webflow where I build the flow a new line with all the data is created in the Airtable table - same when I test the automation in Airtable itself.Here is the problem:When I submit data via the form on the website I build with Webflow, a new line

A common theme we are seeing with project management bases is the desire to have project and task templates. When you create a new project, it can then generate the corresponding set of tasks, and maintain the basic details about those tasks, including the relationships and dependencies amongst those tasks. This is similar to Creating Tasks from a Template with a few differences. When creating projects, we often find we create a new record in our projects table, and then want to link it to a set of metadata (a project template). From there, each project template should know its associated set of tasks. This allows us to add more project templates over time, and change the set of tasks required to complete each of those projects. Additionally, the script will ensure that the dependencies between the task templates are maintained when creating the tasks for a new project. You ca

Hello! I need some help with creating an automation. I attempted it, but was unsuccessful. I have a base called "CRM". In that base are tables called "Bookings Log" and "People". Here is what I want to happen in the automation: 1. When a record is created in "Bookings Log" 2. The automation searches a specific view in "People" to see if there is a matching email address (as compared to the record in "Bookings Log"). This email address will be dynamic. 3. If there is NOT a matching email address, a message is sent to Slack Could someone please help me to create this automation? Thank you in advance for your assistance!

I missed a live webinar called 'Getting Started in AirTable'.Each time I click the link to view the 'On-Demand' webinar, it takes me to a page to fill in my details and doesn't actually show me the webinar. I enter my details, and nothing happens.Any ideas on how to access the webinar?

So I have been trying to get ahold of sales as we are looking at upgrading to Enterprise and need some information and help. IT seems every time I send a ticket to talk to sales I never get a response. What do I do now? 

In two different bases, I have just noticed a few automations that were disabled (they have been working just fine for the past year)....there's a triangle with an exclamation point inside of it. There's no message or indication as to why they were disabled and I was not notified of this by Airtable....someone submitted a form and didn't hear back from us so they sent us an email and that's how I found out about it.I turned most of the automations on just fine, but one of them just won't turn back on. When I try to turn it on, it hangs there for a few seconds and then turns itself back off. I have tested the automation and it works fine. I made a duplicate of the automation, tested that and it works just fine but that one also won't stay turned on.The automation doesn't link to any 3rd party apps (I saw some suggestion of this in this troubleshooting page), but it does s

Hi there!  We're setting up a volunteer shift database for a large festival. I assume we can let volunteers sign up for shifts using forms, but is there a way for them to change/drop shifts without having to email us to do it on the backend? If not, is there an extension that would help?

Hi - I have a table with a list of cash flows, dates. These are linked to another table which contains individual deals. I want to calculate, for each deal, the IRR - in Excel this is using the IRR function which takes a list of dates and a list of cash flows and returns a single IRR number. Can this be done in Airtable? Rollups seem to only allow calculations involving one linked field only - whereas I need two: both date and cashflow. Also, there doesn’t seem to be an IRR function. The calculation is relatively straight forward, can I code my own function to support this? Secondary question - right now I have to manually for each date/cash flow record link it to a given deal. Is there a way to link all cash flows where dealID equals x?

I don’t think this is an option right now, but it would be nice if when you went into a Kan-ban view - you either could change your settings to open in a collapsed view or at least have the option to Collapse All when you open that view. If you have many columns…default of collapse would make it easier to get to what you want faster instead of scrolling. Seems like a logical and productive option to provide users. Emma

Hey all, I'm the co-founder of a software startup called Slideform that helps link your Airtable records to your slides. I know there have been a few questions asked about this in this forum, so I thought I'd post something here just in case anyone is interested.Our key capabilities include:- Ability to replace specific text elements with your Airtable records (with a variety of ways of querying your data). This ability still preserves the original formatting of your slides.- Ability to link up & mix other data sources, including Google Sheets- Support for shared image attachmentsWe primarily work with client-facing and operations teams that send out regular account health decks but I'd love to hear what sort of use case you might be interested in!

Hi folks, I was able to extract initials from full name (thanks to the Name demo base from @W_Vann_Hall ), but because of duplicate names, I added the email as part of the customer identifier (full name + email), which lives in my Customer table. Now I can’t seem to figure out how to extract the initials from this new field. When I try to apply the same formulas to the Name field linked to my Customer table, the formulas no longer work (because I guess it’s merely a linked record, not actual value?). So I created a second table called New Name Table, and extracted the initials under that table first, then linked it back to my original table. But the values are not populating when new records come in (i.e. blank records in the screenshot). FYI the field “Calculation” is the first initial

Hi there, I am brand new and been reviewing all the support docs but cant quite figure this one out.  I want to create a list of tasks that will always be the same, and will populate based on the type of field.  For example, I am using airtable with our content team who produces different type of content from blog posts to social media.  If the task is tagged "blog" I want to create a checkbox field for blog that always pulls in the same type of data "1st draft, images created, SEO review" vs if its a social media post I want to tag is as "social" and always pull in the same set of data "Image, hashtags, description"So far I feel like I would have to manually copy this each time.  I tried adding the subtasks to a different table and making an automation, but got a little lost and not sure thats the right option.  

Recently, our institutional emails have been updated. Unfortunately, due to the change to a shortened version we can not access and update our account. We are not able to log into the system since we use Google to access our account (again the email address has changed).  I would be extremely grateful for any assistance and information you can provide in updating the account email on the backend.  

Hey folks,I am currently working on a formula to compare the current time against a timestamp that's populating into my table from a separate service.I am also attempting to create multiple columns that iterate on my formula by comparing NOW with DATEADD +5 "hours" to check if NOW is 5 hours since the time in the timestamp.Having some trouble figuring out what I'm doing wrong with this formula and hoping someone can point me in the right direction:  IF( DATETIME_FORMAT(NOW(), "MM/DD HH:SS") > DATETIME_FORMAT(DATEADD({Timestamp}, "MM/DD HH:SS"), +5, "hours", "MM/DD HH:SS"), "yes", "no")  

Hello! I am working with a formula that is computing a rate for each area that is being updated from a submissions tab; however, not every area has data yet, so Airtable assumes 0. This means that in the future records we get the output NaN as we are dividing by 0 at the moment. Is there a function or if statement that can be used to detect if there’s and NaN output, and if so, set it to 0? Thank you!

Hello!I am trying to create pie graph, that combines data from mutiple different fields and show them togetherFor example:I want to combine that data and show that Group 1 had 61% of the score and so on. In one graph is there a way to do this?

Hello, I have been trying to update a single select type field. I am using this example script from the official documentation : const table = base.getTable("Suivi des profils 🙋‍"); const field = table.getField("Client "); await field.updateOptionsAsync({ choices: [ ...field.options.choices, {name: 'My new choice'}, ], }); This script works using the scripting extension.I wanted to use this in automations, but of course, updateOptionsAsync() is only available for the scripting extension. The problem is that I need to watch for newly created records in another table and use a specific field value from this created record to add to the single select field.Is there a way to update a single select field using automations ?Or is there a way to automate a script from the script

Is there a way to update manually a "Last modified by" or "Last modified time" field?We use a field to check who was the last person to update an ID field. But we sometime have to bulk update these fields for cleaning or managing the database and the "last modified by" is now entirely set to the creator/admin who made the update.- Is there a way to update manually these fields?- Is there an existing extension for this? or a script ?- Maybe there is a way to "impersonate" a user in order to set the needed values to those fields? (I tried this with the interface functionnality to see interface as another user, it did not work)Thank you very much !

I am trying to make a very simply patch request using an HTTP module in Make.com. However, I'm getting this and can't work out why: URLhttps://api.airtable.com/v0/appzYqJSdNkXvYunc/2023/recV9bgS8TBB1msd7Request content{ "fields": { "PDF Requested": true }, "typecast": true } ​Request compressed contentfalseMethodpatchHeadersArray1CollectionNameAuthorizationValueBearer keyo

Hello! Has anyone has an issue with rich formatting before?I'm trying to put bullet points in a rich formatted long text field and every time I click out of the field this message comes up:An error has occurredSorry your base is out of sync with our servers. Please check your network connections.Refresh the page.Refreshing the page has yet to fix the issue.Any tips?

Hi, how can I choose which edits to view in record-level revision history? I'd like to exclude edits from API calls because it gets too busy.

Hi community,I have two table, the first one is a database synchronised with many other, fulfilled directly by stores themself and it is creating a product list. The second table is contact information about the stores.I would like to link phone, number and adress regarding the store concerned.In my screenshots, green circled data are synchronised, and the red circled one are thoose I want to import from the table "ENTREPRISE INFOS".So in "BDD ARTICLE" table, if Sync Source is "Magasin 1", I want to display information regarding "Magasin 1" in my "ENTREPRISE INFOS" table.I didn't find any way to do it, thanks a lot for your help 🙂

I'm having an issue with Maps Block authenticating my Google Maps API key.  It works fine if I make the key unrestricted, but adding the restriction to Airtable breaks/blocks the map block from reaching the API.  Per the Airtable dialog box I'm supposed to add this address to the permitted HTTP referrers: *.airtableblocks.com/*Is this still the correct address? In the Google Cloud Console do I do more than check "websites" and literally paste that in as the permitted website address?  I tried adding https://*.airtableblocks.com/* and that didn't work either.  I've attached a screenshot from Cloud Console.

Hi I am trying to create an automation where a record in one table (New Listing) is updated by submission and record creation in another table (Sold). Example: Record sits in New Listing and then a form is submitted in Sold, then a record is created in the Sold table. I want this to then update the status of the record in New Listing to Sold?Can this be done? Thanks