Solved

Hi everyone,I desperately need help as this formula is driving me crazy! Basically the formula works except for Jan - Feb and March 25 and shows them as Q2 24 instead of Q$ 24. This is the fiscal breakdownQ1: april24,may24, juen24 ->  Fiscal year (e.g., for May 24, Q1 FY’24)Q2: July24, August24, September24 → Fiscal Year (e.g., for July 2024, Q2 FY'24)Q3: October24, November24, December24 → Fiscal Year (e.g., for October 2024, Q3 FY'24)Q4: January25, February25, March25 → Fiscal Year (e.g., for January 2025, Q4 FY'24) Here is the formula:"Q" & ROUNDUP(  (MOD(MONTH({Month}) - 4, 12) + 1) / 3,  0) & " FY'" & IF(  MONTH({Month}) >= 4,  DATETIME_FORMAT({Month}, 'YY'),  DATETIME_FORMAT(DATEADD({Month}, -1, 'year'), 'YY'))Thank you in advance!

I have two tables Properties list and Budget. In the Properties table, I have a user field that we can assign the property manager to that particular property and that manager is only able to view and edit the Budget(budget table) details belonging to the property.But in budget table has many records of multiple properties detail. But that particular property manager should be able to view and edit Budget details belonging to that property. The rest of the details can be visible or hidden but should not be editable.Is that possible?

I have conditional visibility set for 2 fields in my form. One is working correctly, and the other is not. I  need to know what I am missing on the one that is not working correctly.Here is the one that is working correctly as it is in the form and what the conditions are: Here is the one that is not working correctly, as the Clients Location Link is still showing up when it should just  be the Love is Blinds Location Link:   Any help would be appreciated. 

I have a select drop down  field with number rating from 1 to 10,  1 - 2 - 3 - 4 .. etc...  .   I want to filter all the records that have a rating bigger than, let's say 6, but there's no number operators (">", "<") for the select field.Is there a solution to this?thank you in advance.

Hi there, I'm trying to bring a value from a previous row into another row, matching on two conditions.For context, I am ultimately trying to compare the difference in revenue between two rows, submitted by the same company, in adjacent quarters.Does anybody know how this could be done? Thank you!

Hey Gang.I know there's probably multiple ways to do this but I'll ask.If there's an automation way of stripping/grabbing two(as there will always be two) linked records in a field and placing the first in the "first instructor) field(email type), and placing the second in the "second Intructor" field(also an email type).Obviously, I'd need to grab, each of those and place them in their respective field.Simple enough, right?Or if just placing a formula in a field to reflect those emails, that'd be fine too, I guess. thanks

Hi all! I am running a T-shirt business and currently am filling orders. I have embedded a form onto my website so that when customers want to place orders, their info goes straight into AirTable. My question is this: is there a way to save this info in a customized PDF or Word doc template, and send this back to my customers? Any help would be awesome! Thanks!

Hi All, I am trying to create a button that one clicked will launch a web page that uses an internal url (or external) as the prefix with a cell value as the suffix. For Example: https://trsau.reecenet.org/pos/other-stock-on-hand/products/12345 The first part (https://trsau.reecenet.org/pos/other-stock-on-hand/products/) will be common in the formula with (12345) being the part that changes. To achieve this i have been try to us the following formula: The issue is that once pressed the i get the following error in the address bar.

First post, so I am sorry if this is not clear as to what I am trying to do.  My goal is to have a formula in a field determine if 3 different fields are either blank or not blank.  Depending on whether they are blank or not return a message to that formula field outlining what is missing and required.   See picture below.  I have tried to nest IF functions using blank or not blank, but I keep getting errors.  I have also tried to use the AND and OR functions in combination with the IF function with no luck.   A formula would work best for us.   Any ideas would be greatly appreciatedthanks Bob 

Hi all,Hoping you can help me. Check spoiler tag for completely detailed explanation of my situation, just in case you can spy a base design issue that could easily be fixed: I have a table called "Products" and a table called "Definitions". I'm linking each product in my products table to the definitions table. The record in definitions is the classification/type of product, i.e., a wall mounted faucet. In the Definitions table there are internal instructions that our staff need to check off using rich text format before the product is considered ready. It would be instructions like "Wall mounted faucet is not located on an exterior wall".I'm using a Lookup in my Products table to retrieve these instructions and attach it to products based on the definition. Unfortunately when I use a lookup to retrieve these internal instructions field in the Products table, it loses all rich text format. Fair enough - as per this help article I get that this isn't supported right now:&nbsp

Very new to Airtable and having some fun with formulas.I have project records with a simple status field (Planned, In Progress, Completed) and some basic date fields.I created a formula that checks if the project is "On time" or "Overdue" based on the completed (planned or actually completed) date field vs today.I don't need this formula to calculate on Completed projects so i'm looking for a formula that sets the field to blank if status is Completed, but calculates if Planned or In Progress.Current checking formula:IF({Completed Date} < NOW(), "Overdue", IF(IS_SAME({Completed Date}, TODAY(), 'day'), "At Risk", "On Time"))

I couldn’t find any updated information about this topic on the community forum.Currently, I am developing some email automation workflows, and I am aware that occasional failures may happen due to unexpected errors.I would like to create a solution to recover the failed runs, but from what I’ve observed, I can only view the execution history by accessing the web page directly.I searched the documentation for any reference to an API or endpoint that allows retrieving the automation run history so I can filter and manage it according to my needs, but I couldn’t find any relevant information.

Hi Good Airtablers:We upgraded to Enterprise in part for the Salesforce and Jira integration, but it seems that all synced bases are read-only. Is there a setting that can enable changes in Airtable to be upserted into Salesforce?I feel like this feature was there when our AE demo-ed it to us.Can anyone from Airtable show me how to edit from Airtable into Salesforce? And what the current limitations are.

Hi there,It seems a simple thing but I can’t figure out what is wrong…I have sales table and another table for totals by category , I try to make an automation to update the total sum with the new sale I tried to use find records but it returns a list and no matter what I do it tells me I’m giving wrong inputs…if someone can help please 🙏 

Imagine that we create two records in a table:1. The first is created through a form submission, so many of its fields are filled in at (or near) the instant that the record is created.2. The second is created by using the "+" button on a grid view. The record itself is created, then fields are populated as the user fills them in.Is there a term/pair of terms used to describe the "completeness" of a record upon creation? As in, the record created in scenario 1 is said to be **insert word here**, while the record created in scenario 2 is **insert other word here**.I often find myself asking other users how records are created in their bases in order to determine what types of automations are appropriate (ie. The "When a record is created" trigger can only be relied upon when you know that the necessary fields are populated on the record's creation). What word or phrasing is usually used for this?I'm ideally looking for the academic term but I'd love to hear anything that everyone else u

I have a list to show the previous month orders and would like to total the number and currency fields. I do not see any way to show totals in a list on an Interface dashboard. Is this possible? 

Hey Airtable community! I'm new to Airtable and still learning all the ins and outs. I'd like to create a grid view (for my leadership) that pulls from multiple grids across different bases. Is this possible? If not, is there another way to think about solving for this use case? Appreciate the help!Sarah

Hi folks,I've got employees that submit their timecard for every Friday of the year, so roughly 52 records for each employee all with the same date interval between them (1/3/25, 1/10/25, etc.). Many employees forget to submit a timecard for several weeks out of the year, so I would like to create a view/interface where each employee can see the weeks for which they forgot. I imagine it would be something where AT would compare the weeks/dates they should have inputted versus what they actually did input, but only displaying the difference between them, i.e. the missing dates. Is this doable in AT?Many thanks in advance.

It would be nice to use a windows tablet to input records but the scroll bars appear to be locked in position, has anyone had this problem and is there a fix or a setting to alter, tablet is a Lenovo yoga 2 running Windows 10, Regards Andrew

Hi,I was wondering if it is possible to create an automation that uses Airtable's own notification system. We use the interfaces for working all the time and it would be nice if we could get a notification if a certain cell reaches the date of today.

I have a database for our retail stores. The main table's first column is a formula that combines the store's name and the store's number with a " – " in between. For example, "1234 – Joe's Discount Hardware".I need to import data from a report that only has store numbers. I know could use the CSV Import extension by setting it to merge with existing records and set the merge field to the store's number.However, where I really need it imported is into another table in this base. This is where my roadblock is: Since the linked store identifiers are "1234 – Joe's Discount Hardware" but the report's identifiers are "1234", is there a way for me to link them?I did try bringing in a lookup field that show's the linked store's store number. But it can't use the lookup field as an identifier. Then I thought I'd found an answer by making the table's first column be =storeNumber. However, when I tell the extension to merge with existing records using storeNumber as the merge fiel

This is a question that has been asked a few years ago but not sure if this has been revisited recently.I am using Airtable interfaces. I am on top level plan and prepared to pay to remove the Airtable branding. There is a simple reason why.Our portal goes out to our key stakeholders and partners. As soon as they see the Airtable logo they start to try and work out how we build the platform, then instead of seeing the great outcomes that we are delivering, they start to try and build their own or they deconstruct the environment. It is very disheartening when you have spent a month making a great interface, and the first and last thing the partner mentions is "Oh thats Airtable, can you show me how you did that I need to do that for that thing that I was going to get you to do for me . . . . . so I will now go try to make it myself, I mean, it's just Airtable"The solution shouldnt be to go use Softr/Noloco etc and  money for a front end tool, just to remove a logo. Anyon

I have a single select drop down field, and use an automation to copy that dropdown field into a linked record field anytime it is updated (see below). I have the system to clients can use the dropdown in forms, but I use the linked record in the backend for my own uses.There are actually two of these, one for Federal and one for State electorates. Each have their own single dropdown field, that automates over to their own linked record field. Both linked records link to the same table, but obviously different columns.However, in the table where the linked records resides that are multiple cases of records with the same name. For instance, there is a Federal electorate called Adelaide AND a state electorate called Adelaide. Each record has a number of other fields (such as state, level of government, etc) and I use the Group function, so that it's clear and easy to not get confused between the identical names.My problem is my automations (from above) cannot tell them apart. Frustrating

Hi,I am running network managing research participants for my organization. They have two options for signing up, which are in separate tables. One is the 'Full Sign Up', which is in my main participant table, where I am linking other information not related to the form. The other is a 'Sign Up Later' form, used when recruiting partipants who don't have time for the full form (fx in person at a conference). They sign up with their name and email and I have created an automation to send out a link with full form. I'd like to create an automation that sends out a reminder email those who have completed the 'Sign Up Later' form, but not completed the 'Full Sign Up' form, to do so. This means I need an automation that removes those who have completed the 'Full Sign Up' form, from the 'Sign Up Later' table, but I am unsure how to do that, since the tables are not linked.  Any help is appreciated 🙂

Hello AirTable Community!Hoping someone can help me with a solution here.  I have a conditional form that depending on the department you choose, you get different prompts - most of this works great.  Here's the problem:I have a Lookup field that provides instructions by the department that I would like to appear once someone selects the specific department.  i.e.: Person selects Finance request time - they get a block of text that talks about what finance needs and SLAs.I have tried doing this via a Lookup Field (apparently, you cannot use those in forms), and then I tried a really long formula, but I cannot use formulas in forms either.Looking for a native solution, not a 3rd party plug in because we would not be able to clear that with our IT team.