Solved

Does Airtable have a way to create several new records based on the number of entries in a field? For instance: We have a request table that people can fill out a form to request being added to articles. They can request being added to multiple articles via a link to our overall articles list. These requests go into a request log, and then go to an updates log that tracks the changes to each article. The request log has an automation that creates new update records when the request is approved - but I can't seem to figure out how to have it create multiple update records if multiple articles are selected on the form. Right now, it's only creating the first update record from the request. 

I've used Zapier on and off for the last couple of years for small purposes. This week I used it for something important, and I'm wondering if the approach I took is the best way to solve the problem.I have a list of people (about 120) that I needed to send and email to. The email contains a link to an Airtable form that I want them to fill out. I defined a date-time modified field in Airtable that I used to trigger the zap in Zapier. The zap then connected to my client's Google Workspace/Gmail account to send the emails out. I was a little worried about how well Zapier would perform, so I triggered smaller batches of records, about 30 at a time. In the end, it worked fine. We had to do a follow-up email, and I used the same process, just with a different body content for the message.I didn't ask Zapier to do anything other than connect (record by record) to my client's Gmail account and send each message. After each batch went out, I marked those records as "sent" by hand (easy in Air

I'm trying to build a formula that will look up a currency value from a record, determine whether it is between two ranges of currency, and then enters a percentage (the federal poverty level) in a new column. I'm getting errors in the formula below. Any ideas about what I'm doing wrong? IF(  {yearly income} < 22763,    "125%",    IF(AND(      {yearly income} > 22763, < 27315),        "150%",        IF(AND({yearly income} > 27315, < 36420),           "200",          IF({yearly income} > 36420,             "Over 200%,      &nbs

Hi All,Hope someone can help!In our base we have multiple Proposals (in one table) linked to each single Sales Opportunity (in another table).I would like the proposal's naming convention to be "{Sales Opportunity} - Proposal 1", with any further Proposals linked to the same Sales Opp named Proposal 2, 3, etc. (ie not using an Autonumber field that simply counts all records in a table). Ideally the number will not change if an earlier Proposal is deleted (but not the end of the world if so).Is anyone aware of a way to do this besides manually?Many thanks!

Hi,In our base we have multiple Proposals in one table against each linked Sales Opportunity in another table. One Proposal will be the Primary Proposal and any others will be Secondary. This is done by selecting Primary or Secondary as a single select.If a Secondary Proposal is changed to Primary, I'd like any other Proposals linked to this Opportunity to automatically be changed to Secondary, to avoid there being multiple Primaries.Is there a way to automate this?Many thanks

Hello, I'm following this tutorial RASA - Custom submit action to get a chatbot to create a new record in a table. But my 'submit' action returns the following error: Exception occurred in one of response middleware handlers Traceback (most recent call last): File "C:\Users\user\Documents\rasa-dev-tutorial\actions\actions.py", line 54, in create_newsletter_record response.raise_for_status() File "c:\users\user\documents\rasa-dev-tutorial\venv-rasa-devto\lib\site-packages\requests\models.py", line 943, in raise_for_status raise HTTPError(http_error_msg, response=self) requests.exceptions.HTTPError: 422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/<baseID>/<tableId> Could this be the cause?During handling of the above exception, another exception occurred: ... File "c:\users\user\documents\rasa-dev-tutorial\venv-rasa-devto\lib\site-packages\sanic_cors\core.py", line 250, in set_cors_headers if resp.headers

Hi,I have an airtable database that captures information from a tally form.One of the fields in the database is date created which is a formula and is the date when the form was filled in.Anyone can fill the form and I want to capture the time zone of who is filling in the form.Can airtable capture the time zone (of the person filling the form) together with the date and time of when the form was filled?I want to sent email reminders with automations based on the timezone of the specific user and creating different automations that work well with the different timezones will not work in my case.Thanks  

Hello there. I've hit a brick wall with an automation I'm trying to build. I was hoping to use an interface button to identify all records in a table with an unchecked box within a particular field and then check all of those boxes. I have created an automation where the trigger will be the button, and have then added the "Find Records" action where the condition is all records with an unchecked box. That part runs fine in testing. It all falls apart when I try to update records using the list of Airtable record IDs generated by the previous step and then ask the automation to check the relevant field box of all matching records. Can anyone assist please? 

I'm working with a fixed asset inventory base with close to 6000 records.  One of the issues that I'm having is the slow record fetching after scanning a barcode.  My primary field is a formula field that pulls from the barcode field.  I have a view that only shows a minimum of fields that I need to update the record as last seen at location on what date.  When I select the current date to show when I last saw this record it lags.  I find that if I push the record up with a finger gesture on my iPad it seems to update quicker, but not always.  I've tried creating different views by sorting the barcode field to see if that would help the indexing of the field for faster record fetching, it hasn't.Anything ideas on what to try next?  My attachments are already over 20g and I'm less than half way done with the annual inventory.All the Best!Pablo

I've built a task list table, and have some recurring tasks that comes with sub tasks in another table that are linked.I am hoping that when my Task is completed, airtable will create the exact same task, except to change the dead line based a formula field, and link up to a new set of sub tasks also created once this main task is done.I am doing this because I want to keep record of when the records were completed, using the last modified date field.Is this possible? 

Hi all...I'm sure this has been asked before so apologies for asking again. I have searched but any article I think might give me the guidance I need ends up getting confusing...possibly due to my lack of understanding but I think at this stage, my best option is to ask myself.I've created a purchase order system and it's all working fine except for one thing. For the purchase order number, I want it to be "Year-Cost Centre-Number" with the number component being a sequential count of previous orders for that same cost centre. That sequential count is where I'm running into bother - so far all I've managed to achieve is a sequential count of all purchase orders which works, but it's not my ideal set up. My base structure is:Purchase Requests table - this is the main table and is meant to manage the whole purchase order processCost Centres - table of all cost centres, linked back to the Purchase Requests tablePurchasers - table of anyone with permission to request purchases (not re

I have an email automation running every day at a specific time.Is it possible with airtable to match the time the email is send to different timezones?Eg. the same e-mail is send at 2pm CET and 2pm ACT, etc Thanks  

So I use airtable to organize content for my websites and it’s been great. I initially started using it to create a web archive for a artist syndicate that needed a place to put up all their media, which is where I first encountered this issue. When uploading to wordpress using WP All Import Pro I need to have a bare url, but airtable dumps context into the field when you query the url. I was able to get around this using a regular expression to search for the beginning of the actual url and exclude everything before and ignore special characters. That worked fine considering that I only needed 1 attachment per post. Well now, I’m doing something similar to my own photo/video site and have created a portfolio post type where I can upload multiple photos into a gallery for each post. Thus I have multiple attachments per record in airtable, which the regular expression does not work with since there are multiple urls. So my question is how can I get airtable to spit out a completely bare

I want to create a unique share(public) link for each record, so I will send created link to each user, so each user can be edited only one record.Is it possible?Thank you! 

I'm in a pickle and I can't figure out what to do even though I've read a lot of posts here and asked ChatGPT to help me over and over but nothing.I've got three fields that are formulas but they're formatted into integer type. 1. {Fecha limite de adeudo (dia)} and it's formula:IF(OR({Quincena 1}, {Quincena 2}),IF({Quincena 1},17,1)) 2. {Fecha limite de adeudo (mes)} and it's formula:IF({Quincena 1},MONTH(TODAY()),IF({Quincena 2},MONTH(DATEADD(TODAY(), 1, 'month')))) 3. {Fecha limite de adeudo (ano) (number)} and it's formula:VALUE({Fecha limite de adeudo (ano) (string)}) I tried combining them the following way but Airtable says "the result type is not a number or a date".IF(OR({Quincena 1}, {Quincena 2}),DATETIME_PARSE(CONCATENATE({Fecha limite de adeudo (dia)},'-',{Fecha limite de adeudo (mes)},'-',{Fecha limite de adeudo (ano) (string)}), 'DD-MM-YYYY'),"") I want this last field to be a date/object type and I don't know why it's not working because the thre

I am working on a field that pulls a result based on a number range.   I aim to convert the number of days from a person's hire date and an incident date to a set phrase such as "Less than 3 Months",  "4 Months to 1 Year", etc.   My first field converts the difference between their hire date and the incident date to the number of days.   My thought was to create a formula that says if the number of days is between 0-90, then the result is "less than three months," and so forth.   My fields are "Hire Date", "Incident Date", & "DateDiff".  The field I need to formulate is "Length of Service".   What is the best approach to get my outcome?  

Hi,I have an automation that triggers every day at a specific time.I want to end the automation after a number of days.How can I do that?Thanks,Jacqueline  

Hi all! First post - seems like a great community.I have an Airtable view that I'd like to be semi-public: Users who have an account with us should be able to log in and view the view, but those who don't should not. Can I do this from a security perspective? As I understand it, if I embed the view anywhere it has to be inherently fully public and that anyone with the link to the view (that the embed code uses, for example) would be able to just open the view directly in Airtable.Is there any way to do this?

Do e-mail automations work on the free plan?Thanks  

Hello everyone 🙂I work for a school and some workshops are made in groups of students.For instance, I need the 6 people from the Thursday, 11am slot to receive the same e-mail, visible e-mails in the "To:" field, and to Cc their trainer.Is there a way to select the e-mail addresses from the group meeting these criterias (day, hour) and send the same e-mail to all of them instead of sending individual e-mails?My idea is to do a concatenate formula to blend all addresses, but I'm not sure how to do it, and I'm afraid it would send multiple times the same e-mail...🤯Thanks a ton for your help!

I have an automation that emails the count of records that match certain criteria. This often results in emails that indicate there are 0 records for consideration. I’d like to only fire this automation (or send the email) if there matched records are >0. Is this possible using the new conditional automations, or via scripting? Thanks, Andy.

Here is my formula which I need to add a few more statements too.    IF(AND({LOS2} >= .0, {LOS2} <.26), "First 3 Months", IF(AND({LOS2} > .25, {LOS2} < 1.00), "Within 1 Year", IF(AND({LOS2} >= 1.00, {LOS2} < 2.00), "1 - 2 Years", IF(AND({LOS2} >= 2.00, {LOS2} < 3.00),"2 - 3 Years",  IF(AND({LOS2} >= 3.00,{LOS2} < 4.00,"3 - 4 Years")))))) Here is a screen shot of the table.  It isn't capturing the last statement in the formula; it is returning nothing. It should return 3-4 Years.  What am I missing?     

Hourly pay is dependent on age as shown below. I have 2 fields setup in my table: 'Age' and 'Hourly Pay'.I've tried all combos of IF, nested IFs and <= symbols but can't get the formula for all 3 age/pay combos to display correctly. Your help is needed folks..! 23 and over21 to 2218 to 20£9.50£9.18£6.83 

Seems like it should be relatively simple, all I want to do is use a button from an interface to add 1 to a number field in my tableI'm using the button linked to an automation and here's what it looks like:And this is using a dynamic update:But here's what happens when I test this:So I guess it's the wrong format, and I can't find any documentation on formatting for this. Seems like I can't even add two fields together.So how would you do this?  

I'm having issues getting a formula to round down prices to the nearest $2.50.I've tried FLOOR() FLOOR({Price}, 2.5)and ROUNDDOWN()ROUNDDOWN({Price},2.5)but without any success. Thank you in advance.