Ask the Community

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) and Collaborator (type: User)set the formula in Name to just display the Collaboratorthen create one record per actual user of your base(optional) create an automation running at fixed time intervals that will look for all users (base.activeCollaborators) and add/remove records accordinglyNow in your scripts you can create a form asking for a user using the input.recordAsync method.I am baffled to seem to have to build this myself.

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', {    method: 'POST',    body: JSON.stringify(inputConfig),    headers: {        'Content-Type': 'application/json',    },});

Hi!I've been looking to see if it's possible to have the JIRA Cloud Extension automatically pull down to a defined table within a base at given intervals rather than to have to manually click the "Pull from Jira" button.Was looking at the automations functions and it didn't seem like it was possible. Any ideas or is manual the only way?

Hi!  Using an automation designed to send and collect wedding rsvps via a form - I customised the automation to use it for our events company.The automation uses a CRM/Contacts table, a RSVP table to collect the new responses, and a form linked to the RSVP table. A personalised link in the CRM/Contacts table is sent to each contact. This link (image attached) is a form prefilled with their name and details, and few empty fields for them to complete. The data entered into the form > feeds into the rsvp table > then updates the CRM/Contacts table records.The problem we're having is invited people are forwarding their personalised links to others for them to attend the event. Inviting new people isn't a problem - the problem is the new person overwrites the existing data/user in the CRM table (unlike a wedding where guests don't invite other guests). I have to manually go, roll back the data, and create a new record for the new person.To circumvent this I created another step t

I can't find anything wrong. My access token has everything:When I try in postman i always get the error above. This is my post request:Yet I always get this error message: Help please? 🙂  

Hello,  I'm trying to create a formula that will return "Check Other Income" if the Contract * .25 > Other income and if Other Income Verified is checked it will return "Income Verified" This is how I have written the formula:IF({Other Income} > (Contract* .25), "Check Other Income", IF(AND({Other Income} > (Contract* .25),{Other Income Verified} = 1) , "Income Verified", "")) No errors returned, I can get it to say "Check Other Income", but the second half of the formula that has to do withe the checkbox is not returning "Income Verified.  Can anyone help me figure out why? Thank you!

I have an Automation that triggers when a new pdf has been added via Documint.  It sends an email with the pdf document that has been added as an attachment.  The issue is it is sending all of the attachments in the field and not just the one that has been most recently added. I would like to know how I can send just the last attachment that has been added in the field and ignore the existing ones. 

Hello,I use "Zoho Flow" app to integrate "Zoho creator" app to "Airtable"Through the process of mapping the fields, I am struggling to understand what is the "Record ID" that Airtable needs me to fill. Can you please advise? Knowing that I am creating a workflow that triggers on record edit.

Hi.I am new to this so sorry if this is the wrong place to post.I have tried to searched for it, but could not find it, so if anybody have a thread about it, please guide me in the right direction 🙂We have just started using airtable for our small business, and have made a table for our orders. Is it possible to create a new table for a monthly summary of our orders? both for number of orders and for a total sum?

I have created a personal token with data.records:read scope.I have created an action in OpenAI GPT with schema:openapi: 3.0.0 info: title: Airtable Direct Access API version: 1.0.0 servers: - url: https://api.airtable.com/v0/appM376pMJS0ddkXZ/tblbxbPFVM8FaZdos description: Airtable API server for the specified table paths: /records: get: operationId: getRecordsFromView summary: Fetches all records from a specific view in the table. parameters: - name: viewId in: query required: true schema: type: string default: viwPnVZGLgVvdOvsF description: The ID of the view in the Airtable table to filter the data by. responses: '200': description: Successfully retrieved records from the specified view content: application/json: schema: type: object properties: records:

Is there a setting to only receive notifications if someone is "@" ?Currently seems like in our interface, once you get an "@", you are permanently watching that comment thread for all future comments. we do NOT want that. so ... Is there a setting to only be notified if you are "@" in that specific comment? OR ... is there a way to unwatch the comments from interface?OR ... is there an automation or API to constantly run to unwatch comments?OR ... a script to unfollow? 

I am trying to get Earliest or Latest date from a field (example: 2022-10-13, 2022-10-15). When I use Min or Max formulas - I get zeros. (I marked those areas as red)Looking forward for solutions. Thank you!To better understand my case I have prepared how everything works in my Airtable:First sheet is for a/b test Data. We import all a/b tests information here.Single line textLink to Other sheetSingle line textFormulaFormulaLocaleLink to FlowsA/B Test DatesA/B Test Start DateA/B Test End DateFRCountdown timer10/13/2022 - 01/02/20232022-10-13 2023-01-02DECountdown timer10/15/2022 - 01/05/2023 2022-10-15 2023-01-05 Countdown timer test runs on multiple locales. in this case - French and German locales.I receive it in such formatI use this formula for this:DATESTR(IF({A/B Test Dates}, REGEX_EXTRACT({A/B Test Dates}, "[^ ]*"))) I use this formula for this:DATESTR(IF({A/B Test Dates}, REGEX_EXTRACT({A/B Test Dates}, "[^ ]*$")))Second sheet, which is r

I added collaborators to my full workspace. But actually want to give them access to specific bases. Is there a way to change this permission, without removing them from the workspace and then re inviting them to specific bases instead? I have searched everywhere. I feel this should be easy and visually blatant. Yet, I’m stumped. Thanks

Hi All,I'm evaluating airtable for replacing other tools, and I would like to know if in your experience is possible to implement what is written in the following link with just airtable https://www.airtable.com/articles/product/business-requirements-documentIs there any template? My aim is to build a complete BRD directly on airtable in a collaborative way and without using any external tools. Any suggest? 

Hello, I recently created a weekly report using the Extension feature's Page Designer. Now I want to send this report every end of the workweek (Fridays) using automation, but could not see a straightforward way to do so. 😞 I have to manually export the report to PDF, manually attach it to my Gmail and manually send it to stakeholders.Does anyone have a workaround for this?

This feels like it should be so simple. I've got a form with roughly 30 questions on it, and I want to use Page Designer to create a PDF of each response that I can then email to respondents. For the life of me, I cannot figure out how to get a simple grid in Page Designer that shows the responses. The only clue I can find is that if I add a Linked Records element to Page Designer I can choose Grid Mode, but I don't have any linked records in the table, it's just collecting the form responses as they come in. I know I must be missing something obvious.More details: we offer 4 different products and we're asking our partners how many containers/pallets of each product they will want in each month of the next fiscal year. i.e. In March 2024, partner A might want ten containers of product 1, five pallets of product 2, six pallets of product 3, and one container of product 4. I just want to show that in a simple grid in Page Designer - Month, product 1, product 2, product 3, product 4 - ba