Show and Tell

Something sooooo wierd is happening to me that is driving me crazyI am trying to compare a date with today. Easy task aparently. (anyway working on dates is never easy to me)Look what is going on:Two date fields createdDate 1 is TODAYDate 2, the date of a free class at my schoolNow i created two testing formulasAnd testing 2. Just substituting Date 1 field by today() So both formulas are supposed to give the same output, but....OMG!!! no idea about what is happening! Any help please! 

The new "Record Review" interface layout is very useful and simple to use, but on fullscreen mode components does not expand to occupy all available screen space. It´s also not possible to change "grid" or "timeline" components height.  

HelloI imported a excel doc where I prioritize items based on a 1-4 scale for sorting. I also use "Z" to sort items to the bottom that no longer need a priority. After I imported to airtable, its only letting me sort my priority column "First - Last" or "Last - First" which I am not familiar with. So i changed the "z" items to "999" thinking airtable might only recognize numbers. Didn't help. The "1" priority is still not sorting to the top.In short, I get that airtable wont sort as if it was a spreadsheet but i need to know how to label my prioities so they sort.Right now, I am using 1 - Ultra High2 - High3 - Medium4 - Low999 - Unavailable or ScreenedHelp?

Hello AT FamilyTable: Properties (is our base table with all of our info)Table: Mortgagehas all mortgage info pertaining to each property in Properties TableThe main statuses in this table is "Yes, No, Refinancing"Note: some properties in this table have had two mortgages, which means to two lenders at one point, which means two status, "Yes and No"Table: InsuranceI need ONLY the lenders from the "Yes" status in the Mortgage Table to be looked up in this tableThe problem I'm having is it's pulling the both lenders with "Yes and No" status.How do I make it only pull the Yes lenders?When I filter to show ONLY Yes, it doesn't show anything because the property may have a Yes and No status.

Hello Airtable communityI've been diligently working on a time-tracking solution in Airtable for a nonprofit organization. Inspired by a YouTube video from Dan Lehman, I aimed to craft a system where volunteers could easily log their hours during a program. The base setup was straightforward, but I've hit a roadblock when integrating custom buttons within the Airtable Interface.Base Setup:Table: "Time Logs".Fields: Volunteer full name, VITA site (with options: El pueblo and Quincie), Certifications (with options: Basica and Advanced), Time In, Time Out, and Duration.Functionality:I implemented two button fields:"Start Time Tracking": Populates the "Time In" field with the current time."End Time Tracking": Populates the "Time Out" field and calculates the duration.Both buttons are linked to custom scripts to automate the time-tracking process.Issue: Transitioning to the Airtable Interface to provide a streamlined experience, I've found a challenge. I added a List element to display reco

Access dynamic interface url tokens within automations!You can now access interface URLs! This allows you to guide users to specific interface views and specific records within those interfaces.Providing YOU the power to organize and restrict the data the end user sees.Learn how below - in under 4 minutes!

I built https://www.nocodechart.xyz/ to let you create and add interactive charts to your website with live data from Airtable. You will be able to create a chart, design and add it to your website within minutes.Start by connecting to Airtable as a data source, customize your chart by changing chart type and colors to match your website. Copy iframe and paste it on your website.If you need help, message me!

The "revision history" of records is great, but it has its limitations.  If you're using the free version of Airtable for example, you only get 2 weeks' worth of revision history.  It also logs absolutely every change made to a record by anyone, which can become difficult to sift through if your base is complicated and has multiple collabators.As a workaround for this, I've started using automations to log particular changes I want to monitor, by simply using the NOW() function as a datestamp that's pasted into a long text field each time the actions I want to log are taken.  The automation takes the contents of the {Change log} field and copies it back into itself each time along with the new datestamp and notes of actions taken.  So what you're left with is a running tally of certain actions within each field.Another advantage of this is that, because the change log is actually a field within a base, which the revision history is not, you can display it in an inte

Is there an easy way (like a shortcut) to navigate to the first column of the current row in a grid view?

Hi, Airtable community! I'm developing a custom solution for a small gynecology clinic in Barcelona but I don't understand very well Airtable's pricing. Hope you can help me out!In terms of users and permissions, I’ll need 5 editors and 6 commenters. I think it is covered in the free plan but If I want to upgrade to the plus plan to benefit from more records per table, how much I’ll need to pay?Let’s say I have a module called Patients where I have records about their personal info, visits, clinical history, etc. I’d like that user called receptionists to be able to record and modify patients' info but not able to change/modify module configuration. In that case, which plan I’ll need?Any help will be appreciated!

Hi Im trying to Compress multiple fields with one script, I tried searching for a solution but I haven't came across to anything.I was able to find one but i'm only able to compress one field but not multiple fields // Modify these to your own values.let tinyPngApiKey = 'xxxxxxxxxx';let airtableAttachmentSource = 'Instructor Sample Artwork #1';let airtableAttachmentDestination = 'Optimized Artwork 1';let airtableColumnToLog = 'Optimized Artwork 1';// Don't change these unless you know what you're doing.let table = base.getTable(cursor.activeTableId);let view = table.getView(cursor.activeViewId);let queryResult = await view.selectRecordsAsync();for (let record of queryResult.records) {let recordAttachmentUrl = record.getCellValue(airtableAttachmentSource)[0]['url'];console.log('Compressing ' + record.getCellValue(airtableColumnToLog)) let request = await remoteFetchAsync('https://api.tinify.com/shrink', {body: JSON.stringify({'source': {'url': recordAttachmentUrl}}),headers: {

Using Airtable and Zapier, I am trying to link uploaded photos in an email.For example, we are using Airtable as our backend system and once a job is complete we upload photos of the completed job, is there a way to link this attachment field to use in an outbound email?I assumed I could use this link in the Zapier / Email automation:  However this link doesn't work: Any help would be appreciated. Currently we have sent the files from AirTable to Google Drive and using the shared link from there, however Google Drive uploads all of AirTables attachments in a zip folder so it shares it as a zip.   

Hi everyone,I made a Trip Planner for tracking some of my trips a while ago. It helps keeping my trip and activities organized. I figured I would share this basic base version in case anyone would want a trip planner starter. Feel free to copy and update the base in any form.I also has a more comprehensive version allows me to do more thorough planning, reviewing and budgeting etc, since l love traveling a lot! It also comes with interfaces, which looks nice and handy. It's available here (https://plannerhq.gumroad.com/l/tripplanner) with more information 😁If you got any questions, reply or emailing me!Thanks!

You can now query Airtable with GraphQL! At StepZen we’ve built tools to create a GraphQL API out of an existing REST API (or database). This way you can take the REST API from Airtable and transform it into GraphQL. There are two ways to get a GraphQL API for Airtable, either with code or without writing any code. Without code: Visit StepZen GraphQL Studio and insert your API Key, Base id and Table name. With code: Install CLI (npm i -g stepzen) Run command to import a REST API stepzen import curl "https://api.airtable.com/v0/BASE_ID/TABLE" -H "Authorization: Bearer YOUR_API_KEY" Run stepzen start and the CLI will return the endpoint you can use to query Airtable with GraphQL. Watch a video recording with more instructions here Two Ways To Query Airtable With GraphQL - YouTube

I want to display the task to fix bugs and other tasks in kanban views for easily tracking and unite all the tasks: x-axis will be the type of our tasks, and y-axis will be the status of each tasks. However, it seems like Kanban view doesn't allow to setup with multi-selection so could you guys give me an idea to set up them on Kanban or Interface/Gantt chart to display all the tasks?

I have been working on an Airtable integration called TaskRobin to save emails to Airtable.With features such as saving email meta data such as sender, timestamp, attachments and more, you can easily create a fully automated email ticketing system based on your emails.If you regularly receive emails that are tasks and need to be acted on, then this is for you.So here's how:Connect your Airtable with TaskRobin with 3 simple stepsSetup auto-forward rules or manually forward your email tasks to TaskRobin's robot inbox. TaskRobin will automatically save all the email data to your AirtableManage and update the email tasks in Airtable. That's it!The best part is that you can integrate TaskRobin into existing tables you may have and customise the email meta data to be saved.TaskRobin can also create a contacts table that will automatically create and update contacts found in your saved emails for you. All email records are linked to the contacts records too!We ar

Hi.I know how to display items from two bases in the same calender.But I realize I do not know how to easily display items from two tables from the same base.That should be easy, isn't it?

Hi in the Authentication and authorization i try to generate Authorization code, access token And refresh token it could generate both  Authorization code, access token but whille generating refresh token it could show error as 400 how to resolve the issue 

Hello Airtable Community!I'm excited to share something I've been working on - a new Airtable extension called Ask Airy. This extension is designed to give you a more intuitive way to search and interact with your Airtable data with AI.Check it out on the extensions marketplace.Ask Airy augments your Airtable search capabilities with AI, enabling you to search for records using natural language.But Ask Airy is more than a search tool — it also serves as a data consultant. You can ask questions about your Airtable data, and it will find and analyze the most relevant records for your question, and respond just as a human data analyst would!Ask Airy can be especially useful for bases with lots of text data.To use Ask Airy, you'll need a license (free trial included) and an OpenAI API Key.I encourage you to give Ask Airy a try - I’m already working on implementing a more powerful version, and feedback from early adopters will be used to drive what comes next.Thanks for your support.

Hi all, I've just launched DocsAutomator v2, an all new & improved DocsAutomator version to make creating PDFs from Airtable data once again easier & more powerful. The following features are now added:- PDF preview: PDFs can now be previewed straight from the app which doesn't count as a created document on the user's documents quota.- View selection: You can now select views on linked tables for filtering & sorting.- Referencing by id instead of names: DocsAutomator now references Airtable fields by id, so their names can be changed without breaking things.For more, please check out the following video: https://youtu.be/kYtHSNJucPI or visit docsautomator.co and test things for yourself 🙂Of course feel free to reach out anytime!Best,Rupert  

To all Airtable employees, I kindly urge you to consider going back to your old homescreen design. The new homepage is terrible - it's confusing, disorganized, and requires too many clicks to access my workbases. The previous version was much simpler and easier to use. Please listen to your users and bring back the user-friendly interface we loved

Is anyone here a partner with Airtable? If so, what are the conditions for this and what do they pay the most attention to?

I am unable to find any 'Duplicate Base' option in my base dropdown (accessed by clicking the three dots). The only option available is 'Slack Notification.' What steps can I take to troubleshoot this issue?

Hello,I'm recording international transport orders in Airtable, which require an origin and destination location at the city level. I have linked tables with cities, states/provinces, and countries, just like the CRM template by AirTable. When using a form view directly on the base table, I just add the City and the picker will display the related states and countries.  I also created a form as an interface, but the city picker won't show other fields from the City table. Is there a way to show other data associated with the City when selecting it in an Interface form?

Hello, all,I just finished working on a task management Airtable base called Sort Stack. It features a prioritization algorithm, recurring tasks, notifications, a Google Calendar integration, automatic project creation, task dependency, support for multiple projects per task, and more. For more information, check out this Gumroad page.