Ask the Community

I have Budget table which has cost field, variable cost, and month field (Jan to Dec). Cost field has some default amount. Variable cost field is editable which user should give some value(amount).Case 1:Cost | Variable | Jan | Feb | Mar | Apr | ......... | Dec | $60                     $5     $5    $5     $5               $5     Case 2:Cost | Variable | Jan | Feb | Mar | Apr | ......... | Dec | $60      $120      $10    $10  $10   $10             $10     if the client's budget amount is more than the standard cost. in that case, the user will provide the original amount in the Variable field to split the amount into 12 months. but i

Hello everyone,I need help with automation in Airtable. I have two tables: "Needle Tasks - General" and "Needle Tasks - Antonov". The goal is to update records in the "Needle Tasks - General" table based on changes made in the "Needle Tasks - Antonov" table.Here's how the automation is set up:Trigger:- When record updated- Table: Needle Tasks - Antonov- Fields: All fieldsActions:1. Find Records:- Table: Needle Tasks - General- Conditions: Where "General - ID + Project" contains "Antonov Tasks ID + Project"- It finds a record in the "Needle Tasks - General" table and returns Airtable record ID recvhvhDDXVsYTmCc

Hi there,I have 2 tables in the same base, one for adding data and one for report.I want to create a new record in the "report" table every time I add a new row to my "data" table with an automation.BUT I don't want to have a duplicate records. I want to check if the text in the "Name" column in my "data" table matches "Name" column in the "report" table.(if they match - do nothing)I try to do it with "Find records" but I don't quite familiar with it.What is the best way to do it?Thank you.

Hello! I found the "Splitting text to alternate columns separated by ;" thread and was hopeful that it was exactly what I needed, but after trying to implement this formula I am not getting the expected outcome. I'm not sure if it has to do with the format of my data including a mix of hyphens and underscores or if there is something else I'm missing.I have anywhere between 1 to 5 lines of text that I need to break out into their own columns instead of being combined. Ideally I would have five new formula columns that allow me to break these out based on them being separated by "\n" or if that it not possible, I can also add a ";" at the end of each line to simplify the formula if it helps!Example Data:abc_def-gh_ij-x-kl_mno-pqu-first-msg-x-240101abc_def-gh_ij-x-kl_mno-pqu-second-msg-x-240102abc_de

Help me solve this projectits a law firm they have a table with list of questions and a table with list of defendant in airtable they are linked togetherthey want to be selecting a defendant eg caroline then select the questions this defendant is supposed to answer to send out this information we need to create a document with questions and they should be numbered in order

Trying to make a printer-friendly report from a Gallery view that I made. Can’t figure out how to get all records from one table on the same page. Any suggestions? Or is there another block that can do this?

Is it possible to display data from multiple records on a single page in this block?

Hi, I created a form where people can choose if they want 1 or 2 tickets. I have 40 tickets only available. I have no idea how to setup the form and the table so the form close when the 40 are reached.... Any ideas ?  Thank you !

I am trying to figure out how I can get more than ONE record on a page in the page designer app. It seems like you can only have one record per page. I would like to have up to 20 records on one page. Is this possible? Thanks!

I am looking for something like page designer where I can populate variables based on fields in airtable. However, I want the output to be back to back in a single document like notepad. I don’t want to deal with physical page sizes and I don’t want each record on a different page. Is there anything out there?

I know this should be easy, but I'm new to Airtable and apparently missing something obvious.I want to let users add a new contact to my base.I have a People table and a Companies table.  They are joined with a multi-to-multi Roles table [Person, Company, Job Title].I've built a form to accept a new People record, but:1) How do I detect if a matching record already exists.  If it does, I don't want to create a duplicate2) I want the form to also ask for the new contact's company and create a new Role. But, I can't ask for Company in a form on People, If, instead, I put the form on Role, then I can't create a new Person or Company; I can only accept existing ones.My assumption is that I'm trying to force the system to act in a way it doesn't want. And, that's fine. I'm new to Airtable and 100% comfortable restructuring my base to work in a natural way.So, my broader question is: how do I setup a base so

Hey Friends!Got an invoice table that calculates taxes before we send it out. We're in the service industry, meaning sales are done in many different counties.Currently I just have Airtable reference the address to pull the county and apply that county's tax rate.Problem is there's hundreds of different county/city tax location codes here in Washington alone (see below img) and these change every 3 months.We have to manually update them and it's brutal. Anyone know of or currently using a better system for handling taxes? 

Hi,Is there a way to take an existing page designer extension, figure out what fields are displayed on it, and create a table view showing those same fields? The goal is to have a table view where if I fill in every cell, I could then print "all records in view" in the page designer extension and feel confident that every page will be fully filled in. I've been doing it manually by creating a brand new all-fields-hidden view, going into the editing view of the the page designer extension, copying the name of each field and unhiding that field in the view. But there's dozens of extensions and dozens of fields. I assume this could be done with two separate scripts? One to take the page designer extension as an input and then output a csv list of the field names, and one script that takes the list of field names as an input and could create a view with those fields shown and all other fields hidden.

I currently use the Airtable API connection to pull data into Google Sheets. I've gotten an automated message that the API key will no longer work in 2024. Is there a new solution that I can use? 

I want to change a field type from single line text to a multi select. There are 606 records inputted as single line text, but we need to make them multi select as we will be using that data as tags in Softr to create search capabilities. When I go to edit the field, it keeps throwing the error "An error has occurred. Please refresh this page." Refreshing the page does not help. Has anyone experienced this same issue? Please help.   

I know about the various training resources for Airtable. I am wondering what more advanced users may suggest as far as approaching how to apply the tool to particular problems. We are an HOA management group and are moving away from Town Square in order to build our own internal workflow system. Member data, project submissions, complaints, gate access requests, etc. How does one ‘visualize’ a scenario in which AirTable can address these disparate parts to our system? 

Good day! I just got upgraded to Plus for a month. May I ask what happens to my records if I decided to downgrade to free plan? Thank you!

Hi,I am trying to generate an OAuth token via servicenow and I am running into some issues. When trying to get my OAuth token I am faced with the follow error:"error=invalid_request&error_description="state"+parameter+is+invalid.+Note+that+it+is+required.&state=-68948287"I am reading through the documentation of OAuth reference just now (OAuth reference - Airtable Web API) and see the state parameter should follow certain rules and I believe I am not breaking them with the below state value:'Jt8WzfnT7dSbXn2xL1dY.mJq3-UvN4Kz0oGcRbH6pEjViI9Xy_OgZAkCs5lPuehr' I have created a rest message and application registry record for this integration and using the 'Get OAuth Token' ui action withing servicenow to do this. If anyone can provide any help or has integrated sn with airtable using oath tokens before, tha

I have two tables in airtable from the same project in JIRA.1 - Named: "Aurora EPICS [NL]".I made an export (.CSV) from JIRA and uploaded it in Airtable.All registers (139) and its columns (288) was uploaded: I want to update these registers from now on, adding new registers when they created in JIRA and update existent registers when they modified in JIRA. Is it possible?  How?2 - Named "Aurora EPICs - [JQL]".I used the extension "Jira Cloud" (by Airtable) and obtained the same 139 registers but with less columns, only 11.Four doubts:A - Can automatize the connection between AirTable and JIRA in the table #1.B - Can I bring more columns to the "Aurora EPICs - [JQL]" table?C - I trying to use Automations in both case. Is it possible?  If yes, how?D - I'm also trying to use Zapier. Is it a good idea?(for doubts or more details, just answer me back)Thank you all in advance.

Good afternoonStill a newbie to Airtable so I appreciate the help.I have a series of tables that have a "next follow up" column and I'd like to be able to create a table that would show only those with the due date of today.  In other words, it would only show all of my task for that day in the table but the records/tasks would come from multiple other tables within my base.  Hoping that makes sense.Thank you!

I have ordered my fields in a specific way so the most important few fields are shown when looking at the linked record preview, however, I've noticed that this isn't reflected in the mobile app. See examples below (I've blocked out the data for confidentiality).Desktop linked recordMobile linked recordIs there a way to make these the same? It's defeating the purpose of organising them a certain way.Any help would be much appreciated. 

My company has been trying to reach someone from Sales to manage our upgrade to Business but has been having no luck hearing back. Does anyone have a way to get someone from Sales ti get in touch with us?

Whenever I open our Airtable calendar, it opens on July 2018. I realize the solution is as simple as clicking the “Today” button. But does anyone know how to set the default to always open to the current month?

Is it possible to hide the year in a field with the date field type? Right now entries show “4/8/2018” I just need the “4/8”.

Hello,I am trying to make the process of time tracking more user-friendly. Instead of using the duration field and writing manually each time record, I would like to use two single select fields as StartTime and EndTime pickers, each containing values 00:00, 00:15, 00:30, 15:30, 15:45, 16:00, etc.But I am stuck with a formula that makes a magic difference between these two times.Is it even possible with a formula, or does it need to be done with some sort of script?Thank you