Ask the Community

HI there–this question has come up before but there has been no useful reply from Airtable. Seems like several people would find very useful the ability to remove the “view larger” link from web site embeds. This option takes users away from one’s web site and also I have a private group so I don’t want people outside the group sharing the table with anyone. Can the “view larger” link be disabled? I am a pro member and I’m surprised this is not part of the customization option. Thanks!

I want to store the total number of employees in the programs table to calculate the participation rate. Additionally, I'd like to break down the number of employees by position to calculate the participation rate for each position. I have three tables: Programs, Employees, and Tasks. While I can easily count the number of employees who complete each program or task, I am struggling with creating a field that sums the number of employees from the employee's table and places that total in the program's table to calculate the participation percentage.

Hello everybody,Until know, what I've been doing on my Airtable databases in terms of naming is I use:- the singular for fields that contain only a single valueVS.- the plural for both fields that contain multiples values and tablesEx.: In my 'Invoices' database (see attachments), I use 'Service' in the Line Items table because each line item matches only one particular service, but I use 'Services' in the 'Invoices Receivable' table because there are usually multiple charged services on one invoice.While battling with Documint in order to automate the generation of PDF invoices, I figured that this discrepancy might be the cause for problems in data retrieval.=> Do you have best practices to suggest in terms of field/table naming?I would very much appreciate our help on this one.

Hi Community, Relatively new with Airtable (6 months or so) and struggling to create an automation that in theory seems quite simple, but I've tried everything and can't seem to crack it...ContextI have a table for invoices, where each invoice can be set as either an "Invoice" or "Additional Invoice". the invoices table also has fields called "Original Invoice" (Linked to other records) and "Additional Invoice" (Linked to other records).Desired Automation/ExampleI create a new record in the invoices table (Record B) and set it as an "Additional Invoice", and then, in the "Original Record" field, I link to Record A. (In other words, I am setting that Record B is an "Additional Invoice", and it's "Original Invoice" was Record A) When Record A is linked to Record B as above, I want Record A's "Additional

Hello there, I would like to know how make an automation of daily record updates to the Spreadsheet? I've read some posts in this forum and all of them were asking to use a third party which needs to pay more again. How to do it just in airtable?In my thought, it should be like this- At the end of the day- Check which records are created today- Send every record to spreadsheet- DonePlease help, thank you!

Hey friendsToday when I write in a language supported by RTL (Hebrew or Arabic) the text comes out uncomfortable and unclear when I add a word in English.Is it possible to set my table RTL?

Hi BRO.I had gotten airtable team with two person a year but I didn't used my card and I need only one person a year .Can you refund my money from your company to my card. My account: comein64@qq.comMy reference number: 00803379Thank you for your help.

I'm having a hard time finding a simple script that will allow you to duplicate a record via automation.My end goal:Trigger: When a record matches a condition (i.e. a checkbox is checked off)Action: Run script --> this is where I can't find a script online! I need this script to duplicate the selected record.Just simple as that. Can someone help me? Thank you!

Dear,  I am using the following automation :    It works perfectly fine...but not in every case.Indeed, when the field value contains a space (i.e. "The Demons") or a number within (i.e. The4demons) it doesn't recognize it (even if that of course exactly the same value from a table to another). Does someone have a way to handle this issue? Have a nice day, Arthur

Hi all,I am having a little trouble. I have a base where all my transactions are summarised in a grid view as below.That works like a dream. Now I need to do two calculation, First I need to minus the subtotal Cost of Goods from the Income. I know I cannot do that in this table, but I think I can create another table where I can do this, based on these records. I am just having trouble making it work. I have tried but for some reason the linking is not working correctly.Can anyone help me with some clear instructions how to set up the second table so I can calculate my Gross Profit (once I have done this I will be able to work out the rest).If these is an extension that anyone knows that allows calculation on Subtotals that would be good. I just do not want to have to export to excel each time I update!Many thanks, Mark

When creating an email automation based upon a record being updated, I want to include the name of the person who updated the record in the email. I have used the field 'User who took action - name', but it returns blank for both the preview and live automation email. Why is this? I am logged in and have a name associated with my account.Thank you

Hi everyone, I'm an AirTable newbie but I have some experience in web development. I'm trying to use REST API to implement table which has a server-side pagination. This means I can't preload all the results to get the pagination parameters like total count. Usually, the API endpoint which returns the records would have this parameter. Unfortunately it doesn't exist so I'm wondering how to do this properly without fetching all the results on FE beforehand. Thanks for the help !

Someone is sharing an Airtable with me, not my account, "use this data" available..How can I sync this data to either another table I own or via Zapier to trigger a zap?Or do i need to request they share the table with me another way?Figured someone here would know....

Is there a way to get the list-of-values that are available for a single- or multi-select column?

Hello everyone,I am new to airtable. I have a survey and each question has a single select field option for the answers with a certain amount of points. How can I assign a number to each single select field value e.g. a=0, b=1, c=2 and d=3 so I can add up these points.Hope to hear from you.Thanks  

I need to evaluate whether or not an attachment field is blank with an IF statement. Variations of double quotes and the BLANK() function don't do the trick. Any ideas?

I used the information from my base to create an interface. Now, I’d like to share that interface to the public. Is there a way I can do that?

Hello,This is a variant on an earlier topic. I have a base where users input lengthy URLs into several fields, and corresponding display text in separate fields. I've been using the workaround where a formula field does this calculation: CONCATENATE("[",{name},"](",{URL},")") and an automation takes that field and copies it into a rich-text-formatted long text field. It's clunky, and even clunkier when you have a bunch of markdown formula fields in your base. I'd like to do this with just an automation, but when I try to do it exactly the same way, I get text output like  [Airtable](

Hello, im a long time Airtable User.I can't accept the fact that in order to change the start day of the calendar week it is necessary to change the browser language! I need an easier and more practical alternative, like a button to click: week starts on Monday...I've read several threads with other people complaining about the same problem and it still hasn't been resolved. I imagine it's something simple to resolve, I'm waiting for the solution.

I Just tried Airtable Share View Sync option. Comments in the sourced are not synced to the new table. Is there some workaround or option to achieve this? As I need comments also to be synced into new table.

I am attempting to update multiple records in a single automation in a Synced Table. I am unable to update Synced Records from RunScript as I get 'Error: Edits to synced field "Stories Automation" (fldxxxxxx) are not allowed from this origin'.I know I can use the native update record functions to update a single record, but if I put the items into a list attempt to repeat group I am given the error `Synced fields can only be updated in the last action in an automation. Move this action to the end of the automation, or remove the synced field.`What are the options? I'm considering just using an API call to make the changes directly to the original table but am hoping I can do them locally. 

Hi!I'm trying to display two lines (series of values) in one line chart.Data goes like:Date / Value 1 / Value 21-1-2024 / 24 / 201-1-2024 / 34 / 201-2-2024 / 40 / 211-3-2024 / 52 / 21 So one line displaying 24,34,40 and 52 and another line in the same chart displaying 20, 20, 21, 21 (for same period (X-axis).Is this possible in interfaces? Or is there another way to achieve something like this?

Hi, can Airtable auto fill with alphanumeric sequence? For example, my sequence goes UF-3101, UF-3102, UF-3103, etc. When I highlight the first two cells and drag it down, it just repeated the UF-3101, UF-3102 over and over instead of adding +1. Anyway airtable can do this? Thanks

Hello,I am trying to trigger a script when 'Language' field of given record is empty (record=domain).I want the script to fetch domain's language. I first ask script to convert domain to URL, since the API call works best with exact URL and not domain.But the problem is that script can not properly handle permanent redirects. I 've tried handle permanent redirects by trying to convert the domain to a URL using 'https://www' + domainId + '/', but that does not work. I am getting this error: "Error processing https://viberate.com/: Response status was 301 'Moved Permanently' but redirect mode was set to 'error'" How do I solve this?My script: // Get input variables from previous automation steps let inputConfig = input.config(); let airtableRecordId = inputConfig.AirtableRecordID; let domainId = inputConfig.DomainID; // Set up the tabl

Hello, I am new to airtable. I need help with records. I have created 1250 records in my table even though i am on freeplan. I am not sure if i should add more rows records or not?