Other Questions

Hi, struggling with a formula for converting a currency field into minor units.Example: Formula field adding two currency values (£50.45 & £40.20) gives value £90.65. I need a formula that returns this value as 9065 - but I cannot work it out.In Excel it would be a simply TRUNC, but Airtable doesn't seem to have this feature. I'm amazed this question hasn't been asked before, but cannot find it anywhere!

This morning I refreshed a base and I have been surprised that the UI has been changed. The base colors are a bit different and the text for lighter elements has been changed from white to black.I have been using Airtable every day for a couple of years. The new enhancements in colors are making my eyes hurt. Am I the only one with this problem and can it be solved somehow?

My bases and views were working just fine until a few hours ago.  Now they get stuck saving and timeout with "An error has occurred" message.  None of the work done isn't saved.I've messaged enterprise support but haven't received any feedback.

I am trying to add a time only field to my form. It seems that I can only add date and time. Is there a way to just add a time field to my form?

Hello Airtable community I have a formula field which show date as month name only: DATETIME_FORMAT({DELIVERY DATE}, “MMMM”) I wanted to use this field to group each month’s records. Unfortunately, the sort function does not sort chronologically as it should for a date, but rather alphabetically. How can I force a chronological sort? Thanks in advance Sally

Hello. I have found several posts that deal with this issue but it doesn't seem to work for me. Problem: I have a form that I want prefilled, but for columns pulling in data from linked columns, it will only pull in the first data entry even if there are multiple selections ("Assigend to" column with multiple people selected from a linked "Name" field on the "Persons" sheet.Suggested Solution: Was to created a Roll up column that would join the linked values and then get pulled in to the prefill easier. https://community.airtable.com/t5/formulas/prefill-form-with-multiple-linked-records/td-p/26213Here is my URL Formula on button that links to form (Assigned%20to is the linked column in question):Here is the formula in my roll up column "Assigned_to_Rollup". This is the prefill value for Assigned to.Actual behavior: In my form, only the first name gets pulled in, though.In the base, there are 3 names assigned that are joined in the rollup column. The prefill doesn't seem to pu

Why is it that GIFs uploaded from GIPHY work well as previews. But screen recordings when converted into gifs do not work ?

Hey Airtable community managersI'm sure it can't of escaped your attention that since the community relaunch, engagement here has really droppedThis is a fair issue for those of us who rely on support to get things doneCan this be addressed somehow? If not, I fear this place will become less visited, and the value of Airtable will decrease with it, and your investment in this new forum be wasted 😞

Hi, I'm trying to import an excel into an existing table in my base. I have a couple on linked records fields, None of them are filled after the import process. I need to copy and paste the data.Is it a problem of excel import or am i missing anything?thanks

Hi all, I am trying to allow a user to click a button on a row within an interface to quickly delete that record. I have successfully created a script using online help to delete a row from the base view.  let tableId = cursor.activeTableId;let table = base.getTable(tableId);let record = await input.recordAsync('Select a record to use', table);if (record) {   await table.deleteRecordAsync(record);} else {    console.log('No record was selected');} This has worked perfectly in the base view, I tested it and the buttons show active.  However, I cannot get it to work in the interface view (buttons show grayed out). Does anyone know how I can get it to work on the interface view? 

So im trying to upload videos to youtube via an airtable database. Currently my application sends video files to a database in airtable and I want to build a script that sends the attachment to a specific URL. Im having trouble figuring out the script to query the URL and then how do I format it correctly so the PUT call will accept it. Ive provided a screenshot of what my simple database looks like. I need to have the attachment in the "Videos" field be sent in the "<file contents here>" portion of the follow script: var myHeaders = new Headers();myHeaders.append("Content-Type", "video/mp4");var file = "<file contents here>";var requestOptions = {  method: 'PUT',  headers: myHeaders,  body: file,  redirect: 'follow'};fetch("https://www.googleapis.com/upload/youtube/v3/videos", requestOptions)  .then(response&nb

Help! For some reason, my tables have disappeared on my iPad. They are still in my account on my PC. What do I do to get them back? Thanks!

Hi everyone,I have an air table form where my employees are submitting their leave requests, meaning multiple entries for the same employee with different dates. I would like to create a summary of the total number of leave taken by each employee but I'm having a hard time doing it. Is there anyone who can help guide me on the best way to calculate the leaves by employee? Thank you! 

Not sure if I selected location.I have a table for our help deck tickets. A user will submit a ticket when they need something. So there will be an email tied to the user. The fill out a form and then I recieve a notification. I am the only person with access to the Airtable for clarification. I want each record to have a button that I can click and it will send an email to the user stating it has been completed.The thing with this is that I don't always need for this email to be sent. Especially if I have to go an see that person. If they need something updated or another action where I don't see them I want to let them know that the action has been completed.The automated email will not be sufficient enough and I am not sure if I can use the scripting app to complete this issue.  

So, I am not sure if this is the correct location. I am also VERY new to airtable. I have taught myself to code in other languages, but I am by no means proficient in javascript.I am trying to build an extension that will do the following:read the value of a single cell (one record) on one tableupdate the values of specific fields (all records) on another tableRight now, I am having profound trouble getting started in defining a variable with that cell's value. I have poured through the airtable help and cannot find instructions on how to go about creating this variable. Below is the code that I am starting with (and getting constant errors).  import { initializeBlock, useBase, useRecords, } from '@airtable/blocks/ui'; import React from 'react'; function TodoExtension() { const base = useBase(); const table = base.getTableByName('PropertyDetails'); const records = useRecords(table); const tasks = records.map(record => { return <Task k

Hi, I recently applied to airtable startup program with the hope to get some credits for our airtable account. But I received an email from airtable said that I have received credit and they can’t issue me more. However, I’ve never received anything from airtable other than this email said I have received credit, which I didn’t… It is a bit confusing :confused: :confused: :confounded: . But that email is no-reply… so I ask the question here. Also, there is 0 credit in my account and never received any credit from anywhere else either (screenshot attached) I hope to get some help here… Thanks for reading.

When a base is integrated with google drive, are the data/attachments stored by Airtable, or are they stored by google? I’m making a base that needs to have a good deal of photo and video, and I worry about hitting storage limits (not enough to warrant getting an enterprise plan, currently on pro). If the files are stored on Airtable, does anyone know of an elegant way to do something similar (store base contents externally, but access via airtable)?

Since yesterday's UI update, when selecting a date, "Today" is no longer highlighted. It used to be and this allowed the user to quickly be aware of today's date, instead of having to take the time to check today's date, orient themselves within the calendar and then select their date based on today. There are a TON of use cases where this is important and there is no reason why it shouldn't be there. I hope this was an oversight with the new UI that will be quickly fixed and not an intentional decision. Obviously the highlight should be something less vibrant than the actual selected date (just like before). 

Hi everyone,I would like to be able to find all occurrences of a URL in a base, regardless of its substitution text.Allow me to explain our issue:We use an Airtable base to automatically publish content on a website. This content contains rich text formatting for SEO purposes, including links to pages from and to our website.Frequently, the URL of these links changes. So, we need to find all occurrences of a URL in the base, regardless of its substitution text, in order tu update the URL.We did not find a way to do that. Is there a way to achieve that, or do you have a solution to suggest?Thank you very much,Elisa

Hi,I am new to Airtable, but hopefully it makes sense what I am trying to achieve. I am creating a product database that will include product name and it´s ingredients. I want to be able to tell if a product is vegan friendly, not vegan, or unknown based on the ingredient status.For that, I created a separate table that stores ingredient names as a key and their status (vegan friendly, not vegan, or unknown). Almost each ingredients have synonyms that have to be included, but the synonyms should be treated the same way as the main ingredient (as for the status). So I created another table that stores synonym name as a key and their respective ingredient as a foreign key. Back at the Product table, I want to be able to add product ingredients and for Airtable to check the Ingredient list and Synonym list and assign the status for the product (non vegan - if there is at least one non vegan ingredient, vegan if there are no non vegan or unknown ingredients and unknow - if there

Hi All,I've spent quite a lot of time trawling through the forums trying to find an answer to this questions but can't seem to find anything that can work for me (i've got a horrible feeling that what I'm trying to do is not possible!)So, I currently have two tables.1. Project - This table pulls in from an Outlook calendar when all of our projects are stored. I then use various filters to pull up only the jobs assigned to me.2. Tasks - This table lists 14 todos, which are the same for every project. Each task has a deadline that calculates based upon the date of the project or the date of a site visit (for example, the Risk Assessment is due 2 weeks before the event and each event has a different start date).I'd like to find a way of assigning all of the tasks to each project as they come in, so I can see their workflows on a gantt and then tick them off as their completed. The assignment of tasks doesnt need to be automatic, but quite straightforward (filling the cell with the ids of

Hello Airtable community,I have had a working automation on Make, that started throwing errors:I’m using Make, Airtable and Gmail to send out low volume notifications.In Airtable, the email recipients are stored in a rollup array.I cannot get Make’s Gmail module to send one email to multiple to/recipients.What I tried so far:Turn the To field’s mapping on/offSwitch between array and textUse split/join with comma seperator on MakeHas anyone else struggled with this?

HelloI have a 20Mb attachment (so not huge) which refuses to upload.  It gets to 10Mb and just freezes.Any reason for this?  The attachment opens fine in my Mac and 20Mb is hardly big. Any help much appreciatedAndrew

I have a table with multiple tabs that delineate project categories (I’m in Marketing so eblasts, social, blogs, etc.) and each of the items has an “owner” field with a collaborator assigned. Is there anyway to create a view or additional table where I could log in and see all the projects I’m working across all those tabs? I know within one tab I can filter for things assigned to me but I’d love to see everything I’m working on easily in one place

Hi. I want to use features like record coloring and manage fields, that are in the Pro plan. Others also use my tables, but I'm the one who would use these feature. Can other users see the result of my changes if I'm the only one with Pro plan?