Ask the Community

Hi.I have two Date files with Time Called Start and Ende.g.:Start=08.05.2024 09:54End= 08.05.2024 12:00in another filed I'd like to calculate this into hours rounded to full 15 minutes using:IF( AND({End}, {Start}),ROUND(DATETIME_DIFF({End}, {Start}, 'm') / 15) / 4) the result of this is 2 which is correct as I used "ROUND"But I'd actually like to ROUNDUP, so the result should be 2.25But when I change ROUND to ROUNDUP in the above formula, I just get #ERROR back Further down the road I'l like to convert the this into "working days" of 8 hours each So let's say I have two entries with 2 hours and 8 hours, that would sum up into 1,25 "working days" reason for this: I'm building a tracker of PS engagements. Customer purchases a fixed amount of days and engineers enter information about what work has been done. There can be multiple Tracker entries for a PS Project and I need to sum this up into "Working days" of 8 hours each any help here is highly appreciated&nbs

id like to format my "price" field as follow : 100€ not €100How ? 

I have been using Airtable and created a column in which I have added links to Twitter, Facebook, LinkedIn, and Instagram profiles. I manually added the follower count, but I want to know if it is possible to update the follower count automatically for these social media platforms in real-time. Can you please help me with this?

Hi everyone,An interesting Restriction / Bug I've found but unsure if anyone can help?I have a basic list view that lists Tasks, with associated Subtasks as drop downs by using the 'Levels' setup.With this basic, 2 level setup I now can't Group my Tasks by Status?  Anything I add in the 'Group' option on the right (no matter where I have selected on the window) only affects the Subtasks that are nested, not the parent TaskAny ideas?Thanks!

Hi, I have researched the forum but cant find the problem to my solution. Every time a record is updated in UseCases, I calculate a field call Environment_textual (example value would be "Negligible risk").I have another table called Environment_pics where I store pictures for each rating (e.g. there is a pic for "Negligible risk"). I want to create an automation which takes Environment_textual and copies it over to the linked field, so I can the picture in the UseCases list.I get an error for the last step.Should I copy the result in the linked field in UseCases or in the linked field of Environment_pics? For use cases it runs succesfully but the value is not inserted, for Environment_pics I get an error "The record does not exist"Please help. A gif would be me most welcome, or any description, link. Spent hours on this and is blocking me big time.Somewhat similar problem but didnt help me figure it out:https://community.airtable.com/t5/automations/a

Hey my Gmail automation appears to be set up correctly with a publicly hosted web image that should send in the body of the text. It works in the preview but when I send the email it doesn't show. Could anyone point out where I'm going wrong please? The subject and body of text pulls from my airtable and sends in the actual email, then I use (<img src="image web address">) to attach the image (This does not send). Does this need to be configured in a particular way to send via Gmail that I'm missing? Cheers! 

Can someone help me figuring out how I can copy all the options in a single select (my example has 5 options, but assume a have a sigle select with 1000 options), and paste it in another table, as a regular text field? i need this because I want to create a db with all those options, and use link record.. as this info is in many of my forms, and get updated regularly , thanks! 

Hi All,I'm having difficulty automating a task that I need for my database. Essentially what I'm trying to do is to have a default value in the "Link to Field" selection, which is then removed when another option is added. The data is currently pulled in from another table using a 'Link to Field' column, I currently have the automation working to add default option back when options are removed but having difficulty creating the script to remove the default option when a second option is added.Below is my current code, which pulls the current options from the cell and checks whether they are the same as the field being updated, which then passes those choices to an updateOptionsAsync, from which my understanding is the wrong function to be calling.Any help would be greatly appreciated!! let inputConfig = input.config();let currentRecord = (inputConfig.recordID);let table = base.getTable("Deals");let field = table.getField("Properties");let queryResult = await table.selectReco

I'm sitting with a client who needs have a massive library of materials that is put into subgroups depending on category. I thought the AI search could be a potential game changer, however they don't want to switch it on before they have an idea about cost.We've been trawling the Airtable AI and billing section, but so far haven't found where it says how much credits the search functionality takes. Does anyone know?

Hello everyone, does anyone know if it is possible to use the Gemini API Generative Language to create an automation in Airtable? I would like to use 1 column to receive data input from my users app and serve as a kind of prompt. And then use 2 more columns for output with AI responses.Additional notes:

Hello all!  I need some help please.  I can work spreadsheets all day long but database creations is not my forte, far from it.  I started using AT a few years ago to track my business whole goods by serial number.  Thankfully, someone helped me here and re-designed the mess I had created.  It has been working great so far, but I would like to change the way I enter the data.Currently, I just use a main grid and enter all the information, it then populates to combine all the same parts together.  From there I have managed (with some help) to create 3 other tables, one for each manufacturer so I know what is in stock. The reason I want to change the design is I am much more busier with the business transactions and I'd like to reduce the redundancy that I find the current design has.  When I set this up, it was basic and understandable to me. The main table currently has model, brand, part #, serial no., accessory, vend inv, inv date, cost, s

Hi, I wanted to provide a link to a separate site in the help text of a specific form field. Is there a way I can add links to that or is it all just plain text?

Hi everyone, I'm building a personell planning Module where you have your Project and you can assign workers to the project for certain time periods. The basic Idea/Tables behind is: 1. Projects: All info about the project. Start & end Date coming from "timeslots"2. Timeslots: Can be either a project or work term. Work terms are linked to projects. I then set up a timeline view and see my project and am able to plan out work terms beneath it (grouped by project, sub grouped by type). This is all nice and well. However there is one fundamental Problem: If I group by Project, sorting by date suddently does not have any effect anymore. Ideally I want to have the current projects at the top and the further down i go, the further they are in the future. But like this I have lots of projects inbetween that only start sometime in the future. Is there any way I can solve this? Weirdly enough it should be solved by sorting by date but once I group it,

Any tips on how to make React DevTools work when developing locally?

Probably a niche use case but wondering anyone can think of a way to make this happen.I'm trying to use airtable to organize some wire and cable take-off quantities and routing for a large scale construction project. The main entities (tables) are wire/cable, conduit, and pull/junction boxes. The boxes are like the nodes, the conduit link nodes together, and the wire runs through the conduit and boxes from an origin box to a terminal box. There may be many levels of branching. Possible that there is some spider-webbing as opposed to just straight branching but not positive yet (rare if so).I have the table setup so that there is a record of conduits, with an "origin" and "destination field each linking to the table of pullboxes. This link defines the end points, or nodes, of the conduit IE Conduit #1 goes from Pullbox A to Pullbox B. Conduit #2 goes from Pullbox A to Pullbox C, Conduit #3 goes from Pullbox B to Pullbox D, Conduit #4 goes from Pullbox D to Pullbox E, etc etc. Always goi

Hi all, I have the following issue:I have 3 different Interfaces: WorkTeamProduct RelatedEach with multiple Views. The "Team" Interface is more like team internal.So I want to share the "Work" and "Product Related" Interface with most of the company via a link. However, as soon as I select more than one Interface, the "Invite by link" option is gone. Is there a way to do it? A colleague with the free plan mentioned that he is able to share multiple Interfaces at the same time. We didn't figure out what is different though. Would be little bit annoying/confusing if everything has to click on 2 links. Single Interface selected: Multiple selected:  

Hi,I want to automate my work with emails to clients every 3 monthes.the problem is my languge is RTL (right to left).how can I send the clients emails that are RTL?with HTML it doesn't work since the variables doesn't work in HTML.

I have a CSV file delivered weekly with information about grant opportunities. I've been importing this file into Airtable, however, many of these grants include multiple submission deadlines throughout the year so I'm struggling to find the best way to be able to use the submission deadline as a true date field for sortability.The CSV file has a text-formatted column for dates. The cells also include "Submission: " before each date. I was planning on find/replacing out the "Submission: " text and then formatting the text as a date, but some of these cells actually contain multiple entries. For example:GrantDeadlineGrant 1Submission: November 15, 2024Grant 2Submission: September 01, 2024Submission: March 01, 2025Grant 3Submission: August 15, 2024Submission: January 01, 2025Submission: April 15, 2025Question 1: What is the best way to handle a record that has multiple "due dates"? Should I try to create a new Table and make each date its own linked record? Should I manually duplicate ea

Hi,I have a table called Launch Calander that I link records from other tables like Email task, Website tasks and Digital & Print tasks.The lookup fields for all the other records show fine in the Launch Calander except for Email.I've tried deleting the linked record for email and starting over by creating it again from within the Launch Calander, then creating Lookup Fields and making sure they are linked to the Email Linked Record. Yet, nothing shows up. 

 Hi,For a property management company, how should I go about creating the next quarterly report?I have organized a board for:AssetsFaultsClientsEvery quarter, I aim to send each client a separate email containing a report detailing:The income generated by their assets (income for each asset is recorded on the Assets board, and a client may have multiple assets)The expenses associated with each asset (expenses for each asset are recorded on the Assets board)The expenses related to faults that occurred during the quarter (these are recorded on the Faults board).Subsequently, I wish to display to the client the total income minus the total expenses.How can I provide this data to the client while ensuring that I do not share information pertaining to other clients?Thanks.

Hi community, I’m building up automation with Gmail sending records to the mail address of the person who filled out the form. I used the Rollup field to pull the email address from the other table. I’ve run 50+ times testing trigger and all the steps which showed no error, but it never succeeded while actually performing the automation after submitting the form. I’ve also tried to delete and rebuild automation for 3 times but still in vain. I also assured that every cell of mail is not empty. I attached some screenshots of the condition. Is there any suggestion to fix the problem? Much appreciated!

I am mapping out the content in an academic program with the following levels:Program ObjectivesCourse ObjectivesModule ObjectivesAssessmentsI have a separate table for each of these levels.Starting at the bottom, an assessment in one of the courses is connected up to one more Module Objectives. Each MO is linked up to one or more Course Objectives. Each CO is linked up to one or more Program Objectives.I'd like to visualize these connections. It seems the flowchart extension is what I need, except it only works with self-linked records. In other words, I would need to combine all 4 levels into a single table. This is problematic because I need the levels on separate Tables. I considered copying/pasting the primary fields and the fields that link each to the other level over into a new Table that I could use for flowchart purposes. I haven't tried it to make sure it would work yet, but even if it does, my next issue will be keeping redundant information up-to-date as this is a wor

Hello AT community, Can we embed Airtable interfaces (dashboards) to website or Notion for exemple ? Thanks

I've used Airtable for several years and have a workspace with approximately 80 bases.  Prior to one of the "upgrades", I had organized my bases in a way that was easy for me to find which base I was looking for and that made sense to me.  Now that the workspaces are sorted by opened by you, alpha, or last modified, it is very time consuming to find the particular base that I am looking for.  The "upgrade" may have been great for many people, but it was horrible for me.I have looked and can't seem to find a way to manually sort my bases so that they stick.  I suspect that this is no longer an option for me.Does anyone have an answer?I tried to contact support, but it has been several weeks and the only communication that I received from them was asking if I had received an answer yet.  Of course, I had not, because no one had answered. Thanks! 

I need to be able to export a airtable views from the mobile app. Do I have any options?-It doesn't appear that there is any functionality for this currently in the app- It doesn't appear possible with automations- There doesn't appear to be any extentions that do this- There are third party apps, but as a small charity we can't really justify paying for one for this use