Ask the Community

Hi All I’m creating a budget database and need some help trying to figure out how to create a formula in one table that pulls values from another (not even sure I can do this). I have 3 tables: Income table where horizontally the months are listed with a value and two wage types are listed vertically and it is auto-summing at the bottom of the table. I need the combined monthly income to pull into Bill table where each month is listed horizontally and each bill vertically…and the amount of each bill for a given month is listed. Budget to Income table…here’s where it gets messy for me. I need the combined income from the Income table for each month to drop to the appropriate month field… I need the combined value of each month from the Bill table to drop to an expense line by month Is there a way to do this? Emma

Hi, I don't know if it is possible and I don't how to do it, or if it is a feature that is still not available in airtable.I have 2 tables: Reports and Users.I divided the reports by categories (1,2,3 etc), and I created different views for each category.I would like to lookup or rollup the category in the user table based on the different views that I created in the report table. In this way, I will filter the users by the categories, and I can apply some automation. Without this feature, I have, for example a person that has this: I would like, for example, that this person has only the code "5" and filter all the other data based on that.Is there any way that I can do this? Thank you 🙏

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 Invoice" field to be populated (linked with) Record B automatically. - Rather than having to go into Record A, and linking it with Record B manually.If anyone could work out the

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](www.airtable.com)whereas my formula approach gives Airtable  Here's the automation script I'm using. Any advice is greatly appreciated!  let inputConfig = input.config(); let theURL = inputConfig.theURL; let displayName = inputConfig.website; let recordID = inputConfig.recordID; let thisTable = base.getTable('Table 1'); let blank=""; let markup = blank.concat("[", d

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