Solved

Hi. I'm struggling with a formula to include a blank attachment field as part of 3 AND conditions. I'm testing this in my base before I put the AND part into a make.com airtable trigger module.At the moment, I have this:  IF( AND( {Ind Doc}!=BLANK(), DATETIME_DIFF( NOW(),{Record Created}, "days" ) >13, DATETIME_DIFF( NOW(),{Record Created}, "days" ) <30), "YES", "NO" ) This works, but ignores the first parameter and returns "YES" even for records that have an attachment in {Ind Doc}(Sorry if syntax for the multi-line formula is incorrect, I'm only just starting to learn to write formulas like this)! 🙂 

Hi,I've got a scenario i'm trying to solve with the interfaces... To give you some background information: i'm working a a project which involves taking care of incoming documents: tag them with info like sender, assign them to the correct project and type of document (bill or letter), amount to pay, etcI created a table called "Document", a table called "Sender" and a table called "Project".The document table has a column "Sender", which refers to the linked table "Sender"The document table also has a column "Project", which refers to the linked table "Project"I created an interface which has a record view on the document table, which filters all "untagged" documents.When you click on a document from the record view... fill in the sender and the project... one should see a list of recent documents that have the same sender and project... in order to detect potential doubles (=same document sent twice). Is this doable with the current interface?So in short: I select a document, i

I have a Long Text column in my table with a lot of text, likely 20K plus pages. I used formulas to clean this text, removing undesirable characters, extra spaces, etc.  Is there any way to copy the contents of the Formula column back to the Long Text column, so that the Long Text column will ahve clean but editable data for future use? While I can copy and past some smaller data sets, when I tried to copy and paste this column, I get a 'too large' error.

Hi. Is there a way to change the size of this element? It has resizing handles but I can’t get them to do anything. Thanks.

Hi, I'm Planning to buy an enterprise plan, in some of cases i need to share my base to my clients which are paid for team plan, if i shared my base as an editor do i have to pay for them also.?Please confirm.   Thanks.Vinoth

We have a rather large table that needs to be updated/inserted with a datefield value from another table. This needs to be done only once.Table 1 is about 30K records.Table 2 is about 120 records.Table 1 (that needs to be updated) is linked to Table 2. I'm pretty sure there is a rather simple solution to this conundrum but I can't figure it out.

I’m trying to create a SWITCH formula checking for specific text within a field. For instance, if there is a field with a bunch of random numbers and then a name, I want to check for the name in that field, not match the entirety of the text in the field.

I'm super new to airtable and I've been searching for the answer to this and I can't seem to find what I am looking for- likely because I don't know the right terminology but I have a table in my base and I want the primary field to auto populate each new record with a number and the year the record was created so that if there are multiple years I can filter them easily later.I figure it's some sort of formula because I know how to make the field auto number, but I can't figure out the formula to do it. Thanks in advance Amy 

How can I ascertain how large (MB) my base is? Grazie!

Hi all,I'm trying to set up a form which has a dynamic appearance depending on the time of day/day of the week.During our working hours I'd like users to be able to submit details through the form in order to receive an urgent response from our clinic team.  Out of hours, I'd like to divert the user to emergency contact details and a link which allows them to book a routine appointment with our team.Any thought on how this could be achieved?Thanks in advance,Laurence

Hello,Apologies if this has already been posted somewhere, but I'm trying to create an automation that updates a linked record field without overriding the existing data. I have two tables:Table A - Contains document recordsTable B - Contains a list of role records I have a linked record field called "Role(s)" in Table A that I'm using to associate documents to their appropriate roles from Table B.I want to create an automation that automatically assigns certain records from Table B to the linked record field in Table A without overriding any existing data (only adding to it).Example: I link the "Inventory Associate" and "Production Associate" records to the Role(s) field. I want to automatically link their supervisory roles ("Inventory Supervisor" and "Production Supervisor") as well without affecting other data that may be present in that cell.I set up a test automation with the following triggers and actions: Trigger: When a record matches conditions: Role(s) is any o

Hi, I don't have much experience with API requests. I am trying to understand how it all works. I am currently using Node-RED (visual Node.js) to process the requests. I was able to complete a GET request and i'm now trying to do a PATCH request to update data in Airtable.I get the following error message when trying:type: "INVALID_REQUEST_MISSING_FIELDS"message: "Could not find field "fields" in the request body" Here is the schema in question:I am unsure where the API is expecting the request body.Here is my test JSON:{    "fields": {        "CCISF": 5,        "CORAMH": 5,        "RJCCQ": 5    },    "typecast": true} Do I have to include all fields present in the table or only those i wish to update with the PATCH request? Thank you.

I'm using my airtable to attached keywords images. I have one big keywords table with multiple categories of different keywords. Then i have multiple linked columns to the different categories. However some of the keywords overlap into different categories.So I thought I could rollup all my linked columns and do something like this:  ARRAYUNIQUE(ARRAYJOIN(ARRAYJOIN({RollUp1}) & IF({RollUp2}, ',' & ARRAYJOIN({RollUp2})) & IF({RollUp3}, ',' & ARRAYJOIN({RollUp3})))) However I still have duplicates of keywords in my final array. Does anyone know how I can join my rollups and then filter out all the duplicates? 

Hi Everyone,I am sure this is a common question, but I can't seem to find it... When staff join they have a 3 month/6month and 9 month review. They then have their Annual review (which is always 1 year after their 3 month review). They then have a mid term review and an annual review. My question is...Is there a script/formula that takes the last date entry in Person A's row and creates a date that is 6 months after it so I can then run an email automation 2 weeks prior to that date to remind Person A  their review is coming up. In my example below (DATE FORMAT IS EUROPEAN) As you can see Person B has been employed longer so they are further down the chain they have just had their Y2 annual review and so their Y2 mid term would be 6 months from then (ie 22/7/2024).Person A's however is still in Y1 and has just had their mid term so they are due their Annual review on 6/5/2024.So each row will be a different person who will have different dates as they will be at differen

Hello, we duplicated one table from a base to a new base and a field that originally contained images got converted into a text field that contains the file name of the pictures and a URL. Is there a way to do duplicate the table without this happening? 

Hello Everyone, I am trying to create an automation that sends draft social media posts for approval. The problem I am running in to is being able to reply to these actionable messages in Slack with text that will update an airtable field. So basically here is how the work flow goes. When a new post is created and is in draft it will send an actionable message to a slack channel with two buttons. The first button is "Approve" and the 2nd button is "comment". If the comment button is clicked I would like the slack user to be able to enter some text that will then update a field in airtable. I have been able to get the approve button to work but when the comment button is selected I do not get the option in slack to enter text. How can I solve this problem. I would appreciate your input. Thank You 

Should be a simple automation so I'm certain it's user error but I can't find my mistake.I have a date value. When that date value is updated I want a single-select record to automatically update to "Date Changed"Use case is to generate a weekly email via a separate automation that shows all rows that had a changed date in a given week.My error is "Received invalid inputs."Please let me know if you need more details/context and thank you in advance. 

I have set up an automation:Trigger> Google sheets: when a row is createdAction 1> find records where REF is [value from google sheet column with REF #s, which should match airtable REF values]Action 2> update recordAction 2 is giving me trouble. I have 2 fields I want to update (a checkbox and a currency field).When a row is created on the google sheet, for example with airtable REF #AB-0101 in the google sheets "airtable ref #" column, I want airtable to find record #AB-0101 and update that record's checkbox and currency field. I swear I had it working last week, but today's test failed due to "invalid inputs." I don't really understand how the "Record ID" part of the automation setup works for Action 2 (update record). I did blue plus sign > Use data from... find records step > ...... then I'm lost! I've been digging around trying to find an explanation for the different options here (Insert all records as list vs grid, vs Make a new list of...) but not

Do you accept VISA (which is technically not a cc) or only Mastercard and other pure credit cards?

Is it possible to automate the status of read-only interface collaborators? For example, when the status of a collaborator changes to 'inactive' in my base, I'd like to remove them as collaborators on all interfaces. When their status changes to 'active', I'd like to remove their access to Interface B but preserve their read-only access to Interface A. 

I need help with script (or other way?) to merge Multiple rows with same "User ID". These aren't duplicate rows. They have 2 fields in them that are different in each of the rows with the same User ID but need to be merged to one row. Essentially every 4 rows will have the same User ID that needs to be merged like this. Examples below.Example of what I have:User IDQuestionAnswerDaveDo you like CatsNoDaveDo you like DogsNoDaveDo you like Hamsters YesDaveDo you like MonkeysYesExample of what I Need:User IDQuestion 1Answer 1Question 2Answer 2Question 3Answer 3Question 4Answer 4DaveDo... Cats?NoDo…Dogs?NoDo…Hamsters?YesDo…Monkeys?Yes

I have a form that is letting people create Inventory Request Records, choosing Item Records they would like to check out from our inventory. We would like to have a way that will automatically prevent them from choosing an item that will be checked out during the dates they have selected.Using the filters and conditional options for these fields, I only see being able to toggle visibility for the results of the "check in date" and "return date". I would like to use the values from the questions asking for the dates to compare to the records in our "Items" grid so "Items" checked out will not be visible but I cannot find a way to do this. We are not able to use a 3rd party platform.Any guidance on maybe how to rework the fields to allow us to use the info from previous answers to help filter their selection? Is there any way to have formulas or more advanced coding in these forms?

I am struggling to add a holiday string in an existing worback formula that changes the date based on another field. I applied Workday successfully but cannot apply {Holiday String}&"" SWITCH({Channel Size},'Large Email', WORKDAY(DATEADD({Launch Date}, -16, 'days'), -1),'Medium Email', WORKDAY(DATEADD({Launch Date}, -12, 'days'), -1),'Small Email', WORKDAY(DATEADD({Launch Date}, -8, 'days'), -1))I found two posts about adding a holiday string from a lookup field {Holiday String}&"" and still cannot get it to work.https://community.airtable.com/t5/other-questions/referencing-holiday-string-in-a-formula/td-p/135086https://community.airtable.com/t5/product-operations/feature-request-workday-holiday-sets/td-p/144717 

We have a form our users fill out that requires selecting a few entries from a long list of items, which we've managed to clean up by storing items by organization name--each organization has its own multi-select field, and they're conditional upon that organization being selected, so the form works nicely on the front end.On the backend, we have a bit of a mess. There are nearly 100 organizations, and every one of them has a field. In order to easily collect the items that users are selecting, we have a formula field that concatenates every organization field. It's basically:{AA} & {BB} & {CC}which returns the selected values in whichever field.The problem is that the multiselect fields don't all behave the same with the concatenation. Sometimes they produce a comma and space between them. Sometimes they don't. My goal is to clean this up for our user facing team in our automated email notification to show which items they've selected in a nice, bulleted list.Any ideas?

Hello!I am looking for a formula that will update on a month basis to pull data for a meeting.I have a few dates I want to pull from - Target Start, Target Completion Date, and Dev start. I would like to label any records that have a date in the upcoming month (ex. March as our review is the last week in Feb) to be labeled as "Now." Then any content that has a date falling in the next 3-months to be labeled as "Near" and all remaining to be "Next". Any thoughts?? The date ranges for Now and Near could overlap, meaning it is being worked on over a longer period of time and should also reflect as Now.Thank you!!!!