Ask the Community

Is it possible to embed a jotform into a website that uses url parameters from airtable? I use automations in airtable to send emails and with links to jotforms, but I want to be able to embed these forms into a webpage, but keep the url parameters from airtbale. Is this possible?

Hey guys,I have attached an airtable form link to my wix website but it loads extremely slowly. It was not like this before. Any hints on how to resolve this?

I want to use the “send an email once a record is created” automation tool, yet I want it to from an alias account connected to my g-suit account. For example- once a user is registered to my website I create a record containing all his info. then I want to automate an email welcoming him to our service, yet I want the mail to be sent from an alias account (info@…com) and not my personal address (for example- david@…com). Airtable allows me to connect my g-suite account (david@…com), but the alias account (info@…com) cannot be connected (because there is no actual account). Any suggestions on how to set an auto-reply from my alias account?

Hello, I am looking for a way to calculate a date minus x days based on a date field. I.e. the result should be 31.12.2023 (DD.MM.YYYY) minus 10 days = 21.12.2023. How can I do this? I tried to use this formula, but it returned an error:  DATETIME_FORMAT(DATEADD({Date Field}, -10, 'days'), 'DD.MM.YYYY') Thanks for help, M.

Hi all,I hope you can help:At the moment, he same view in interface designer hides the other fields of a record (please see the attached screenshots) which make them really difficult to find the right lesson when people use compared to the database. Is there a way to add these additional fields to my interface? Many thanks, Alastair

Hi I am using the metadata script to show fields and tables in a base. I would like to create one for all the views in a base. Does anyone know how to adapt the script or have something I could use please? Thanks, Maria

Hey y’all, Starting to dip my toes into Airtable Automations which are pretty neat, but worried about long term maintainability if I am to lean on them more heavily. Do you all know of any ways to report errors within Airtable itself? Or is it better to wrap all scripts in a try catch & report to an external error service like Sentry?

Is it possible to set a table to sync from an Excel Sheet?  I know I can import data, and I know I can setup Bases to sync, but I'm looking to set up a Table to pull data from an Excel sheet and keep up to date with those changes.

Hi all, I've been a fly on the wall in the community for a while now, today I need some help. I reviewed this post to help me with my problem, however I'm still running into issues I can't seem to get around with my current ability. For reference, I'm getting comfortable with formulas, but have no scripting/coding experience. https://community.airtable.com/t5/other-questions/create-tasks-from-templates-table-via-button-automatically/m-p/47873#M9641 I need a template of tasks, like in the above post; but I need to be able to repeat these tasks for several projects. I've managed to get this above suggestion to work, but it turns out that I need to be able to make NEW tasks that aren't linked to each other, every time I trigger my automations.E.g. My base is built of three significant tables. A 'To Do list"  table; a Projects table; and now a task template table.The To Do list table consists of tasks, linked to the Projects table. So that table has a list of proje

An automation is failing with the following error:"field "ID" cannot accept the provided value: cannot modify a computed field" The automation is supposed to create a new record in table "grants", when the "proposal" form is filled in. However, the automation fails to create an ID in the "ID" field in the "grants" table.  What is strange about this error is that sometimes it works and sometimes it doesn't. I don't know why. Looking forward to your response.

We have two bases, a UAT and a Prod base.  Changes are made to the UAT base, and once approved, we sync to the Prod base.  We notice that the records themselves sync over, but they are not in the same order.  Are we missing something or is this a limitation of sync?

I am trying to create a table that is linked to a Box folder where I have hundreds of folders inside the root folder. Those folders contain other sub-folders and tens of thousands of files. (Root Folder>Folder>sub-folders/files). I don't want all the (sub)folders and files to be synched to my table, just the folders. In other words, I want all the information to live inside of box and just have a button/link to click to open the folder where the (sub)folders and files reside. There doesn't seem to be a way to just have the folders synched without it trying to synch all the (sub)folders and files. Needless to say, it quickly hits the 10,000 record limit. Howevere, all the folders I actually want to see are included within the synched table. I can create a filter to weed out the sub-folders and files, but I don't want that information just hanging around burning up records (counting towards my record limit). I hope all that makes sense. Does anyone know a way to just synch the fold

Hi everyone, Excited to be using the Airtable API!I'm trying to add new fields to a given table in a given base via this endpoint, but keep getting a 404 {'error': 'NOT_FOUND'}Here's my code:payload = json.dumps(payload)response = requests.get("https://api.airtable.com/v0/meta/bases/{base_id}/tables/{table_id}/fields".format(base_id=base_id,table_id=table_id),headers={"Authorization":"Bearer {token}".format(token=API_TOKEN),"Content-Type": "application/json",},data=payload) Could anyone advise?

I am unable to update my records . The code screen dump has been attached. The last line is showing error that my table does no contain field  "Duplicate?"

Hi all, is it possible to run the “Sync now” command which synchronizes the records from the source base through a script? I would like to create an automation that has a webhook as its trigger and this script as an action. This is because I have a scenario on Integromat which sometimes fails as it does not find the record that has not yet been synchronized (despite there is a 5 minute “sleep” module). Thanks everyone for the help.

We recently encountered an issue where a user ad hoc added options to a multi select field that should not have been there.Is there any way to lock down available field options so a user is not able to add them in?

Hi! I am trying to add stacking and when i add the notes in it doesn't save the information I need. How do i fix this?

Hello, has anyone experienced this issue as of now on October 6, 2023?I usually copy and paste leads from our sheets to Airtable to directly upload leads for our campaign. However, at 5am ET, I couldn't even copy and paste a single row into our database.Is there a solution for this? I noticed announcements stating that Airtable is performing database upgrades today, so I suspect that might be the reason. However, I'm not sure if this is happening only on my end.I would appreciate hearing from others as well.

Today the "Expand the table" feature stopped working for me. I see it's happened to others in the past. I'm using the work-around of creating enough empty records in the destination table before I paste, but that's only feasible for small datasets. If there's a way to automatically create a specified number of empty records, that would be helpful, too.I don't think mismatched structure between origin and destination tables is the problem, as I had always been able to paste records into a mismatched view when I wasn't paying attention.Has Airtable has ever addressed why this happens? It would be great to be able to fix it, as my business process is heavily dependent on this feature.

I’m probably missing something, but how do I get the current day of the year? For instance, we have WEEKNUM(TODAY()), but not DAYNUM(TODAY())? I can do year(today()), and week(today() but when I do day(today()) it shows the day of the month and not the year. Thanks! Example: Jan 1st 2021 is day 1, etc.

I have several views that show the icons without the words - it's driving me crazy that I can't figure out how to put them back, or how they got this way in the first place.Please send help! And please also don't ever make me have to deal with that truly circular, frustrating and unhelpful bot on the help bubble.

I already have a formulas that work fine although i need to add “( )” around my Base field called MODELEIF(AND({PRODUIT},{MODELE}),{PRODUIT} & " - " & {MODELE} & "\n",IF({PRODUIT}, " " & {PRODUIT} & "\n") &IF({MODELE}, " " & {MODELE} & "\n"))& Right now when I got the formulas it shows ANNEAU DE FOULARD - ALEXANDERI would like to add ", so it will show this.ANNEAU DE FOULARD - "ALEXANDER"   

Hello everyody,I have 2 tables with date column.When record is created in Table 1, I want to find all the records in Table 2 where the date is the same.For this case i need to use a condtion with dynamic date field, I found out I can do it with a string field using the gear icon and choosing 'dynamic' instead of 'static', though I couldnt find this icon when conditioning date field.Is this function unavailable, or am I missing anything? is there a different way to do so? 

I created my own Extension under "Build an extension". I've released these extension command using block add-remote , block run and block release. It working fine in that base, but I want these extension in my other bases. Is it possible to access by other bases?How and where the released Extension is findable?

I have a base with two tables. One table is contacts while another is companies. For my contacts, I have a field called location which is a series of metros: NY, SF, DC, London, etc...I'd like my companies' table location field to have the same list of locations. Is there a way to reuse the field, but not have them link to one another?(I dont anticipate wanting to ever connect a contact to a company, and if i do it would be with different data than what i have in my contacts records anyway)