Solved

Hi there. I am trying to write a formula ("Duration of Pending Repayment") that calculates how long an unpaid repayment is overdue.Essentially, it will be:If "Repayment Due Date" is not blankAnd "Repayment Received Date" is blankThen calculate Today-Repayment Due date. This part I got with DATETIME_DIFF(TODAY(),{Repayment Due Date},'days')I cannot figure out how to do the If/And with blanks, not blanks. Any ideas, wizards? 🤓 Thank you in advance!  PS - Here's how the formula currently reads:IF(AND(NOT({Repayment Due Date})),{Invoice Issue Date},DATETIME_DIFF(TODAY(),{Repayment Due Date},'days')) 

I am using fixed for my rescheduling logic for date dependencies in my project management base. The primary reason I am using fixed is I need to be able to create buffers between dependent tasks (i.e. tasks with predecessors). Let's say task A is request a copy of bill from provider and task B is review bill.  I know that task A takes minimal time so I set it to start today and give it a duration of 1 day. Task B is also pretty straightforward and takes one day so I also set its duration for one day BUT it takes up to 30 days to receive a copy of the bill and it's out of our control so I want task b to start 30 days after task A ends. In the timeline view addressing this is pretty simple. I just define a buffer value for the dependency of task a and b.The challenge I am having is that when creating a project using a record template I can add the task A and B along with making task A a predecessor to task B thus enabling automatic calculation of task B's start date b

Hi 🙂I am trying to set an automation that will update a specific field based on the information that is on another table. The field I want to update is called Relatorio as shown bellow.I want to bring a field from another table that has the same number as the fiel (Item LV) from this table.Here is the picture from the table I want to retrieve the content from.I want to compare the ITEM LV from the first table and compare it to the ITEM from the last table and update the field RELATORIO from the first table with the content found on RESSALVA from the second. So every time ITEM = ITEM LV it should the update.The first table should be completed with aaaa on the first line, ddddd on the second and eeee on the third line.I setup the automation like this but it finds no records.Tks for the help

I have an automation that once an attachment field is not empty, it creates a new record in a different base with that attachment and a few other fields.Is there a way, that if the attachment field has more than 1 file, it will create a new record for each one of those files?

It would be incredibly useful if the Slack integration could send a message to a person pulled from a field in a table.As it stands, when using the Slack integration in an automation you have to choose (hardcode) the person(s) or channel(s) you want to send the message to.Use case: I have a table that syncs issues from a ticketing system. Each record has an "assignee" field. When a new record enters a view I want a Slack message sent to the person in the assignee field.

I have a table with a date field, an I want to link these dates to another table, but group them by month. This is so I can create rollups for monthly financial figures. I have tried to create an automation to auto fill in another field, using the date as its source and then converting the format to mmmm yyyy, from the usual dd/mm/yy. I then linked this field to the other table, but now the automation does not update it even if it runs successfully.Can anyone help solve this issue?

Hi there,I think I already know the answer to this but thought that I should ask. Is there a way for a user who has filled out a public form to edit the data that they submitted in the past? For example. If I have a form that invites people to provide information about their product which they do, is there a way for me to allow them in the future to "Edit" that information later if the price of description of the product changes?Thanks in advance. S

Hi, I'm relatively new to Airtable - still enjoying learning how to build neat things with it!I've noticed that when I'm testing my Airtable forms, my browser doesn't pop up the usual menu of autofill options for things like my name, email, address, etc. as usual. Is Airtable blocking this somehow? Can I un-block that? It certainly makes testing slower but more importantly, autofill helps users accurately enter common information, saving them time and reducing typos and other common errors. Example screenshot attached - starting to type my name doesn't offer to fill out the rest like it does on just about every other form on the web 🙃I searched Google and this community before posting but found almost nothing mentioning this, but got a lot of unrelated things since "Autofill" is often discussed in relation to formulxs [sic] etc. Sorry if this has already been asked.Thanks!-Chris

Hello,I'm trying to build a form where my team can submit a PTO request.I set two date fields, one for date when they want to start their PTO and one for their return date.So I would like to set the return date field to be after the start date.Is there any way to disallow people from entering the same or earlier date as their return date than their start date? I don't really mind how it's done (ie. pop up message, greying out any dates on or prior to the start date on the calendar), but just a way so that people won't be able to proceed to submit their request unless they put a date after their start date as the return date.Any input would be appreciated. Thanks!

Hi,The Typeform extension in Airtable is repeatedly failing to connect (screenshots at the bottom of this post). I have written multiple emails to Airtable Support but the responses are vague and not very helpful so far.I want to create a Typeform that pulls data from certain fields in Airtable, and displays that data as options for certain selection-based questions in my form. This is a less popular use case than simply sending Typeform data to Airtable, which is the focus of most other threads in the Support portal, in this community, and other third-party forums.Can someone quickly help solve this / suggest the best way forward? I click Accept on this page: but keep landing on this page instead of seeing a successful connection. 

Hello, I am attempting to create a “email merge” document template using Airtable that allows me to: Use rich text formatting (bold, bullets, etc. for email formatting), and Use reference fields in the text (for example “Hello {First Name}, your User Name is {User Name} and your Password is {Password}.” If I try to do this in Page Designer, I can do #2, but not #1 that I know of. If I try to do this in a Long Text Field, I can do #1, but not #2 that I know of. Any ideas? Thanks, ML

Sorry for such a basic question but I'm having trouble and getting this figured out. We have an online educational community and I'm hoping Airtable will let me have a better view of our community and allow me to automate certain tasks.I have data in different Bases from different sources:LearnworldsSome automated data that I used a Zap to show new user registrations (New LW Users base)Some static data of enrolled users that I download on occasion (the new user registration Zap does not provide much information, but, gives me an idea of what new registrations there are and what needs to be manually imported) (LW Users Uploads base)StripeAutomated webhook through Make that pulls in new subscribers (Subscriptions (Stripe) base)Google Sheet BaseWe have an onboarding survey that collects information. Compliance with filling out the survey isn't perfect so I'm looking fwd to using an automation within Airtable to trigger a reminder email. (Onboarding Survey base).My challenge is to be able

Hi all,I have an automations question that I hope someone can help me with.My company provides a programming service for clients. As we process the information received, Airtable sends an automatic email to the client letting them know what information we have and what we still need.When record is updated, send email to client.This is fairly simple and works well, however, we have employees who work at night or over weekends and do not  want emails going out to clients at funny times. Setting up the automation to trigger at a schedule time does not work because then I do not have the option of formatting the email based on specific record conditions. I would love to be able to have something check if it's during regular work hours, if so send the email, and if not, wait until the next regular business day and then send the email.Any advice on how to implement this?

AirTable whipped me up an amazingly impressive starter app - tables and forms - from a description of my needs.   (Which blew me away.)  I'm now trying to tweak at it to make it do some basic things.   The application manages the inventory of a seed sharing scheme for a horticultural society.   As you can see, it's done something really sensible as regards the tables needed.  (I added the gallery view of the seed types list.) AirTable has also made a nice little request form. What I'd like to whip up, is a public interface which shows something like the Gallery view, where on each of the cards, there is a link to a request form. When the form pops up, it is autopopulated with details of the seed packet being requested.  So the person requesting a seed packet will not have to enter the info about that specific item, but can request simply by supplying their email address.   (I'm not, at the moment, at all  concerned w

I would like to update a date field in a record, with the last time the automation executed. Is this possible in an automation, in the Update Record Action?If you choose static, you have to enter the field manually. If you choose a dynamic value, you are only allowed to choose from an existing field or data.  

Hi everyone,I've been struggling with counting all records from table A in table, B. I've read multiple forum posts and watched videos, but something is still not working ... so I've come here to ask for any insights. My understanding is that  I need to put all records from Table A into a single linked field in Table B, and then use a Count field to count them.  So I set this up, like in the imageThen, I went to Automations and set up two steps: Step one: look for any records and table that are not empty. (Table A is called "Entries" in my base)Step Two: Add an "update record" where the "Table" is the Table B ("Metrics" for me), Record ID is of where I want all the linked records to show, and under "Fields" I added the linked field, and said to show a "List of Records"...This gives "received invalid inputs"... Ive tried all the variations of this I can think of, which all result in this error.... Can anyone advise me on the solution?  Also, I just wan

Good afternoon (UK). I’ve just signed up for a year of Pro. I am surveyor dealing with commercial property and much of work overlaps with that of a lawyer. I’m not new to database design, having been using Filemaker for years (but only in flat form, not relational). Currently I use Clio (law practice but I’m finding it slows me up) and a combination of Devonthink Pro 3 and Scrivener for my law library. I am planning on using AirTable for my law library and for task management (client contacts, etc, property info, etc. I have added a couple of templates to get a rough idea. I have 2 questions. Would it be better to have a separate base for my law library or does it matter if one base contains dozens of tables? Where a field is for a person’s name, is it better to have two fields, one for first name, the other for surname, or one field only. tia

Hi everyone (reposting to correct category)I've created seemingly simple Zapier automations (zap) to bring subscription data into Airtable by creating/updating records in a Base table. While Zapier indicates success sending data to Airtable, no data shows up in Airtable base and table. I've been troubleshooting without success, so seeks suggestions here. Any thoughts are welcome!Zapier is connected to Airtable. I know this because I have another zap that works well with no issues to send the same source data to a different Airtable table in the same base. Also, I've confirmed that Zapier is "on" as a third-party app in Airtable Integrations.I have paid subscriptions to both platforms. In Zapier, I have not reached my task or zap limits, so that's not the issue. In building the zap in Zapier, the appropriate Base, Table, and fields in Airtable are available to select. Zap History shows success every single time. I use the Find Record in Airtable action to first seek for existing re

So close to getting the whole base working the way I want I can see the light at the end. I think the final hold up is getting the "Find Records" step working properly.My automation triggers when a new record is created in "Trainings". The "Trainings" table has the following fields:Training Type (Single Linked Record to Another Table Called Training Types)Date (date field)Attendees (Multiple Linked Record to Another Table Called Employees)Expiration Period (Roll-Up from Training Type Table)Expiration Status (Formula Based on Date Field and Expiration Period Roll-Up)Expiration Date (Formula Based on Date Field and Expiration Period Roll-Up)The other table "Training Assignments" has the following fields:Employee (Single Linked Record To Employees)Training Type (Single Linked Record to Training Type)Assigned (Checkbox)Trainings (Single Linked Record to Training Type)Expiration Status (Look-Up To "Trainings" Table Based on "Trainings" Field Linked Record)Expiration Date (Look-Up To "T

Hi Airtable Community,I'm experiencing some challenges with RTL (Right-to-Left) text handling in my base, specifically when mixing Hebrew/Arabic with English content. I'd love to get some insights from the community on best practices and possible solutions.Current Issues:Text alignment becomes inconsistent when mixing RTL languages (Hebrew/Arabic) with EnglishThe reading flow is disrupted, making it uncomfortable to read and work with the dataThis affects both table views and interface elementsQuestions:Is there a way to set a default RTL alignment for specific fields or tables?Are there any known workarounds for handling mixed RTL/LTR content effectively?Does Airtable support RTL for automated emails and notifications?Use Case: I'm managing a project where we frequently need to input both Hebrew and English content. Currently, the mixed text appears jumbled and unclear, which impacts our team's efficiency and data readability.I've already tried:Using different field typesAdjusting fie

hi Airtable users!I have a question regarding custom selection of Lookup Field Values in Linked Records.I have 2 tables (A and B). I setup a Linked Field and then 2 lookup fields in table A. This pulls in a Group name Category names from B.Now in Table A, I'd like to manually choose a specific Categories (based on categories from the lookup field).  The steps I'm trying: I choose a group (in the linked field), and then choose categories manually... but I can only see how to show ALL categories in the lookup field OR categories that meet certain conditions. But this is not what I want... I want to choose only specific categories, which vary for each record. There are no conditions for this.How would I do this? Maybe there is a formula?  Please help!How can I choose specific values based on a lookup field?Thank you

Oh, this one has me stuck!I have a table of 'Individuals' with an email address and a unique ID on one table, and on another 'Audit' table, I have audit line items with the linked ID. I would like to use a checkbox of 'publish' in the Individual tab to trigger an email that sends a table of relevant data to the right individual. Right now, I have a trigger or 'when records match' showing a few conditions including publish. then Find Records, then Repeat for each List of records, with a send email and appropriate grid in the email. Problem is, I can't convince the automation to sort these, so person A only get their results ,and Person B get theirs. It's a mash of results, not getting split per individual. Because the list of individuals will continue to grow, I can't create a view per individual.Can anyone see what I am missing here?

Are the record's previous values available in the "when record is updated" trigger?  I'd like to be able to compare the previous values with the current values and act accordingly.  Does this require a code step instead?

Hello there smart folks! I am building a base for small film productions, and the industry has some odd practices I have to work around. One of those is tracking scenes on scripts in page length in fractions - specifically 8ths.For my personal tracking I have a column that just holds the size in the total number of 8ths (so instead of showing 1/8 page it is 1, 1 and 3/8 pages is 11) which I can then total into total number of 8ths.I now need to convert that back into pages in fraction form to display on one of my reports. So say I have 10 scenes over 5 3/8 pages (so my total is 43). How do I create that 5 3/8 to display?I hope this makes sense!

I have a column of Job Names and would like to indicate which Job Names are unique in that column. Has anyone successfully done this? Essentially I want to do the opposite of checking for duplicates and returning duplicate values in a new column.