Ask the Community

Hi folks,I've been trying to solve this puzzle all day; there are quite a few scripting examples in the community here that I've tried to adapt to my use, to no avail.Here's the situation:These two columns should be ordered exactly the same, except that the one on the right gets jumbled up during a "find records" step in an automation that populates this field.They're ordered this way in the line items table, but for some reason the "find records" step jumbles them up:I need a script or formula that will re-order the line items in ascending order according to the purple-circled numbers in the line item IDs. I have used Batch Update to do the job, but I'm looking for an automated solution that will sort the line items for use i

New to automations - I would like send a reminder email to trigger when date is TODAY.  The field in the record is Target Date.  The automation states "when Target Date is TODAY".  This works, but the trigger continues to send a reminder email beyond the date in the record.  For example, the date is 3/1/24.  The reminder email was sent on 3/1/24.  However, I notice over the weekend that the reminder email was sent on Saturday 3/2 and Sunday 3/3.   

Hi,I've just started looking at creating an Extension, and one of the things I'd like to do is authenticate the user against Azure AD through either implicit or PCKE flows so I can then call internal APIs requiring an AD token. For a normal React app I would use the MSAL library to redirect to AD and then redirect back to the app on successful auth, this however doesn't appear to be possible within an extension due to the lack of callback URL.Is anyone able to help provide some guidance around whether this is possible within Extensions? Perhaps someone is doing something similar with Google/Facebook that may be able to help.Thanks!

 I am trying to automate my order fulfillment process. It's a subscription service where products are in a certain sequence. Subscriptions can be monthly, 6-month, or 12-month. The products are the same and sent out every month but need to be in a specific sequence and depend on the customer's subscription type. I want to generate an output file for the customer when they place an order with the products for the complete duration of their subscription so I can track where they are and how many orders are left in the future.I am creating an automation where the trigger is 'when a record is created' in the Orders table. Then, I use 'Find Records' which searches for records in another table (product table which lists each product delivered every month) depending on the condition where subscription equals subscription type. Then 'repeat for each in the list of records' creates a record. The problem I am running into is it generates the c

Hey all,Been trying to implement Airtable webhooks for our company however i've ran into a slight problem with the signature of the webhook itself. No matter how I move things around, encode or decode, it refuses to match the signature provided by Airtable.The code below generates a HMAC but doesnt match the one provided by Airtable. I cant use the Crypto module since thats Node only which sucks. Is there any secret sauce that im missing from this code? All the docs say is to just decode the base64, shove it into Code below:const decodedMacSecret = atob(webhookConfig.macSecretBase64);const encoder = new TextEncoder();const data = encoder.encode(bodyText);const hma

Hello everyone,I'm trying to sum a row containing several values.In fact, in the second cell with 140120,178216,0,0... I'd like to sum these values.Do you have any ideas?Thanks in advance,

I've contacted support for the first time in the summer of 2022 (!) and I'm still having the same 2 issues: copy/pasting between long text fields doesn't copy the text stylecopy/pasting makes the screen jump from the place in the long text field where I'm copy/pasting to the top of the screenBoth issues are VERY annoying. Is anyone else (still) having this problem?  @MaddieJ, now that support only seems to work for Enterprise clients, how can I escalate this best?! After hearing from support back then that they would look into it, never heard back from them 😑

I've tried to create such an automation:When one updates the value of field 1,if this value matches that of field 2,input a static value into field 3!How do you let people do this?Because AirTable doesn't let us set this condition, I've done this:a. added a hidden field with the formula: IF({field 1}={field 2}, "1")One can input any value after the condition / first comma.One can add an "else" output after a second comma.b. set the condition: If this field 4 has the value 1I've added step a because some service providers make service users do costly work.Service providers are supposed to do the main work. This is a part of the main work.

I am an experienced programmer, new to Airtable.I have two tables, one a 'triage' table where some client information is entered. When the client passes certain criteria I want to add the client information with some additional fields to the 'client' table.The first pass at doing this with a button that builds a url to a form connected to the client table does work.There are two issues - the button can be pressed multiple times, adding the client more than once. Also if the user is in the Airtable app it launches the web version which is disconcerting.I have experimented with a script that tests a two state Single Select field (changing it from "New" to "Added to Clients"). However I cannot see how to launch the form from the script. Is this possible? 

Hello everyone,I am actually building a carousel using the Web API. I am going over the documentation and I cannot find a way to do what I want. I am trying to get the previous and next row with an id of one row in a filtered table.For exemple, I have the following data:ID |    Name    | Category1   |       D         | CategoryZ2  |       B         | CategoryZ3  |       C         | CategoryLIf I want to get the previous element and next element of B when the table is filtered by the Category column and Name column. In this case, the previous element is C and the next one is D, How do I do that using the Web API?The only thing I could maybe think of is a way playing with the "offset" parameter. Maybe I am missing

So I'm basically building out a progress tracker to track sales.  Once a sales rep lands on the interface, I want them to only see their own record, and nothing else.  Any way to do that?Just to clarify, the Sales Rep looking at the interface should only be able to see his own record in the interface. Cheers!

Is there a way to create a link to a form with pre-filled information? For example, I want a button in an interface that can go to a form to add a bug linked to whatever the user was looking at in the interface, so that the link is already set when opening the form.

Hello.  I'm not a developer but I managed to create a button that when clicked sent a webhook to Make to run a scenario.That process has now broken because of the whole API thing (which I don't understand).  Can anyone tell me how I make the button send the web hook now?  I've created a Personal Access Token but I don't know what to do with it and I'm not even sure that's the right solution.Thanks in advance

Hello,My subject might not be entirely accurate. Bangin my head against a wall for a few days now.  I haven't been able to find the solution to my problem here, and I feel like there really must be one.  I'm trying to come up with a way to quickly calculate what individual contractors should be paid for events, and display as a grid or list or interface that is easy for the person entering "payment requests" to read. This is currently done by coping over the information into an excel spreadsheet to do the calculations and then reentered into a payment request spreadsheet...but I already have all the information here in airtableI have a table of "events", and table of "sessions" (an event might be made up of 1 or more sessions/ days) and a table of "contractors". I assign contractors to "sessions" through linked records. A contractor may work 1, 2, or all "sessions" of an "event". The sessions have a set number of hours assigned t

Hello!We need help with a script or automation that duplicates an invoice/record from an interface view and opens it in a new window to be edited.We have an "Invoices 2024 Table" that is linked to our "Projects" table and "Invoice Lines 2024" table.Our interface for the Invoices looks like this.I've been able to get some scripts from ChatGPT to duplicate the record and open it in a new window that pass the coding tests, but when I click the button on the interface, nothing happens.Thanks in advance for your help!

I am building out a job board on webflow, and I had a workflow where a user would fill out a form to submit a new job, form data would go to Airtable, then from Airtable back to the Webflow CMS. Does this make any sense? (Using Zapier). Or should I just move the data from the Webflow form directly to the Webflow CMS? Thoughts?

Hi there! I’m trying to use the IF and DATEADD formulas to calculate a Project Start Date based on whether or not a Launch Date is entered for a record. If there is no Launch Date entered, the record field should be left blank. Here is the formula: IF({LAUNCH DATE} = BLANK(), “”, DATEADD({LAUNCH DATE}, -16,‘week’)) What I am getting is a date string (2021-10-18T00:00:00.000Z) instead of the Friendly Date format. Help please! :slightly_smiling_face:

When configuring SSO using Okta, I will also configure Provisioning with SCIM. Can someone help me with a few questions on this subject?Using Okta SCIM provisioning:- how do I ensure all new users created in Airtable have a default "Viewer" permission?- how do I ensure all new users created in Airtable are assigned to a specific workspace? And that they cannot access other workspaces unless granted.

Hello, I want to have a merged table consisting of entries I manually created plus entries with the same data structure that i fetch from an external data source via API.The external source could be updated in the future and ideally I'd want the records in the table to update as well. Is that possible? Help is greatly appreciated 🙂

Hi everyone, I'm really bad with the formula field!I'm trying to create a formula that prints "OK" if each user that I added has an active status; if some users have inactive status, print "not everyone," and if nobody has an active status, print "nobody." My problem is that the formula is based on info from another table, but I need it on that table.Those are my examples of base: I'm trying to add this formula field to the Report Table. Can someone help me? thank you!  

How can I add just one button on a table and that button be able to include an automation?I have an automation and I need to add this automation in a table with a button. Just one button that works for all records in the table, not one button for each record which is what you can normally do.

Am I missing something or Airtable does not have an input method to select a user (aka Collaborator)?What I want to do: create a script that first asks to select a user.I know I can create a workaround (below) but that is not my question... is there really no Collaborator input?(we are also missing a Date input since at least 3 years apparently - only solution is to parse text... for real?)Automatable workaround, for those interested:create a table, call it "Users" or somethingset two fields, Name (type: Formula)

Hi Community,I am pulling information from multiple records in a sync'd base into one record in a new base. By doing this I getting multiple images associated with this record, which I love. However some images are associated with multiple records in in the sync'd base and therefore multiples of the same image is added to the attachment. Is there a way to remove the duplicate attachments without having to do it manually? Making sure all attachments are unique.Thanks! 

I am trying to add a button in the interface designer to open up the address in google maps. I want to pass the address and city field to google mapsSo something like:"https//google.com/map/place/" & {Address} & {City} I can't seem to get it to work. Existing examples on this forum seem to refer to the old interface designer. On the new version can you do this? If so can anyone suggest the correct format?Thanks in advance.

Hi,I have a very simple script that sends two single fields of one record via a webhook to another service. Yet I'm getting an execution error:Script exceeded execution time limit of 30 secondsThis script was working fine for last two years and now it's throwing this type of an error once in 5-6 executions. How can I fix that?The script: console.log(`Hello, ${base.name}!`);let inputConfig = input.config();let response = await fetch('here_is_my_webhook_url', {&n