Ask the Community

Im new to airtable and make.com so forgive me if this is a elementary question...I setup an automation that has a Stripe webhook to monitor for payments and then update a record when there is a payment but I cant get it to update the record. It can find the record no problem but when it gets to the update module it gives me an error.Bellow is the log and setup of the update module. What am I doing wrong?Thanks in advance!   

I need to automatically trigger a script that makes use of `Field.updateOptionsAsync`to add options to my single-select field. I first wrote this as an automation script so I could easily set up a trigger, but saw this API is only allowed in scripting extensions. So then, I wrote it as a script extension and couldn't figure out how to automatically trigger it to run. So then I found out about block-cli and released the extension to my base because I misunderstood that `block run --remote` does not run the extension remotely, leaving me with 2 extensions that do the exact same thing. So:Is it possible to run extensions remotely / trigger them to run automatically? How so if it is?Can we get the ability to use `updateOptionsAsync` in an automation script?Is there yet another way to achieve what I am trying to do? 

First using airtable but profecient in Python, SQL and some JavaScript/Vue3.js for house needs. I dont consider this a "complex problem", but havent been able to crack it in Airtable env. only.I have a scenario where i want to dynamically control form field visibility based on "boolean" values from another table. I am aware that form defaults to communicate with one record at a time given the table it belongs to.I have a table named "application" and another "analysis" and fieldsnames are generally the same. once "application" has a PDF file attached, analysis makes a "lookup" and a python script executes 16 rather complex regex patterns and saves the output as boolean values, could be "1 or 0", "yes or no" and "ja or nej".From the analysis output, the idea is/was to use these booleans as a condition to manage visibility and nothing else. Because, as you can see in the bool_update_flow.png attachment, the users are to upload specific images.If it is, can

Hello!I am wanting to add a DATEADD formula to my base to set deadlines for different tasks based on a hiring date. I've done this in a previous base, but have since lost access. Can someone help me with the formula I need? For reference, some of the formulas I need help with are:Task: Email for photo, new hire survey, and short bio of new hire (-7 days before Hire Date)Task: Assign desk space for new hire (-3 days before Hire Date)Task: Give Uniform (on Hire Date)Task: Collect how to contact employee while OOO (1 day after Hire Date) This is my current formula:IF({Task} = "Email for photo, new hire survey, and short bio of new hire", DATEADD({Hire Date}, -7, 'DAYS'))When I add another {task} = ..... , it changes the format of the first deadline from a date to T00:000:00.OOOZ and then the next task's deadline just shows up as "true." When I reopen the formula, it looks like it changes itself fr

Hi Airtable Community...I'm new here!I two tables:- Table One:  with user name, email, phone, and an attachment (file pdf).- Table Two:  with new client information once a form is submitted which will create a new record (name, email, organization, and phone)I want to send an automated when a new record is created in Table two and to attach a file from Table One (column is called attachment)When I click on the + to Add an attachment: Base Structure --> I can only insert date and time value, which seems to not be correct.Can anyone assist. If this was posted before - I apologize, and point me in the correct direction.Desert1211

Hello. I’m working on importing record or data from Airtable to Salesforce. I created a custom automation in Airtable that runs when the button is pressed. However, the data is not being updated in Salesforce as expected for each table.

Hello!I would like to create a field that shows when (date and time) a record (task) has been marked as "Done". Here is what I have so far: How do I create a formula and/or automation to do this? TIA!

Hi Airtable Community - I am fairly new to Airtable.  A couple of months developing. Have a few questions below.  Many thanks in advance for any guidance provided.Q1: Need to merge two bases - what is the way to go?  The chatbot mentioned scripts to bring data over and sharing the tables from one base to another.  I would like to merge the two into one Master one and not lose existing comments in any records, any history or scripting/automation in either.  Is there a way to do this? Q2: How do I see/query the backend table structure in Airtable via  SQL? Is that possible? is there a tool out there that can help with that?Q3: Any companies that offer Airtable development that I can chat with - looking for rapid development so need more Airtable engineers?

I'm trying to create an automation with these conditions:First and last name matchOriginal entry with matching name was created within 90 days agoWhen I try to use when a record matches conditions trigger, it does not let me select a dynamic variable so I'm kind of lost on how to move forward with this so any help would be appreciated.

In attempting to learn how to use this new Beta feature, I’ve created a bunch of test interfaces that I’d now like to get rid of, but how? For the likes of me, I just cannot find where it’s possible to delete an interface. Thanks in advance to anyone who might help. If it’s not possible yet, then please consider this to be a bug or feature request instead.

When I do a rollup to get the unique documents, it is correctly retrieving just the unique values - but while a lookup brings up the actual attachment documents, the rollup displays Airtable's Internal URL for the document.How do I then retrieve the document?   

I have a few currency fields that I am adding up in a simple formula field. I am then trying to display the output of that formula field within a text string I am building with another formula. However, I’m getting some strange decimals when showing the numbers.In an effort to troubleshoot this, I create a new blank Airtable base for testing and I’m getting the same result. For no apparent reason (to me), when I reference the total field in the string, it will sometimes add a ton of decimal spaces, like this: Here’s a link to my sample/testing base that is showing this issue: https://airtable.com/appqBYuTjL8QbhmF4/shrM4rk6GDRaJQ4QNMy formulas are pretty simple:Total of Amounts 1 & 2: {Amount 1} + {Amount 2}

Hi all, New to Airtable and trying to find a way to do the following:We have an existing base with all projects as a furniture staging company. These projects are based on addressesEach project has inventory associated with it in a separate Excel doc at the momentWe want to now add the inventory associated with each project in Airtable without having to manually add each item one by one to each projectThe excel would have the project title + associated inventory in individual rows. Is there an easy way for the import to recognize the project title (address) and then easily "assign" the inventory name and QTY to that project title?  

Trying to figure out how to do a search to see if a number falls within 2 fields.For example a field with Start year and a field with End year.  Lets say on one record my start year was 1978 and my end year was 1986.  I would like to do a search for 1983 and have it retrieve that record.  Can someone point me in the correct direction??

Hey all, just trying anything at this point, I have an airtable Team account that was made forever ago, and was grandfathered into the $10/mo plan. I accidentally aded a billable user but then removed them, but the system kept trying to bill for it, and not my account is cancelled, along with the money I have already paid, and the $10/mo plan I had.I have emailed half a dozen times now over a month and no response, and my account is going to get shut down.Anyone here that can help?

Hi, I’m trying to share a developped interface with other users in my organization, they receive the link by email by they are invited to login. For information i’m in the Pro panel with only one user. Can someone help me please. Regard’s Amine

HI folks, trying to create a record review and dash board in interfaces. I am in editable mode. However I cannot add, change, move or colour elements. The '+' sign at the bottom left corner of the screen does not appear so I cannot even create new elements.  I am an 'owner' of the base so I should be able design and edit interfaces. Any signposts or advice would be greatly appreciated. 

Hi, to be honest I’m not sure if it actually is a bug, but this function does not follow the ISO standard of numbering weeks. For example, today (2016-10-13) should be week 41, but the function returns 42. Probably because the first week of this year was week 53 according to the international standards.

Hello!I was recently helped on another post to create parameters for the dateadd function. However, it is not calculating dates correctly. Why? How do I fix this?Here is my function:SWITCH(  Task,  'Email for photo, new hire survey, and short bio of new hire', DATEADD({Hire Date}, -7, 'days'),  'Assign desk space for new hire', DATEADD(

Hi,I have a base where I keep my business's time entries for each of the employees.  However, they may be in a different state based on the day, so I'm looking for a way to populate a field for each time entry showing their location.The time entries have a date, a person who performed it (currently as a linked record), and the the number of hours.I currently have a sheet with a separate record for each date and single select field for each employee showing the state that they were in.  Note I can change the organization of this table if needed (for example to entries with a date, a single employee and a location).  Any thoughts on how to best set this up?  I currently have lookup fields for each individual employee in the time entries table, looking up their location on the given date, and then a formula field that uses a switch that selects which lookup field based on the user who performed the time entry.  However, it requi

I need to calculate different due dates for tasks based on Workday instead of dateadd. Here is my original formula: SWITCH(  Task,  'Email for photo, new hire survey, and short bio of new hire', DATEADD({Hire Date}, -7, 'days'),  'Assign desk space for new hire', DATEADD({Hire Date}, -3, 'days'),  'Give Uniform'

Hello friends, how are you?I'm really sure I'm missing something! Something so simple and easy can't be that complicated!I have one table of leadsAnother table of Ad costI want the Ad cost table to sum the number of leads I have on the same date from the leads table and then actually make a formula that will divide the advertising cost by the total leads.I made a Linked record for the leads table and made a filter that will show me only the leads whose "registration date" is the same as the date that appears in the date column.It does show me all of these leads (except for the ones whose date is the day after for some reason) but I don't understand how I can just automatically pull them into my list without using any automation that would make everything complicated!It really seems super simple and super easy to me but I've been wasting too much time on this!!I would really appreciate some help on this topic!Thank you very

I want to filter to the infinity values but am unsure how to do this. I don't want to remove them using an IF statement or the other tricks you can use to have them become zero or empty values. The first screenshot shows the data and that there is one value with Infinity. When I try to use the filter condition to equal the infinity value I am unable to enter the word infinity because it only allows numbers. Next I tried to filter to a value greater then the highest value other then infinity and this filters out everything including the infinity value. How can you filter to the infinity values?    

Hi , allI have a problem that I can't solve, I have a script that updates the prices and countries of my products based on a code for exampleThe problem is the following if two products have the same code then it modifies both. To solve this I thought in the following way each product is linked to a unique supplier so I just need to retrieve all the suppliers displayed to my user so that he chooses the right one and I would only update the products from this supplier while always comparing if the code is the same.I manage to retrieve the suppliers but I cannot update the products afterwardsWould anyone have an idea?

Hi,I want to create a formula to create a name for a field that consists of "FIELDA" or "FIELDB" If "FIELDA" has no value i would like to show "FIELDB" in the name instead. If "FIELDA" and "FIELDB" both have a value, I would only like to have "FIELDA" filled in the name of that field. If both have no value, no value should be shown. Thanks for helping out! Mark