Ask the Community

Hi, I have been trying to create a status field that uses a formula to indicate when a project is completed IF({% Complete}=100%,"complete"). The problem is whenever I type a number into the formula, it says "invalid formula". What am i doing wrong? I even have copied and pasted formulas from the airtable help page but the number portion is always red, as shown below. The red indicates (to me) that this is where the code is broken, but maybe im wrong? How can i fix it?   

Hi all!I want to express my gratitude to @Sho  for being extremely helpful in sharing a formula that significantly improved our reporting process. Now, I am seeking assistance for a new development phase.Currently, I am looking into two specific requirements:Formatting Unchecked Boxes: Is there a method to ensure that unchecked boxes consistently appear at the top of the Long Text, rich text formatted box?Standardizing Date Format: Is there a way to format the text following the checkboxes to consistently include the date in the format provided by Sho (YYYY/MM/DD)? I aim to establish a standardized approach to avoid inconsistencies among team members.To provide some context, I've attached a screenshot depicting the current layout. While I personally remember to place unchecked boxes at the top and include the date at the end of the sentence, not everyone follows this practice. Therefore, I am seeking a solution to automatically achieve the desired format, as illustrated in th

Hi all! I have a couple of survey forms in one table - one is for user group X, the other is for a different user group Y. Questions are similar, so I want responses in the same table but want to be able to filter view the records by each user group (eg by form that was used to generate the record). I thought that generating record IDs would indicate the source of which form (and therefore which user group) created the record, but it seems to be random. Is another way I can extract and filter which form generated which record? Thanks!!

When I am on Safari on the iPad I cannot see the “add element” button on in the interface editor.  I can see this button when I access the same interface but using Linux/Windows. 

Ideal Solution Goal: Every 4 hoursUpdate first record in "GolfNomadContent_StagingTable" where Status = NO, to Status = YESWhen Status changes to YES > Copies row to "GolfNomadContent_ProdTable" with YES Status--I understand the Automation tool only handles one record at a time. Using Zapier (as an alternative), I can also update/change records However, using Zapier, you're required to use a "RecordID" which appears to be unique to each record (therefore if I'm moving the record from the table, the next time the automation runs it will search for a "RecordID" that's no longer on the table. --Use Case: We are helping a local marketing company to scale their content creation by asking multiple people at the company to write content into a form, which we're aggregating into the "StagingTable" - Then, our marketing team wants to use Zapier to distribute the content data across their channels without duplicating content. As such, the solution idea was to set a STATUS

Hi all,I'm working on building a base for my team, and am having an issue with automating a copy-and-paste function.I have a formula which calculates the due date for tasks based on a set number of workdays from the start date. However, sometimes we need to edit due dates of individual tasks and don't want to edit the start date or the number of workdays—so, I need to figure out a way to copy the data in the due date formula field to another field where it can be edited. (I know I could just edit the workdays on each task, but for a variety of reasons I think that will be too complicated for my users/set up.) In order to copy-and-paste data to make it possible to edit dates, I have been using this automation:   But, for some reason, every time the automation runs it generates the date the day after the formula-created date. I have no idea why this is, and I have to assume there's a way to just directly copy this data. Here's what's being spit-out for me right now:Any tip

Hi,I believe it's been asked many times but I'd like to see if there's any update.I'm trying to count how many records I have within a day and add the sum number to automation emails.So the recipients can have the sum numbers from their emails every day. I've figured out some ways to do so:1) Summary barHowever, I can only have the sum in the summary bar, which can't be added to the automation emails. 2)Count fieldBut can only be applied to linked records. It can be done by linking the records to a new table, but that leads to 2 problems:1. requires linking the records manually2. requires creating new records in the new table manually every dayI need to make them fully automated.I wonder if there's a way to count all the records and put them into email automation, thank you. 

Hi, I have a simple automation.  The test works fine but it clicking the "on" button doesn't work. I've tried making new automations. They too have the same problem. Any advice? Thanks

Hi!     In my project plan I need to use hierarchical (or outline) numbering such:1  ~ 1.1 ~ 1.2 ~ 1.2.1 ~ 1.3 ~ 1.4 ~ 1.4.1 ~ etc. (print 1)     I've be doing this manually, but it would be great to have it being created automatically.     I got the formula below from the internet, but I stuck in the error showed in the print 2.     I also pasted, lower, the instructions I received.     Please, can someone drive me to a easy way to have such WBS numbering (Work Breakdown Structure)?     I thank you all in advance.The formula I'm using: "IF(LEN({Parent}) = 0, {Autonum} & ".", {Parent.Autonum} & "." & {Autonum})"Print 1: (the need)Print 2: (The error)Below the instructions I received:"Check your table structure:Ensure you have a linked record field (e.g., named {Parent}) that connects each subtask to its parent task.Verify the existence of an autonumber field (e.g., named

I've used hours to search for a solution via Airtable support pages, this community, Youtube (interesting video) and even ChatGPT, but I can't seem to find an out-of-the-box solution. Hopefully someone like you can help 🙂In an Airtable dashboard interface my use case is just a 5 seconds configuration, and I can select it in a view's summary bar. But unfortunately not in the data tables as part of a formula so it seems.The situation:I'm tracking expenses by importing transactions in a table {expenses} as separate recordsEach expense record has a {Date} fieldI'm categorizing each expense by selecting one category which is a linked field {Category} from the table {budget} with 73 category records.What I'd like to do is create a formula in the {budget} table which uses - among other data - the latest date of all records in the {expenses} table. Why? To calculate the difference of my spending per category, which is now based on today instead of the last transaction date of all

How do I delete an interface LAYOUT (i.e., when I click on a linked record on a page and it opens another page in the drawer with a customized LAYOUT). I have a whole bunch of excess layouts that I was experimenting with and it has made a mess of my ability to apply the right layout setting because the dropdown has tonnes of bad layout options that, and I like to delete them so that the don't get inadvertently applied across my interface. SCREENSHOT:https://www.screencast.com/t/SiKFWk30oXjA 

I want to remove the root domain from all of my URLs after a specific character. I want to remove the root of our URL (https://cotoncolorscompanywholesale.com) AND I want to remove /pages/ so that I am only left with the actual page name. Take these two URL's as an example: https://cotoncolorscompanywholesale.com/pages/faq     https://cotoncolorscompanywholesale.com/pages/for-poppy-campaign   I want them to be trimmed to read as: faq for-poppy-campaign Can you help me with this?

I have created two forms within my base. As of last week, the fields for both form, #1 and form #2 were visible in my base and form #1, however, this week I noticed that many of the fields from my form #1 were missing from both the form and the base. I assume another editor went in there and messed around. I was able to recover form #1 based off a previous version of form #1  and was able to recover the base that showed fields from both form #1 and form #2, but I was wondering if there was any way to restore the previous version of the base and form #1 without having to rebuild form #1 completely and lose all the information that has already been submitted to the form.Thanks in advance for your help! 

I am using a design tool (DBSchema) that can connect to most Databases in the industry, it typically uses a JDBC connection but has many others.  Does anyone know what drivers AIRtable uses and what the JDBC URL would look like?I could not find this in any documentation.Thanks in advance 

I am trying to find a solution to printing interface out tasks in a A4 portrait Layout, but currently if users print its several pages of mess. I have build a page layout in extension 'Page Designer' but unable to create this as a button as to allow the users viewing in interface to be able to print the details. Any Ideas how to print interface? Ideally would like it to be a button as I need it to be user friendly, who have only Interface viewer access only. 

I am creating an inventory management system for a warehouse team. I have a table that tracks the current inventory level and a linked table that operates as "transactions". So the "transactions" table keeps track of added and removed inventory. The inventory table shows the current inventory level for a product using a roll-up. I want to click on a button in the inventory table to open a form where the user can add or remove inventory. I want the product name field to be automatically selected based on which row the button was clicked. So pressing the "change inventory" button on the Product A row will open the form and have Product A selected in the name field.  I tried to figure out how to do this with formulas and automation, but I think that it might need to be done with scripting and I do not know any javascript. I hope that all makes sense.

I wrote a script in my automation to create a linking table of sorts that carries over records from two different tables. I have a field that is a formulated value in both source tables and in the target table I want that to be single-select. Is this possible? I cannot get the values to match up! The formulated value in source tables are based on dates, depending on what range the date falls in the output will be either one of 4 values: "Q1", "Q2", "Q3", or "Q4".Now when I log the output of the target field value of each record (there are hundreds) I get:"Q2, Q4, Q3, Q3, Q3, Q3, Q2, Q2, Q4, Q1, Q3, Q4, Q1, Q2, Q3, Q4, Q4, Q3, Q4, Q3, Q3, Q3, Q3, Q3, Q4, Q3, Q1, Q3, Q2, Q4, Q3, Q3, Q3, Q4, Q2, Q3, Q4, Q3, Q4, Q3, Q1, Q3, Q3, Q3, Q3, Q3, Q3, Q3, Q3, Q3, Q2, Q2, Q3, Q1, Q3, Q3, Q4, Q3, Q2, Q3, Q4, Q4, Q3, Q3, Q3, Q3, Q3, Q2, Q2, Q1, Q3, Q3, Q3, Q3, Q3, Q3, Q2, Q3, Q3, Q4, Q3, Q1, Q1, Q2, Q3, Q3, Q4, Q2, Q2, Q3, Q3, Q3, Q2, Q2, Q3, Q1, Q2, Q4, Q3, Q4"Can anyone help me understand why this

Hello,I'm created a registration form. I need the users to select their specific identification information. The information is stored in another base. I can create a link to the appropriate base field and this information will display in the second bases registration form. However, the information is displayed as a single row and it's a long row of information that gets cutoff in the form. I want to stack the information. I tried using \n creating a line break however, rtf data is not passed through a linked primary field (I can only link a primary field).Any suggestions for using one base that stores the following: State, award number, award titleand linking that information to another base as a selectable field in a form?

I duplicate my base, but find that my custom extensions are not in new base. How can I duplicate base with custom extension? Much appreciated

Hi all,I work for a marketing organization and we use airtable frequently. We have different bases for each job (graphic design, writing content, digital marketing content, and website content). We would like to find a way to move tasks/projects from base to base. (Ex. creating a postcard. Starts in Writing Content base and then move it to Graphic Design base once writing has been completed). Is there a way to move tasks from base to base, as well as notifying the correct person once it has moved? We would like to make things more efficient instead of sending emails to the appropriate person, letting them know that one part of the project has finished and they can start working on their part of the project.

Using airtable for project management, so far the set up etc is fine. One thing I am trying to set up is a script (can be put into a field as a button) that deletes the record that the button is in but also deletes all linked records in the sub task section. Therefore you are removing an entire project and sub task. At the moment the following naming conventions existProject (table) which links to Sub Task (table). When a sub task is added it links to the Project. Therefore the script must delete the Project and all linked records in a Sub Task section. Can anybody help with the script for this?

Hi There, Wondering if any one has noticed that the bar chart in interfaces by default is set to stack and there is no option to change it. Also there is no way to change the format of the data presented. If any one knows otherwise gthat would be great help.

Hi all!Here's a question... I'm making a basic task list in my base, I added a {Due Date} column with field type 'Date' and I have the time also showing in the same column. This will help me schedule tasks by date and time.Values in {Due Date} look like this '2/14/2024 5:00 pm'. I have another column {Date} with a simple formula DATETIME_FORMAT({Due Date}, 'MM/DD/YYYY') so I can get the date alone without the time.Heres the problem... Everytime I schedule a task pass 6:00 pm in the {Due Date} field, the {Date} value changes 1 day. Example:{Due Date} 2/14/2024 5:00 pm{Date} 2/14/2024{Due Date} 2/14/2024 6:00 pm{Date} 2/15/2024Help!

Hello!I am trying to set up a formula to when a checkbox in the field "Invoiced?" is checked, the "Status" field is then changed to "Invoiced". I am setting this up so that Zapier can (hopefully) check a box if a record is still there and override anything that is no longer in the Excel file. I am trying to create a formula that would do that and can't seem to figure it out. Any help is greatly appreciated! Thanks so much!

I have a table with several "linked to another record" fields and a multi-select list with one option for each linked field. I would like the list to be updated automatically based on the following logic:If the linked field is empty, the option related to that field shall not be selected in the multi-select.If the linked field is not empty, the option related to that field shall be selected in the multi-select.It looks quite easy to do with a script, but laborious with an automation because of the way automations update lists. They do not add or remove options based on what has changed but instead is asking me to tell what options shall be selected and which ones not. This forces me to start my removing all the previously selected options in the multi-select list, and then define the automation based on all the potential combinations of empty and non-empty linked fields. With a limit of 25 conditional actions in an automation, I can have up to 5 linked fields and related options in the