Ask the Community

Hello!I'm using a prefilled form URL field. When a customer submits a button it opens the prefilled form in the corresponding URL field.The problem is that it works perfectly on desktop, but when using App, the prefilled form formula does not work.Is this expected bahaviour?Thanks!

Hi, I want to generate a vcard file from my records automatically. I already connected my Airtable to my app (Adalo) where I receive my users information. If I could generate a vcard file I could export it back with Zapier to my app, but I didn’t find that how could I generate it. Maybe a formula, but I’m not sure about it. Thank you in advance!

Is it possible to put a label on the Points in a scatter plot?Easy in gSheets.  Can't figure out how to do this in AirTable. Airtable Chart:gSheet Chart:  

Edit:Airtable response: Our engineering team has successfully deployed a fix for this issue (which arose from a recent update to our code) and any automations referencing an attachment should now run as expected without error.It's working again. Thank you all.---Hello.I've been using the Send Email action in automations for more than a year. Always worked great. In the Send Email action, in the Attachments section (Bottom) I selected the column that contained the file, and that file was attached in the email.3 days ago, my automation worked fine. But today, when the automation triggered, there was a problem (An attachment url is disallowed):

Hi,I am sure you will all tell me to simply build my web form in Airtable and connect it to my website. ( I dont know how to do this). I have a web form with fields in it on the web site ( fluent forms on WP) . I have got a token and connected to Airtable but i do not know how i can use the fields in the web form to create the fields in the Airtable base?any help will be gratefully received. ash 

Hi all,Can someone please assist me in linking my worklist with a reference table? Essentially what I'm trying to accomplish is to pull in information from a reference sheet into the main worklist whenever a couple conditions match.For example, if the "Region" listed on the worklist is AL-1 and the Insurance number is 4, it will search the reference table and pull in the 4th insurance plan from that specified region and import that plan name into the master list which will ultimately be displayed in the interface view.

Hi,I'm looking at abstractifying our e-mail contents to streamline the process. E-mail content is now stored in the automations itself, but I'd like to move it to a dedicated table. Our automations use a fair bit of dynamic content, such as <first name> in the opening line, derived from various "Find Records" steps.I tried to construct the desired e-mail content with a "List of <first name>" token and just copy/paste it to a Long Text field with formatting turned on. Airtable changed the variable to @Unknown and threw an error "Invalid data - you have to refresh the page", and didn't store anything of the pasted text.Is there way to build the whole e-mail content including variables into a template stored in a table?Rgds,Björn

Hi,In our CRM we started with building stuff for a workflow for one customer area, say "nature". Knowing from the beginning there'd later be a need for other areas too, I put a categorising "tag" in place. So we have the leads and some other key data labelled with tags like "nature", "sports", "food" and "music".There are a lot of email automation built in for this workflow. The other areas will largely have the process steps and hence hopefully very close to the same workflow.Starting looking at adding the other three areas to yet only simple email confirmations and reminders (there are more complex automations also) I got a bit stuck. I guess I could build Conditional Logic steps for each of the cases. However, as I now understand it, this would require to also hard code Find Records steps for each case.As there may need to be some updates and other actions too, I'm afraid I'll run out of steps at some point. It also bothers me to hard code all the case

I’m going to presume the answer is “no”, but is there really no way to wrap the text (esp title text) of a card when presented in kanban or gallery view? Has anyone found the CSS rules that can be changed in Developer Tools, perhaps?

Hi Airtable Community,I’m facing a challenge with importing large CSV files (10000+ records) into Airtable and would love some guidance. Specifically, I need to automatically detect and delete duplicate records upon adding or updating via CSV import.Currently, I’m using a script to handle duplicates, but due to Airtable's 30-second execution limit, it times out when processing high-volume data. I’d appreciate any suggestions on:Optimized duplicate detection and deletion methods that can handle large data volumes quickly and efficiently, potentially in batch processing.Alternative automations or built-in Airtable solutions that would automatically identify duplicates at the point of import, or shortly thereafter, to help with overall processing speed and accuracy.If anyone has successfully managed similar high-volume imports or has insights on achieving faster processing, I’d be grateful for your advice

I need to get the month to date total number of appointments per client, I am still not getting the result that I need I kept getting the total number since they started. Help please

Hello,I'm looking for a task list where I can set interval dates for a task and then have the base automation send an email reminder every so often to the individual to complete the task.  Or instead (in addition) have a dashboard where this data could be displayed in some capacity (perhaps filtered and sorted by job tasks that are overdue).I also want the user to be able to log in and check when they completed the task for a certain date.Let me know if you have any advice on this! Thank you!

Since space is limited, is there a way to limit file sizes for files uploaded via forms? Thanks.

Hey, I want to set up an automation, that will be triggered when the form is submitted and it will send the filled-out information to make.com so I can then use the submitted data in make.com. I couldn't find make.com in the supported apps that are available when setting up automation in Airtable. I also couldn't find the option to create a custom webhook. I saw that some people did it in the community, but I couldn't find how. So, Is there a way to create automation that sends submitted information from airtable to make.com triggered when the form is submitted? 

If a record is updated it would be awesome to sent the data to a webhook url. How would you do that?

Could you help us customize the width and length of the input form fields / boxes on this form? Airtable

I have created a form to collect input into my airtable, and have it embedded in a webpage vis iframe. Form loads and works fine, but the input fields are displayed in a narrow column down centre of page, rather than loading edge-to edge in the browser window. On moble, this makes the form look very small/unusabel. Is possible to zoom in but I’d much prefer the form loads so that the columns of input fields is displayed at max size in the available browser window. I’ve tried both with and without header graphic in the form, and have specified 100% width for the iframe. Anyone got some ideas what else to try to force load my Airtable form at max width?

Hi Airtable gurus,I am trying to create an automation that will locate a specifc record based on the record ID then update the Status field.It would look like this:Trigger: When a webhook is received (an invoice is paid in Stripe) I actually have the webook createdEvent: 1. Locate record (the appointment record that was created based on a Calendly appointment creation), 2. Update that record to reflect that the invoice for that appointment was PAIDI feel like I am close to getting the automation to work, but I can't figure out how to find that appointment record based on the record ID. Any help would be so appreciated! 

I want to show a shared table view with shared table view link at the office on a TV in Kiosk mode. I have a Raspberry Pi running a browser in Kiosk mode to power the TV. Here’s the question: does the shared view auto-update itself? If I just leave running on TV, and then edit some info in my computer, are those edits reflected on the TV? I guess I could hack the browser to automatically refresh itself, but it would be more convenient if the shared links already worked like that :slightly_smiling_face:

Hi, using the Free version I'm trying to import a  15MB Excel sheet into an existing base with four tables (3-6 records per table) but I get the following message:"testfile.xlsx exceeds maximum allowed size of 5 MB"I assume this is a limit of the Free version? If so; what are the filesize limits of Team and Business versions?

Hello. I'm struggling to find a way to combine the contents of several Multiple Select field into a new field, while retaining the value and color for each entry. Here's a stripped down version of what I'm trying to do: I've got 4 separate multiple select field, each with their own set of options. The field called "Combined Types (Manual)" shows what I want the output to be. How can I aggregate all that data while retaining the color coding for each one? Thanks a lot.  

Hi, I had a question about comment notifications within interfaces. I have a base with a few interfaces all centered around records in one table. Each interface is accessible to a different user group - when one user group @s someone in a different user group - will it email that user if they don't have access to the interface that the original user commented on? and similarly, if they do get an email notification, where will the link take them when they click it?  Thank you!

  One of my bases mentions "Over Limits · 30 days left" / This base has gone over the record limit. To keep adding records, upgrade your workspace.I sill can add new records... what will it happen now?Do i have 30 days to remove or to move records out of the base? 

Bonjour,Je suis en train de m’arracher tous les cheveux qui me restent sur un problème que je suis sur le point de résoudre mais je n’arrive pas à trouver le point qui blesse.Pour schématiser :J’ai un enregistrement d’une table COMMANDE, lié a de multiples enregistrements d’une table LIGNE_COMMANDE.(Le truc classique d’un entête de commande avec ses lignes de commandes).Je souhaite pourvoir “Cloner” via l’automatisation (Quand un enregistrement entre dans une vue spécifique par exemple) à la fois les informations contenus dans la table COMMANDE et à la fois le contenu des enregistrements liés de la table LIGNE_COMMANDE.Quand je parle de cloner, je veux bien sûr préciser que c’est une création d’un nouvel enregistrement de COMMANDE (presque à l’identique car il y aura affectation d’un nouveau n° de Cde) et la création de nouveaux enregistrements LIGNE_COMMANDE liés (identiques mais donc rattachés à ce nouvel enregistrement COMMANDE créé).

I have an automation that is triggered when a user clicks a button in an interface. The automation is current set to simply create a new record in the underlying table, and fill in three fields:user = should be the Name of the user who clicked the button. This is a "User" or "Collaborator" field in the underlying table. I have the user who clicks coming into the script using the input variable selector.status = should be "Assigned" which is one of the possible values in the field, which is a single-select field.string = "string is string" this is obviously a placeholder, but this is just a string.Here's my code:  // Get the input variable let inputConfig = input.config(); let userName = inputConfig.userName; // Define the target table let table = base.getTable('Table'); // Get the list of active collaborators in the base let collaborators = base.activeCollaborators; // Find the collaborator object that matches the