Ask the Community

I found this formula in the community. However I want to include a timestamp aswell. Since {date 1}, {date 2}, {date 3} may occur on the same day. I tried adding a format specifier but it wont work... The formula sets the time to a default 12:00am instead of the actual time that is showing on the datefields.IF( OR({Date 1}, {Date 2}, {Date 3}), DATETIME_PARSE( MAX( IF({Date 1}, VALUE(DATETIME_FORMAT({Date 1}, 'YYYYMMDD'))), IF({Date 2}, VALUE(DATETIME_FORMAT({Date 2}, 'YYYYMMDD'))), IF({Date 3}, VALUE(DATETIME_FORMAT({Date 3}, 'YYYYMMDD'))) ), 'YYYYMMDD' ) ) 

Hi everyone,I need to upload Adobe Acrobat Documents to my base.  They vary in size between 155-175 KB. '"This file is smaller than the allowed size of 1 B"Why am I getting this message?  Does anyone have a workaround?Thank you for your time and wisdom.  Much appreciated!S 

Hi, i'm landing with airtable and so far loving it, but I'm not sure if scripts works like other environments...I have a table record with a lot of blank values at ID column because is an exportation from another ddbb and it exports fields with multiple values as a record for each value. Usually in other apps I make a script for this that get the variable when exists the ID value and replicate it at the next empty records ID until it finds a non-empty value and updates the variable, and so on.I made the script and don't seems to have any fail but when executing is not doing anything (also no error text):// Define the table and select all records let table = base.getTable("Dashboard"); let query = await table.selectRecordsAsync(); let records = query.records; // Initialize the lastref variable let lastref = null; for (let record of records) { let currentDefaultCode = record.getCellValue("default_code"); let currentDefaultCodeNexus1 = record.getCellValue("def

Hi everyone, I have a situation and I am not sure what I should be focusing on first. There are a few levels where the problem may be coming from.I use Airtable in Chrome. As I move from cell to cell and view to view, I am often pressing a button on my Stream Deck that pastes small amounts of text for me. However, recently if I have expanded a long-text Airtable cell (so the whole cell pops up for easier reading), if I hit the button on my stream deck it closes the cell and does not paste it. This is not an issue, however, if I double-click within the cell and work on it without expanding it to the larger view. This is also not an issue with general copying/pasting with a keyboard. This issue comes and goes. I am trying to figure out where I should *start* with all this. Where do you think?- Chrome- Airtable- Stream Deck hardware- The app within Stream deck that "pastes"Hopefully the question makes sense. If you have any ideas on

How do I automate that a record gets created/populated when certain conditions are met. For example, When the value of Food is 'apple', and the Color is 'green', Attitude is 'happy'. Thanks for your help. 

Probably no way of doing this without an Automation right?I'd just like to have an image for my records based on a single select field. Essentially a Single Select field for images! I want to be able to assign a Logo for each record. Then on an interface, we can see Red Team or Blue Team logos distictively.My formula solution for this would be to host the image URLs somewhere and use a SWITCH() formula to find the URL. I don't know how to get it from the URL to the Attachment field.I can do this through automations but that seems over-engineered. Since I already have the teams in a single select field, all the data is there and I don't need to overcomplicate my base. The want for a logo is purely cosmetic haha.

Hi!     I successfully synced JIRA to AirTable, with all fields appearing in AirTable correctly.     But, there is an exception:     I have a "Cascading Field" in JIRA called "Story Type", each option in the first field opens a new list in the second field.     The first field appears correctly in AirTable, but the second one no. The print below shows it better.      Is there a way to make the second field appears in AirTable?Thank you all in advance.Best regards.Nelson.

I receive a due date and have to calculate backward to identify different milestones in our projects. What formula(s) do I need to use to make this work? I've attached a picture of what I'm trying to do.  Thanks in advance for the help!

I'm watching the "introduction to interface designer" webinar on-demand but in the recording there is no "related content" section for me to find the template/base used in the webinar. Tried searching for it as well, but couldn't find it anywhere. Anyone got a link to that base? It's called Demo: Design Project Tracker.

I have a base with information about students in a music program, including their birthdates (MM/DD/YYYY). I have a formula that calculates their age as of today:DATETIME_DIFF(TODAY(), {Birthdate}, 'years') and a formula that calculates the number of days to their next birthday:IF({Days from today} < 0, {Days from today} + 365, {Days from today}) I want to create a field that will tell me how old they will be on their next birthday. Is it as simple as adding 1 to the formula that calculates their age as of today? Thanks-Jen&nb

How can Sort list of Records by the order they were created in both. Would like to know how I can do them both ascending and descendingI also don't have any created time field I can't create that since I'm using the API And as far as I know it does not support creating formulas with the API So is there any other way to do this without using fields

I want to use AirTable so that users can login and access their test results and marks. You could call it a dashboard or customer portal site. So, one user’s results can’t be seen by another, this is why I need login or user accounts. I will be using AirTable forms (maybe Typeform) and AirTable sheets to enter the user’s test results. I have looked at various third party sites that build websites using AirTable data. However, I am not sure if they will be able to do what I need to do. I found one that looks like it could softr.io - but it is very expensive in my opinion. I know I could use a dedicated Dashboard or portal software like SuiteDash, but I am trying to automate as much as possible. I already have a SuiteDash account. I am happy to spend some money on a paid SaaS product. Does anyone have any suggestions or possible solutions? Thank you.

I’m really excited about the new interface designer features. Airtable has given us the tools to build functional apps without getting people too deep into the database side. Unfortunately I can’t quite fully embrace it yet – it seems like the interfaces don’t work at all on iPhones. Moreover the degradation is pretty un-graceful, users just get a message to login or use the app with little or no explanation of what went wrong and how they could fix it. Our folks – especially some key stakeholders – are on iPhones more than any other platform, making this an important thing to solve for here. Does anyone have any ideas about how to deal with this? Does anyone know what Airtable’s roadmap is? Would love to leverage the features if I can figure out how to manage this challenge.

Hi everyone. I am currently trying to create a checklist for a theatre production so we always remember to load everything in the van. However, although this works perfectly when I am on the computer version, I can tick the items as they are loaded, when I transfer to the mobile app it seems to become a laborious task because when I tick on the items, rather than check the item it takes me to the individual record. Does any one know if it is possible to just check and uncheck items in the mobile version? Thanks

Hello, I designed an interface with some nice stats and graphs only to discover that I can only share it with Airtable registered users. This is very annoying as I cannot ask clients or occasional collaborators, which often aren't even that tech-smart, to sign up to a dedicated service, even if it's free.Can you please allow us the possibility to share an interface in read-only mode with anyone who is provided with the link, just as google docs does?

I have a base for tracking orders. My base has the following tables, Customer, Products, Vendors, Orders, and Order items.This is a form I created in the order table. Look at the ‘add product’ section. I want to be able to add quantity for every product selected. Is this possible? If yes, how can I achieve that? 

Apologies for the confusing title. To not confuse things further, I'll minimise the story/context. I'm developing a crop planning and record keeping system for our farm.For this issue, I have 3 tables in question. 1) Crops (basic info about all our crops)2) Crop Plan (for planning)3) Field (what actually happens in the field, as plans are never followed 100%).More than one Crop is added to the crop plan via a linked record. An automation creates a record for each crop with a "planned" status in Field. The planning info and dates are dynamically updated between tables. So there are two linked records in the Crop Plan table - Crop and Field. The Field table also have a linked record to Crops. Th

Hi everyone,I have an automation that runs a script which sends a recordID to a Make webhook.Every now and then the automation fails because Airtable sets the script execution limit to 30 seconds. That makes me think that the problem is because of Make, in that the processing in Make takes longer so in return Airtable exceeds the execution time.Has anyone else experienced this issue? Is there a way for us to resolve this or perhaps a workaround?Here's my simple script: let inputConfig = input.config(); let webhook = 'https://hook.us1.make.com/jflrewqrewmnmnnqsdfsqsgtewvs' let queryParams = `/?record=${inputConfig.record}` fetch(`${webhook}${queryParams}`); 

In Airtable, a normal one-to-many relationship between two tables is bi-directional. When I create a link-to-record field in the parent table, Airtable automatically creates a mirroring link-to-record field in the child table. But if I create a link-to-record field that links to the same table – a self-join – that mirroring field does not get created. I was trying (as an experiment) to create a one-table to-do list, but I wanted a task to be able to have sub-tasks. So I defined the link-to-record field linking the Tasks table to itself, and called that field (that relationship) “Subtasks”. I created a task like “Prepare for vacation” and then added subtasks to it by clicking into the “Subtasks” column’s + button. And then Prepare for vacation [Subtasks: Get gas in car, Pack, File vacation form…] Get gas in car Pack File vacation form at post office etc. That works fine. But now what I’d like to

What’s the best way for someone to use my base? Lots of people will need to use it and add/edit records but they should not see each other’s information. They are individuals and not in the same company or organization. Can they copy my base and then use it freely? What is the best way to share so they’ll have the base to be able to add, edit, update and delete records?

When using the get request to get list of all the records is there anyway we can get list of all the records but the data only returns specific fields?

I have tried to URL encode my URL. In Power Automate Desktop The URL value is presently evaluated as:https://api.airtable.com/v0/appKJvw9LuKiqGcRt/tbl7MUhoqb9r5hk6V?filterByFormula={Root}=Can't Process: Missing Acct #where Root is the name of a field.In Power Automate Desktop, I am am getting an invalid filter by formula error.Am I missing quotation marks?

I'm building a CRM for my friend running a coaching business. There are two tables I would like to surface at the same time in a single interface "Sessions" & "Client"I want to create a user friendly view where she can see today's sessions - she can take notes etc for each session, and also have relevant client details up. (I've done a little mockup to explain)I know I can use Lookup fields to surface this information, but is there a cleaner way so I can simply open the Client details when a Session is selected (I'm using Record View but there might be another option)Any advice appreciated! 🤗

Hi all,Currently, I'm using a free plan, I have ownership of the account and have around 11 workspaces. Someone else invited a user to join and now he is a collaborator. I'm traying to change is access to Owner but it doesn't appear as an option anywere. I have tried :- share the base- create new workspace , trasfer all bases there and invite  Could you please help and advice? As mentioned I have quite a lot workspaces to would want the easiest way. Thank you. 

I am trying out the new Record Template feature, and I'm struggling when I want to create a same-table linekd record. I have a field that is a linked field to the same table. It gives me the below option to "choose templates" with which to populate this field:However, when I open this up, even though I have another template within this same table, I'm given no options for my template selection:You can see two templates clearly visible behind the dropdown menu; one is the template I'm currently editing, the other is the template I would like to select from the dropdown, but which isn't visible. Is this a bug, or is there some feature I'm missing in being able to select a record template for same-table linked records?