Ask the Community

Hi, community!Please, I need help to understand what happened with an automation that I messed up and was sending e-mails in an infinity looping even after it was deleted from the base.It was initially built with "At schedule time" trigger and had two steps: 1 - Find records matching one condition: Where field A contains Yes2 - Send an e-mail to the e-mail found in the previous stepAfter I tested, I realized that I actually needed to insert the Send an e-mail step inside a Repeating group. The problem is I forgot to update the data that should be used in this step, so it kept sending e-mails to everyone that matches the condition in the first step. I fixed that changing data to Current item data in all fields in the e-mail step but it didn't work and then, I deleted the automation and it still kept sending e-mails.Now, it seems to have stoped, but I'd like to understand what happened here so if something similar happens in the f

I have enabled Airtable's native password protection feature for my form created using the Interface Designer. When someone navigates to my form's URL, they need to enter the form password in order to access the form.How long can someone access the form after entering the form password? When testing on my computer and phone, I noticed that I can continue to access the form for about 24 hours after first submitting the form password without having to submit the form password again. After that time, I am prompted to reenter the form password. Does Airtable require the password to be resubmitted every 24 hours?

Is it possible to prefill a password for a form?Something like this: https://airtable.com/baseID/pag23482374823/form?prefill_password={password} This would be really helpful because sometimes I need to send a form with sensitive linked records to people who do not have base access.

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

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 th

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:  

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)

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 {expens

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 a

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.